... Standalone function triggered on execute
Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening
Date Created: 2023-02-02 (JoelLipman.com ...
... // get existing subform with only the displayed rows (not been deleted)
var l_existingSubformRows = ZDK.Page.getField('Deployment_Rate_Log').getValue();
// loop through to exclude any rows ...
... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function.
How?
If we're not going to use loops, then the next best thing ...
... replacements
m_HtmlEntity = Map();
m_HtmlEntity.put("&","&");
m_HtmlEntity.put(" "," ");
//
// loop through each of the above replacing where found
for each v_HtmlKey in m_HtmlEntity.keys()
{
v_StringToDecode ...
... check if events was in the payload
if(!isnull(m_Body.get("events")))
{
//
// parse events out of the webhook (a list)
l_Events = m_Body.get("events").toJSONList();
//
// loop through the events
fo ...
... are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can ...
... + "-03-08 02:00:00");
//
// Ends First Sunday in November at 2:00
v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00");
//
// loop through each day in a week to get the start ...
... 32;
//
// set to the Account record of our organization
v_OrgAccountRecord = 123456789012345678;
//
// loop through all users
r_Users = zoho.crm.getRecords("users");
if(!isnull(r_Users.get("users")))
{
for ...
What?
Just a quick article if you get the above error and what to look for.
Why?
I was writing a function with perhaps too many for each loops within a for loop.
How?
The following is 1 ...
... dates
l_AppointmentDates = List();
//
// initialize Start Date
v_GivenDate = '2022-07-21';
//
// setup list to loop through (= number of days)
l_NumberOfDays = ;
//
// start with first date to ...
... a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge:
First of all, here's the HTML SELECT dropdown I ...
... Shopify using a Product SKU. Community forums could only suggest looping through all the products.
I then felt that actually I just need the Product IDs. This method could do with some refinement ...
... the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+ records? ...
... = 0;
m_ShippingAddress = Map();
// set field api names that we will read from and write to
l_CrmShippingAddress = ;
l_BooksShippingAddress = ;
// loop through the CRM Sales Order address field ...
... to assign the sales person.
How?
So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead.
In the next ...
... pair of double-quotes.
Why?
Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge ...
What?
A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice.
Why?
Whether ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.