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
Is it possible to add 2 sums from 2 apps?
I am converting from an old app to a new app. I have a report which currently pulls information from the new app and the old app and then I just have a "+" sign in the middle. Is there a way to make Zoho do the math from 2 separate apps? The code is listed
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
Display selected subform records on HTML view
Hello, I'm having trouble on importing data from a subform to a HTML view. I want to display each row of the current subform into an HTML view. On sucess I pass the ID of the current subform this way ReciboID = input.ID.toString(); openUrl("https://creator.zoho.com/29david.montero29/gestion-escuela/#View:Prueba_3?IDactual=" + ReciboID + "", "Same window"); Then I fetch the record.... <%{ IDnum = input.IDactual.toLong(); Recibo = Escuela [ID == IDnum];%> Inside Escuela is the subform LINEAS_ESCUELA.
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
Subform Data in v2 REST API
What is the mechanism for adding subform data in the Creator v2 REST APIs? There is nothing documented in the Data APIs documentation (https://www.zoho.com/creator/help/api/v2/). I was able to determine how to GET the subform data by adding it to the
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?
How to add image to the forms to have better visual design?
Hello, I need it is very important to add some icons or photo in the forms when we add fields. I couldn't find that option. the image field is only for uploading to database not for visual design. thanks TRANSLATE with x English Arabic Hebrew Polish
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>
Calculate hours
Looking for the following function. Example, Employee worked from 3p to 7a whats the total hours between 11p to 4a
Callback URLs
I need to connect to an external service through an API that requires me to provide a Callback URL so that a status update can be sent back when the API request has been processed. Is there a way to do this in Creator without having to use a middleware
Functions : Can I pass a value from a page parameter to a function ?
I have pageparameters that set "startDate" and "endDate" example : https://creatorapp.zoho.eu/MYCOMPANY/MYAPP/#Page:Home_Generic?startDate=01-Jan-2021&endDate=31-Dec-2021 I would like to use a series of functions in panels in that same page - can I read
Subform : Recall existing data into subform - not create new data
My use case is that I have a multi-select field where I want users to be able to choose locations that already exist and bring them into a subform to edit. The subform is linked - not an inline one. The multi-select field and the subform are the "locations"
getDate from String ? Should be easy
This should be so simple, yet I'm having issues. I'm passing a date to a page parameter and then want to pick the value up for some labelling. The URL is passing : ...#Page:Dev_Home_Generic?startDate=01-Jan-2022&endDate=31-Dec-2022 and I'm trying to get
How to cancel On Add Row event?
Is there a "cancel Add Row" type syntax in the On Add Row subform event that can be fired? My use case is this, I want the screen to send out an Alert saying that some fields are not filled out in the master/main form when the user clicks on the "Add" link in the subform and then remove the new row in the subform. So in my On Add Row action, I have checked the condition say: if (input.Field1 == null) { alert "Field 1 in the main form needs to be filled out."; cancel Add Row; <===== Of course
Run Creator Custom Function in Flow?
Is it possible to run a custom creator function from Zoho Flow?
Please make SPLIT FIELD LAYOUTS more web-responsive on desktop
I find that whenever I split fields into 2 or 3 columns (within the form design view of Zoho Creator), the live form never looks good on a desktop browser. Some fields in each column are spaced appropriately so that everything is in view, while others
check info before Syncing two Subforms
Hi i have a secondary form that dumps its info into a master report. The secondary form has a subform and there is a corresponding subform in the main report CASE: Main form alreayd has ONE SAMPLE_ID listed on it User submits on secondary form adding
Next Page