Assuming which is required, the following 337 results were found.
-
and then add the subform afterwards (insert into [...]) but it can be done all in one go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer)....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
How? The quick answer is buried in Zoho documentation and due to the 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
(string) Give it the following code, though you will need to replace the AppOwner, AppName, FormName and connection name (which has scopes "ZohoCreator.form.CREATE" and "ZohoCreator.report.CREATE") v_AppOwner = "myCreatorAppOwner"; v_AppName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
part I struggled on was uploading it to CRM. I want to update the photo in the CRM record. How? So we have to do the usual which is download the photo using invokeUrl then we set the paramname not to attachment but to file. We then use another invokeUrl...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: ${CONTACT.CONTACT_DISPLAYNAME} ${CONTACT.CONTACT_ADDRESS}...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I wanted to retrieve a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
add to this article if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of the subforms in each record: // select a bunch of creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
So I'm going to cheat, by setting up a PHP script on a server we own to return a 200 status: Have a hosting server ready which has SSL installed. Add a PHP script with the following code (change the webhooks key to your own - and REST API function URL):
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you can use the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= v_HtmlEntityNames.toList(); l_HtmlEntityChars = v_HtmlEntityChars.toList(); // // add these exceptions (quotes) which wouldn't convert to a list l_HtmlEntityNames.add("quo"); l_HtmlEntityNames.add("apos"); l_HtmlEntityChars.add("\"");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the sales order to an invoice and created a package slip for it. The invoice was then sent (payment=unpaid). Not sure which fixed this. {"code": 4,"message": "Invalid value passed for JSONString"}: Quick fix by settings the parameters in the invokeUrl...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to retrieve a field from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
upddated" but "When any selected field is updated" and then selecting the fields "Status", "Balance", and "Notes". (not sure which one fixed it but I now add all three): Error(s): Workflow did not trigger and did not receive even the email included in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
How? We would think it similar to a picklist/dropdown where you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
record, clicking on the ellipsis or three horizontal dots button in the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead, we've been asked to create a button that sits on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Started Fill out the client ID and client secret along with the Grant Code Click the button and you will get a refresh token which you can copy for the next step. STEP 4: THE REST A Zoho Flow would submit the request ID and document ID as part of a map...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field that has the value you want to display. Under "Show Value...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
API, it is not currently connected to ChatGPT. The plus side however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics of setting this up would be to setup a bot in ZohoCliq and then to edit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *