I need to connect Zoho creator and Postgresql
I think I can use Zoho Creator's invoke URL function to get and post data to postgres database. But for that I need API endpoints of Postgres. To generate api i tried to install postgrest. still can't connect. it will be very very helpful if someone guide
Is it possible to add a comment in Zoho Creator record native comments section via API?
Is it possible to add a comment in Zoho Creator record native comments section via API?
How to get matching data from one report and compare to another
Hi, I am trying to search the uploaded data in Report B for matching rows in report A and get a sum of the records in Report B that match the Luxury column criteria in Report A. Report A contains the Luxury column criteria that is hidden in Report B,
How to auto populate from admin(Staff) user input?
I have created a form for students. The corresponding staff (Class teacher or adviser) need to fill student details. I haven't set any mandatory fields(except email). The staff can fill more details if available. When submitting the form the mail will send to respective students with form link. Students can update their information. I have given permission to access the student form to the student. when student login to student form the data given by staff is already pre-filled. How can I do that?
Time only field
I see that there have been several attempts to get a Time Only field created in Creator over nearly EIGHT YEARS and still no update. It seems to have a lot of interest and the workarounds using the Date-Time field are onerous and unnecessary for a seemingly simple field. What is the timeline for this? What do we need to do as a community do to move this up the work chart? I love the app but this is holding me up creating some very useful apps for my travel and transportation industry. Cheers, Steve
QR code generation - Zoho CREATOR
I have been searching for a while now - cannot find solution for a simple problem. I need to generate a QR Code based on the input in a form field: Say, on user input in the "Code" field is AIRW-7777 (string), a QR should be generated as an image in the
Ticketing for an event
Hi, We are organizing a fundraiser in July and wanted to know if you have a ticketing option on your portal.
Where do I start?
Hi all, This is more a pre-sales question, but also a "point me in the right direction" question. We currently use QuickBase to manage all of our clients, budgets, finances, CRM and more. It's lacking quite a bit in the CRM function and it silos a lot
Help with nested Json
I've seen this same question answered in the forum but after hours of trying I'm still not getting it right. I have a nested Json that I need to extract some data from. The Json looks like this: { "objects": [ { "name": "numero_movil", "objectType": "field",
The Userfield nightmare
Currently, the Zoho Creator User field is almost useless, here's why: The userfield display a auto generated username instead of the Staff/Volunteer/Client/Supplier actual real name. Making, in its core, unusable in any professional/serious situation.
Way to update the data?
I was wondering something I made a pivot table using a 3 a SQL query table that combine 2 data sources. So this table as filters and all the data I want. But i was wondering if it would be possible for a user (given the proper right) to have some sort
Extended timeouts for APIs beyond 40secs for to accomodate LLMs
A 40 second max response time for API calls is fine when connecting to most services, however is unsuitable when dealing with LLMs (ChatGPT/Claude/Gemini) where the response timing is very uncertain. Is there any way to increase this? It would be great
Feature Request: Recycle Bin for Creator Records
I would like the option to be added to restore deleted records from views / reports in Zoho Creator. If records are mistakenly deleted or if a scheduled maintenance task goes wrong the outcome can be disastrous, I appreciate that there are backup options
Parsing nested array into a Json
Hello, I have some inquires I would like to make in reference to the code below, We are using Blancco API, to populate reports from Blancco into our form, after mapping out the key values, we are using the get() function to populate the data; Example1:
Dark mode for Zoho Creator / Zoho CRM Code editor
Hi Team, Is there any plans for Dark mode in Zoho creator / Zoho Crm code editor and development pages in pipeline?
Field Type: Address, Change District/State to Dropdown with picklist??
Using the Address Field type, is there a way to make the District/State field be a dropdown with a picklist so the users can select rather than type the state name every time? I know this can be done if I use a drowdown field for the State (or entire address information), but that isn't as tidy as using the address field type. I apologize if this is a duplicate. I posted this question the other day, or so I though. Can't find that post.
Pricing calculator
Alright, so I'm trying to create a pricing calculator/pricing report generator to use in a cabinet shop. I did all the logic and such, and the calculator works. I have a few other things that I would need it to be able to do though, I'll do my best to
Autofill Creator published form with Dyanmic url params
I have a published form that I want to embed in my organization's website. The page url that it will be embedded to has the user's account number appended to it. How can I access this parameter to dynamically fill a field for my form? I have achieved
Unable to obtain LONGITUDE & LATITUDE by using GeoCode Function
Hello, I am creating a Travel App, where customer is booking a Car from his Current Address to Destination Address. By using the Geocode function, I want to confirm the Address is correct and get the longitude and latitude values. However, I am getting
how to dynamically upload multiple images for single record?
Is the use of dynamic multiple images in a single record supported? I've searched but have not found the answer. If it is supported, how is it done? I saw 1 suggestion to add a sub-form but that doesn't seem to be the answer. I don't want to add a set number of image fields. Each record would have a different number of images. I want the addition of images to be dynamic. thanks
How to set one dropdown field values based on selection of another dropdown value.
I need help setting up forms in Zoho Creators to automatically fill the "Delivery Person Number" dropdown with options relevant to the chosen "Transport" dropdown selection. In another form, each transport option is linked to multiple delivery person
Filter a lookup field by another lookup field on a subform
Hello all, I am trying to filter a lookup field based on the selected value of another lookup field--both on the same subform. I tried storing the ID (of the first lookup value) on the form and on the subform but cannot access it. If I store the ID on the form and set the filter to "ID == input.myID.tolong()", I get a runtime error. If I store the ID on the subform and set the filter to "ID == row.myID", it says "row is not defined". Right now, I have both fields unfiltered but, as I get more data,
What counts as a "Deluge-based workflow requests" and other deluge workflow limits?
I realized this workflow seemed to stop functioning so I looked up limits and discovered there are some limits such as "workflow requests" and just some arbitrary line limits. Luckily I have a lot of wiggle room on the lines currently since I had been
Sending a PDF of a Zoho Creator Page via Email.
Hi, first time poster. I have made a type of Calculator using Zoho Creator that uses a bunch of input > Some background magic > and then spits out a Quote in the form of those Page fields in Creator. I used Pages based on the amount of things I can change
workDaysBetween
Is there anyway to get around the workDaysBetween function not being able to count work days between dates if they are more than 360 days apart?
Dynamically autofill fields with URL parameters
I have a zoho form embedded in my organization's WP website. Our users find their account with a search tool, and then can select to open this page with the embedded form. The URL of the page holds the parameter that I need, but I cannot figure out how
Access specific row of subform
I have a form that has two subforms within it. Basically, I want to access data from a specific row(the row will have a Main field set to "Yes")in the first subform to use as data in the second form. So what I'm having trouble with is accessing the specific
record_cursor
I'm working on api call using the v2.1 api. When I use record_cursor in the header to get the next set of records, the returned call is ignoring the field_config: custom and fields: {field} parameters. This behaves the same in both Postman and my sc
Deleting the Records in all blueprint stage
Hi all, we have developed one lab app to catch the all data from the patients and lab teams.It have separate module like DNa extraction, Accessiong etc.. each have the different bleprint stage.On the Same time we have developed another module called Cancellation
openURL multiple parameters- tip
Hi, I'm writing this up as a tip because I worked it out while I was writing the question... update- THIS DOES NOT WORK- sorry, will update when I figure it out! I have some stateless forms and I am trying to bring some data across from Form 1 to Form
Zoho Applications not working
Team, We are facing issues in several zoho applications since more than a week now...The applications are not loading most of the time or not working at all like zoho meet, zoho mail, zoho creator. Please check as this urgent.
FILE TREKING SYSTEM
Dear Sir, Please start FTS portal - Gudamalani branch Due to previous ops executive resign and new ops join of below Emp. code- 43605 / Rahul Kumar So please Start and update my emp code in zoho portal - 43605
Subform records from one form to another
I have a form “Add Item” (Screenshot attached). I have another form “Purchase Order” which has a subform “Item Details”. “Item code” is a lookup field of “Add Item” form’s “Product code” field We need that when the product code is selected, the code should
Public forms, but requiring authentication
We are implementing a system which already has single sign on with Google Accounts, and now we would like to embed Zoho forms in it. Is it possible to make a form public (no invitation required), but to require google account authentication to fill it in, so that the variable zoho.loginuserid has a proper value? and if the user already has an authenticated google account cookie, use it, without prompting for user password? thanks, Gabriel
Link to a Document Upload Field
I'm trying to link to a specific field in a report that is a document upload field, is there anyway to do so?
How to create an xml and post it to a Url?
Hi, Can anyone help me in providing tutorial or detailed procedure on creating an xml using deluge script that takes some of the input paramenters from the form and post it to a URL for getting some response?
Zoho creator - ajouter les infos de zoho crm avec le champs RECHERCHE
Bonjour à tous j ai fait ma connexion zoho creator zoho crm . Dans zoho creator je veux selectionner dans le champ RECHERCHE une societe presente dans Zoho CRM COMPTE. J ai pu faire le necessaire et les noms des comptes apparaissent, cependant j aimerais
Dropdown choices based on selection from another dropdown
I have a form with two dropdown fields. Is there any way that I can have the dropdown choices for the second dropdown field change based on the selection from my first dropdown?
Need to clear specific row of Sub form.
Hello everyone, We need to clear specific row of subform in creator while user giving specific input.based on input row need to be deleted.
Function Code Not Working
Can someone tell me what is wrong with this code? It says it executed successfully, but nothing happens. I believe I have all the field and form links correct. void undoButton() { for each a in Memory[Undo == "Undo"] { if(a.InOut == "In") { insert into
Next Page