Assuming string is required, the following 148 results were found.
-
up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
:= v_NewFile "." A_LoopFileExt } v_NewFile := fn_Slugify(v_NewFile) v_NewFile := fn_MD5(v_NewFile, true) "_" v_DisplayName StringLower, v_NewFile, v_NewFile ; find the foreign key v_ForeignKey := "-" v_FKCount := 0 GuiControlGet, SearchExtFile,,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_LeadCreatedTime = r_LeadDetails.get("Created_Time"); // // convert to time datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Triggered on an invoice type change Purpose: Prepares the invoice as a deposit invoice or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to retrieve this data: /* ******************************************************************************* Function: String fn_PushPerformanceToAnalytics(int p_RecordID) Label: Fn - Push Performance Data to Analytics Trigger: Workflow when an objective...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
name of tax rates and then the percent that these equate to which I've copied below this invoices pull function. the Code string standalone.fn_Xero_GetInvoices() { /* *******************************************************************************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this case the percentage rate: string standalone.fn_Xero_MapTaxRates() { /* *******************************************************************************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
TO JOOMLA v2.5.x -- -------------------------------------------------------------------------------- -- NOTE: Replace string "mydb_livecopy_j15" to your Joomla 1.5.x database name -- -- -- (example: "anolddatabase") -- 9 occurrences -- NOTE: Replace...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
'/access_token.dat'; 2b. Specify the impersonator Now for testing purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
- Needle1 NeedleMarker := Needle2 ReturnedHTMLTable := SubStr( Haystack, Needle1, NeedleLen ) ; split the table into rows StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A ReturnedHTMLTableRows=%ReturnedHTMLTableRows%...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the following three special characters _ (underscore) . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name ---------...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
a map: info m_Response.get("item").toMap().get("item_id"); // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
parse these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app (in Xero under Manage App > Webhooks) v_Webhook_Key =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
New Function Give it a function name, I'm calling mine fn_ZohoBooks_Estimates_AcceptDecline with the parameters: p_Intent (string), p_QuoteRef (string), p_CxID (string) The display name I'm giving it is Fn - ZohoBooks - Estimates - Accept/Decline It's a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
t2.`extension`='com_content' SET c1.`catid`=t1.`id`; -- Joe-Code: LIST Rows to be affected (for test purposes) -- SELECT SUBSTRING(a.`name`, 1, INSTR(a.`name`, ':|joe')-1 ) -- FROM `v34_db`.`v34_assets` a -- WHERE a.`name` LIKE '%:|joe|:%' -- Joe-Code:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
field (EditText) Store the input in a TextView (invisible or visible) held in the calling XML /* 201411041253 */ private String hangar_aircraft_name; public void editHangarAircraftName(View view) { // get current value for hint TextView currentName =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)". If there isn't create a New "String Value", name it "(Default)" Double-click this string value and...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *