Associate correct user with API transactions
Hello- I have a Zoho Creator application that performs actions in Zoho Books and Zoho Inventory via the REST API's. For example, one transaction we perform is creating packages in Inventory. Currently I have Connections set up in Creator that are authorized
How to use link in message of sendemail task
Hi, I am trying to use a tag and href for link inside the message, but it is not working. like sendmail [ from :zoho.loginuserid to :client_email subject :subject message :""<p><a href="https://www.w3schools.com">Visit W3Schools.com!</a></P>"" ] i have
How do I fetch and input data from parent and child form?
I want to transfer data from a parent and it's child form to another form. I drafted this code but it throws an error once it gets to the child form fields. What am I doing wrong? if(Master_Database[ID == input. Number].count() > 0) {
Invoke URL With Zoho Creator and Multi Part Form Data
Hi, I have been trying to get an external API working with Zoho creator, I have managed to get loads of different API's working fine over the past few months but I have a problem getting the syntax right for this specific API. I think this is the first
Two Way Integration between Salesforce with Zoho Creator is Possible Using Zoho Flow ?
Both way synchronized Integration is required. For Example, 1. Create/Update - Data has to be pushed from Zoho Creator to Salesforce. 2. Create/Update - Data has to be pushed from Salesforce to Zoho Creator. Is that possible to achieve this using Zoho
Reloading the page while redirecting to internal link using openUrl
I am changing the portal user role from deluge as shown in https://help.zoho.com/portal/en/community/topic/tip-28-how-to-auto-assign-profiles-to-portal-users on submission of a form and redirecting the user to another page in same tab. With new role,
Zoho Creator API v2 Sort Order
Hello, What are the correct query string parameters to change the sort order of my GET records request? I can't find this documented anywhere. I have tried the following, but get a 401 error: https://<base_url>/api/v2/<account_owner_name>/<app_link_name>/report/<report_link_name>?from=1&limit=1&sort_order=<field_name>&sort_by=desc
Filter Reports based on Company Region
I am working on an application for a mortgage lending company. This company will have regions servicing homes in different areas in the United States. Borrowers will be the ones creating records in the user portal, and those records will be assigned to
Print multiple pages with page parameters at once
Hi all, I have a dynamic page based on the parameter passed through the URL. I can print it to PDF using a default setting in creator, but is there a way to print all the pages created from all the parameter values at once if I have a list of all the
Is that possible to give different application access in the workspace to the customer portal users ?
Dear Team, Please refer to the below requirement. Is that possible to give different application access to the customer portal users ? For example, Once I logged into the customer portal credential I want to access the different application in the workspace.
Is that possible to delete the customer portal users automatically using Custom Function ?
Dear Team, The requirement is, We have one registration form for the customer portal users to auto assign the portal permission. If the same user is requesting to change the portal permission. I have to change the old permission to current requested permissions. How
Property folder in payload has a value that does not match schema
the graph API request to create a folder in one drive is POST /me/drive/root/children Content-Type: application/json My code: callMap = Map(); callMap.putAll({"name":"New Folder","folder":"{}","@microsoft.graph.conflictBehavior":"rename"}); headerMap
Adding a row to subform at a specific position
Using the "insert into" function adds a new row to a subform field at the end of the subform. Is it possible to insert the new row at a specified position in the subform field rather that appending at the end?
Zoho Creator - Development
Dear all, I'm new to Zoho. This is in regard to Zoho Creator and Extension development. 1) In the Zoho Marketplace, there are many Extensions (and custom apps) available for sale. I'm wondering what programming language is used in Extension development?
Adding values to a multi-select field with deluge
Because subforms will only create new rows, I'm using deluge to recall information from a form into the subrows to mimic the behaviour of updating a row rather than creating it. I have a multi select field called "locations" that is a list of locations
API Greater Than (Zoho Creator)
If I make this request, it works, returning all records for 12-Jul-2022 https://creator.zoho.com/api/v2/xxxxx/certification/report/Rapport_d_taill?Date_field=12-Jul-2022 But I then add a > https://creator.zoho.com/api/v2/waterprotec/certification/report/Rapport_d_taill?Date_field>=12-Jul-2022
Query Parameters for "Today"
How do I put Query Parameters equals to "Today" for date field in page when we put Open Report as action?
Options to re-filter report
Greetings, I hope find all doing well and safe. I have a report that list All Customers. There is a field "status" with values Active or Inactive. The report is filtered to load only with Active status. I would like to get an option to the user see the
lock some records at a subform
Zoho support told me there is no way to disable for editing some records on a subform, based on field's value of that same record. Can someone think of a workaround to achieve this? Thank you!
Commission Calculator
I am looking for some help with calculation commission for my business. I have a Form called Policies and a form called Renewals For each policy, there will be 1 renewal each year, and commissions are paid on the total premium of the renewal. However,
Sum value from Json response
Hello, is there a way to get the sum of all qtaconsumption values in the Json response below with a function like sum() instead of having to do a for each loop to sum each value? Can't figure a way to do it with sum(). {"historyQuota":[{"time":"2022
Error code 2930 : unmeaningful message
Hello, I wanted to get a specific record from a report in Zoho Creator with a function in Zoho CRM. I have created a connection and used a simple zoho.creator.getRecords(with arguments). The response a got from that was a : {"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."} Function executed successfully Is it possible to understand where this error comes from so I can efficiently correct the source code? Thanks
Logging task time in Creator
Using Creator I want to be able to log in task time. For example: If you are assigned Project A to work on and in Project A you have Task 1, Task 2, and Task 3 to complete. You're going to work on Task 2 so you log in your date/time and at the end of working on that project you log off your date/time. It will log that time and put it in that particular task. Then the next day you come in to work on Task 2 again and once again will log in and log out the hours you worked on that task that day.
How create audit logs or history of report ?
How create audit logs or history of report ? I know there is logs option for the same and check with selecting form; but we need in report. How ?
POS system of Restaurant
Hi Team Is it possible to create something like POS for an Restaurant management providing access for reservations of table, keeping track of reservations, and adding orders for the reserved tables using existing Restaurant Application of Zohocreator.
Function Inputs in Report Filter
Is it possible to pass a field into a function in a report filter? I have a use case where employees are broken out into different branches based on geographical region, however there are certain regional managers that reside over multiple branches. I'd
can we add deluge code in condition
Hi, can we add here the dyanamic date, before 1 day Day of Interveiw start date in condition ,... ??
function as a filter criterion works in some reports and not in others
In several reports I use the same filter that is the value returned by a function.It worked fine until recently. Suddenly now in some reports it works and in others the criteria of the type: "thisapp.MyFunction ()" has been replaced by "<FUNCTION ()> " and does not let me change it.I have already contacted the technical service and they have been checking it for days but at the moment no solution. If anyone has any ideas, help is appreciated.
Report based on subform entries
Can anyone help me with how to create a report which shows data from a subform please, which I can export to a spreadsheet? When I do it, it only shows that there is a subform rather than the data within it. Thanks.
Trying to create a ZML snippet to show a forecast of revenue
I am trying to create a ZML snippet to show a forecast of revenue based on a count of records from a form from a different app. The app name: latxoperationslivedispatch The form name: Today_s_Truck_Assignment Date and Time: MMM dd.yyyy /12-Hour These
Dashboard data from deluge function
Hello, I'm trying to figure out dashboards so this might be a very basic question. Is it posible to display a gauge element using data obtained from a Deluge function instead of stored in a form? For example if I want to check the status of a customer's
Passing HTML Parameters to embedded forms
Dear All, I have already asked this question but I had no answer. I know that with the usage of openurl I can pass parameters from Form to Form and from HTML Page to Form. So if a form contains a lookup, with the usage of openurl I can pass this value to a lookup or a single line in the second form. Now my question, if these two forms are embedded in two Zoho HTML Pages (one HTML with the first form and the second with the other form), is it possible to do to the same?? I think no... As an example:
Deluge Script - getUsers method
Hello, how can I get Zoho CRM Users from Zoho Creator Deluge Script? There're methods like getRecords, getSearchRecords, etc. and I can even create a lookup crm-integration field taking choices from Zoho CRM Users module but getUsers method seems to be not present.
How to Obtain Filename of Image Taken by Camera for use in Deluge Script
I have a Form that stores a photo taken by an Android phone's camera in an Image field ("Photo_Field"). The URL of a sample photo in a Report ("Donations_Report") is shown below: https://creatorexport.zoho.com//wdccruise2/donation-receipts//Donations_Report/3301895000000030003/Photo_Field/image-download/1493307808504_Photo_27-Apr-2017_11_43_21.jpg How do I obtain the filename of the image (jpg) file to include it in a Deluge script? (The script will display the Image in a Note field when I open the
Help with encryption functions
I'm trying to replicate this PHP function in Zoho Creator's Deluge: $digest = base64_encode(hash('sha256', $nonce . $created . $userApiKey,true)); The variables $nonce, $created, and $userApiKey contain strings which should be encrypted with SHA256 in
How to filter data retrieved from Zoho People for Creator current user and fill form fields?
Friends, I am looking to import Employee details from Zoho People to a form in Creator and I'm not sure how to go about doing so. What I would like, is to have the required details from Zoho People pulled and populate the into the corresponding form
Count rows in subform based on a criteria
Hi there, If I use the following script: count = 0; for each line in Subform { count = count+1; } input.count_field = count; How can I set a criteria to only count the lines in the subform that have a specific field?
Search by QR Code
Hi! I'm testing IT Asset Tracker in order to edit records after scanning its QR Code. I am able to set the QR Code editing a record, but I can't find a way to search by QR Code. In docs there are explanations about filling inputs scanning QR codes, I watched a video where the user loads record data in a form after scanning a QR code ... but I just want to open to the record edit view. Does anyone knows a way to do that? Thanks in advance, regards
Is it possible to build and export a Creator App On premise into a Catalyst account and use the SaaS features?
Now, with Zoho Creator On premise, I was wonder if is it possible to build an app and export (set up) it into a Catalyst account to use as a SaaS, is it possible? https://www.zoho.com/creator/help/on-premise/cloud-vs-onpremise.html
Help with Dashboards
*New to the creator Im trying to display weekly productivity numbers in the dashboard per region. My Form fields: #hours (billable hours) Available hours ( number of available hours per employee per week) Productivity (formula field) #hours/available
Next Page