Assuming string is required, the following 141 results were found.
-
m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","To");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
:= 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
- 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
- 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
- Language: *
-
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
-
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 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
- Language: *
-
",", $term); $out[] = $term; } return $out; } # prepare for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # eg....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
s WHERE WEEKDAY(s.DateTimeCreated)=0 AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Monday', ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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: *
-
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: *
-
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
-
by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
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
- 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
- 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
- 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
- Language: *
-
A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF