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
Zoho Creator and Zoho Sites Member Portal
If I navigate to: Zoho Creator - Application - Settings - Customer Portal - Configure Portal - Portal URL It says I can choose a custom domain on my website. For the domain, Is it possible to host the portal on a page within my zoho sites member portal? For example, my clients would log in through my website’s member portal, select a page, that page would be my zoho creator app. That way my clients would only have to log in once. Thoughts?
Setting a Primary Key?
I'm new to Zoho Creator. How do I set a single line field as the primary key for the form? Thanks Mustafa
Adding "Select All" manual option via deluge to a drop down Lookup
I have a single select, drop down lookup field that I would like to manually add a "Select All" option too. The lookup values are from another form/report and will change, but I would like "Select All" to be always added and at the top of the list. This
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
SaaS > New user set up itself its new account > Can I achieve with Creator?
Greetings, I hope find all doing well and safe! Now a days, the most part of SaaS works as a self-service, so in general, a new user access a website (for instant Zoho, Microsoft / Office 365, Trello, Box, etc) click on a "sign up" link after read a nice
Populate Creator dropdown with values from Analytics data source
Hi, I want my dropdown box to be a list of customer names, which are synced from my sql server as a datasource in analytics, but I cannot seem to find a way of doing it?
API for Appointment Management
Hi There, Has anyone had any experience in setting up an API for the Zoho Creator Appointment Management App? We are wanting to create an online booking system, we are wanting our Ecommerce Platform (Shopify) to do an API call on the Appointment Management
Are the new record comments (the new Oct 2019 feature) programmer-friendly?
Thank you, Creator team, for this awesome new update we have been looking forward to. Our customers will be excited to learn about this! Meanwhile, one question on comments : can we access/modify comments using Deluge script? If yes, it will be wonderful if you can share the documentation on the same. Hope this makes sense. Crafted with ❤️ Zoho Gurus | Zoho CRM Practice Team @ CubeYogi Zoho Authorised Partner 7+ Yrs | 200+ Projects | 100+ Customers
Fetching information from existing record when populating form
We have 3 forms: Form A (has multiple existing records) Form B Form C When Form B is submitted, we want it to automatically open Form C and then: 1. Using a field in the submitted Form B, find matching/existing record in Form A 2. Insert information from
Custom Formulation in Dashboard
Hi, In Dashboards when I am adding I can't use any special formulas. like sum(tables)/sum(Tabley) which is very critical. Sometimes we need such calculations to see the average kg or price. For instance, when I buy any item for multiple times , I have
Combine two forms for pivot table report
Hi, I am not able to solve the problem which is described in the pdf file that is attached. Please kindly help me with this, Thanks, Ahmet Karagoz
Published form move right and left when swiping
Attached screen record. is there any way to fix it?
Filter Records based on Oraganization
In Zohocreator Scenarion: Parent Organization have multiple branches Sales person should be assigned to branch(Example A) and he can view brach(A) level records not other branch records. So how can i achive the above scenario. Thanks in Advance
How can I increase the number of calls a node js function in one deluge script?
in Zoho creator call a node js function 5 times in one deluge script.How can I increase the number of calls a node js function in one deluge script?
Filling out a pdf
Hello, is there a way to fill out a pdf document based on the data input into a creator form. The data would be used to enter into the pdf. Has anyone had any experience with this or have any ideas? Thanks in advance for your help.
Error
Hi, getting this error {"code":3000,"data":{"ID":"4035633000003741003"},"error":["Error details: Error in executing On Add - On Success script Given string is lesser than the applied boundary, so index out of bounds exception arisen Line:(1)"],"message":"Data
Working with ZOHO rest API for adding records using Postman
Hello, Im using android studio to create an app for one of my tasks in zoho, for this mean I have to use ZOHO APIs to insert and edit records. Beforehand, im trying to configure and see how the api would respond and for this mean im using Postman as; POST URL: https://creator.zoho.com/api/<ownername>/json/<application_name>/Report/FormReport/record/add and parameters as; authtoken -> https://accounts.zoho.com/apiauthtoken/nb/create?SCOPE=ZohoCreator/creatorapi&EMAIL_ID=<Email>&PASSWORD=<Password>
Next Page