Assuming used is required, the following 202 results were found.
to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number of lines used would be an improvement. This is how I was doing it previously. // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date...
Let's start with the first PHP file which I will call functions.php. Note that you will need to edit the global vars to be used by the functions located at the top of the script:
» Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response =...
v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)";...
and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of,...
had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used...
to setup an OAuth connection: ERROR_Invalid_Redirect_URI Solution: The redirect URI in your app does not match the redirect used in the authorization request. They need to match in both irrespective of the value. Consider trying to get authorized and...
need to tweak to display in a way other than the previous preview images. You can change the shape, content and colors used for the on/off switch but try to keep the on/off css section to preserve functionality: /* On Off Switch CSS */ .onoffswitch {...
instructions follow a fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual...
Important: You should now have at least 2 CNAME records against this domain/subdomain. I usually have 3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME...
"status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to update the record: { "response": { "message": "Error occurred",...
info r_AssociateMultiUserLookup; Another method to check for API names is to query the metadata in the linking module: // // used for checking api names and the linking module (not visible via the interface) v_Endpoint =...
(GUI). Note this would probably be similar to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the backend...
are going to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some...
a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked was...
record: I'll leave it up to you to parse that mess but the Shopify webhook payload is now in your Zoho Creator! Having used this for a while, we average about 5 seconds from when the Order is updated (with payment?) in Shopify to when it gets parsed and...
CRM. For demonstration purposes, these have been simplified and will need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when...
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 snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons...
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 Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest...
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 a list of all the listed active products in a fixed price...