Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 Add an Audit Change field: This will contain the code triggered when one of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment dates l_AppointmentDates = List(); // // initialize Start Date v_GivenDate = '2022-07-21'; // // setup list...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Copy Subform to other Subformshttps://joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( , ); // insert the rows into the subform through the variable...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time Settings); so as soon as you try to insert a date time...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 variable and will contain all the webhook payload data. When a webhook is pointed at it, the crmAPIRequest variable will hold the payload. Same with responding with the variable crmAPIResponse. Don't overthink it, just accept it. Less headaches for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SSRS Border Problemhttps://joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 and sometimes a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" pane, find...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB