...
The Solution/Cause
So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names:
// select a bunch of creator records ...
... Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that ...
What?
This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...
... m_Record.toString();
}
Without a regex solution and the replacement back to commas then the above outputs:
Actions
Do you want to get rid of the annoying escaped double-quotes ...
... been checked.
Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have ...
... invoices). Our solution: Send all Zoho invoices in API call to Xero... apparently it can accept up to 60 invoices in one call.
How?
Crazy simple solution, your JSON needs to have the key "Invoices" ...
... how to do this and it takes about an hour to go through the documentation and get a working solution.
How?
So the article below shows how to do this Zoho CRM and how to do it in Zoho Books...
...
... searchRecords function requiring it's 5th parameter which defaults to "not converted" records:
=zoho.crm.searchRecords(,,,,,);
The solution:
The long answer/investigation is
getting a JSON response ...
...
How?
Well as always, I'm going to cheat. My solution here was to simply repurpose a decision box field in Creator; then re-style it to look like a button; then add a workflow on click of this field. ...
... you want to the detail view of the report you are accessing.
The detailed resolution is:
Create a duplicate of the report with the records you want
Click on "Detail View"
Click on "Layout"
Select ...
... in the Creator system.
Alternative Solution without CRM
A proposed solution has been to create a Zoho Creator form and publishing this for public use. Then giving Shopify the URL to the form and ...
... and documentation, I found a solution which worked for me. Note that usually I could customize the receiving PHP script to receive a JSON request and process it that way but my usage was to send data ...
... Solution
So as a quick overview, this is what I did:
Create a ZohoCreator form (I'm calling mine in this example: Download File to hold the file and some other fields
Owner Email (type: Email)
FIle ...
... NameLast NameID
Joel Lipman 1
Another Person 2
How?
This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. ...
...
The trick in this solution was more about the process and what that process was.
Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that ...
... a Mac with admin privileges which would open the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the ...
... forums that do cover this but it takes me so long to find the solution with the right syntax.
How?
So I'm going to start with 1 method and then update this article with other methods.
Method ...
... back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work ...
... took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it.
...
... or
v_UnixSeconds = v_MyDate.unixEpoch();
info v_UnixSeconds;
Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date.
Source(s)
toTime() ...
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.