Assuming info is required, the following 132 results were found.
-
if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank Preceding is TRUE"; }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
time comparisons - Map Xero tax rates to Zoho tax rates (same names in Zoho) - output to console if debug mode enabled More Information: http://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate = 12345.545; info "Rate: " + v_Rate; // built-in rounding v_Rounded = v_Rate.round(2); info "a) " + v_Rounded; // Yields: 12345.55 // Regexed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to smallest in "yyyy-MM-dd" will usually handle the date better. Consider the following: v_TestDate = "07/01/1975"; info v_TestDate; info v_TestDate.toDate(); info v_TestDate.toString("E, d MMM yyyy"); info "*********************"; // // regex change...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else { r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; //info "Production Mode"; }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.3 // same expression again but with a different...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_CountTotal + 1; l_GoalKeys = m_GoalRecord.keys(); if(l_GoalKeys.size()>0) { v_GoalKey = l_GoalKeys.get(0); //info "Record ID: " + v_GoalKey; // m_ThisGoal = m_GoalRecord.get(v_GoalKey).get(0).toMap(); //info "Goal Record Data: " + m_ThisGoal;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
but as of February 2024; I have been able to test and implement this. Consider the following code: try { v_Test1 = "Foo"; info v_Test1.toLong(); } catch(e) { info "Couldn't convert 'Foo' to an integer"; try { v_Test2 = "Bar"; info v_Test2.toLong(); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Lipman) - Initial release Date Modified: 2025-09-29 (Joel Lipman) - Deletes existing images in the image upload field More Information: https://help.zoho.com/portal/en/community/topic/export-zoho-analytics-chart-with-api-in-deluge...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
upload file to workdrive r_WorkdriveUpload = zoho.workdrive.uploadFile(f_File,v_TargetFolder,v_FileName,true,"zworkdrive"); info "Workdrive response:"; info r_WorkdriveUpload; if(!isNull(r_WorkdriveUpload.get("data"))) { // // set permissions to public...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
between v_UnixSeconds = v_NextEpoch - v_NowEpoch; // // determine days v_Days = floor(v_UnixSeconds / 1000 / 60 / 60 / 24); info v_Days; v_UnixSeconds = v_UnixSeconds - (v_Days * 1000 * 60 * 60 * 24); // // determine hours v_Hours = floor(v_UnixSeconds...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to ZohoSign Document record Date Modified: 2024-08-21 (Joel Lipman) - Creates a recipient and event record in CRM More Information: https://www.zoho.com/deluge/help/sign/get-template-by-id.html Scope(s): ZohoSign.documents.ALL, ZohoSign.account.ALL,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_CustomTime = "2020-03-25 20:41:07".toTime().toString("yyyy-MM-dd HH:mm:ss"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; info v_CustomTime.toTime(); info v_ExpiryTime.toTime(); // yields // 25-Mar-2020 20:41:07 // 25-Mar-2020 00:00:00 Example of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_EndIndex = v_XeroTime.indexOf("+", v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 17:00:00 Chained v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_LastMonthDate.addDay(v_DayIndex); if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } info "Start Date (Current Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End Date (Current Year): " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
(Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment endings: eg. $100.00 == payment approved 00...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
} else { r_BooksEstimate = zoho.books.updateRecord("estimates",v_BooksOrgID,v_BooksEstimateID,m_CreateEstimate,"zbooks"); } info "ZohoBooks Estimate REQUEST: "; info m_CreateEstimate; info "ZohoBooks Estimate RESPONSE: "; info r_BooksEstimate; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
record ID of the order Outputs: - Date Created: 2023-03-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: Error 7008: There are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ for each m_Tag in m_ContactDetails.get("Tag") { m_Tag.remove("id"); l_Tags.add(m_Tag); } } info l_Tags; // if(l_Tags.size()>0) { m_Params = {"tags": l_Tags}; r_AddTags = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Deals/" + p_DealID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *