What?
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party.
Why?
The use-case scenario is that our Creator server ...
... start in CRM format
v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset;
//
// set system/application date time start in US format
v_CustomerAppointmentDateTimeStart ...
What?
This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store.
Why?
The use-case was that I wanted to retrieve ...
... isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different.
Having spoken to Zoho and raised with ...
What?
This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...
What?
A quick article to explain why the full name might appear in the last name field in Zoho CRM.
Why?
We had a customer report the issue that sometimes the full name of a contact was appearing ...
... you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already ...
... alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question ...
... > Connections)
Click on "Add Connection" and click on "Zoho OAuth"
Give a lower connection name, eg. "joels_connector"
Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ):
...
What?
This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge.
Why?
Sometimes you might need this when data mapping fields from one module ...
... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...
...
type: GET
connection: "joelconnector"
];
Additional
I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of ...
... time field in Deluge
So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error:
v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ");
// ...
What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
... // init
v_Output = "";
l_BadWords = ;
l_TimesTried = ;
// loop through times you will chance it
for each v_TimeTried in l_TimesTried
{
// init
b_BadWordFound ...
... to generate the infamous JWT. If you've been trying to check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying ...
... of code below is using the functions to read data from Zoho CRM and to write data back to the system.
Why?
I've rewritten this code a few times and want to store the finalized version (following ...
... = "00/01/02/03/04/05/06/07/08/09/10/11/12/13/14/15/16/17/18/19/20/21/22/23";
hourList = hourString.toList("/");
v_includeInPicklist = false;
for each index timeSlot in hourList
{
timeSlotStr ...
... on the code.
How?
So the plan is:
Declare the functions.
Authenticate on page load by checking timestamp in token file:
If token is required, redirect user to Consent page and rewrite token ...
Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app
where we need to subtract funds from one account ...
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.