Adding Data to Subform via Node.js API in Zoho Creator.
I hope you're doing well. I'm currently working on a project in Zoho Creator and facing a challenge with adding data to a subform using the Node.js API. While I've succeeded in updating data within the subform, I'm unable to find a solution for adding
Update Record via Report Workflow not Triggering Zoho Flow - Workarounds?
According to Zoho Creator support, when a Creator record is updated via Deluge, it will not trigger the "Record Updated" Zoho Flow trigger. Has anyone else here ever run into this? Is there a workaround that doesn't involve me maintaining two separate
Export/import portal users - names not preserved (or exported), only email address -- can't match to imported ownership
I am trying to transfer data to a new application. When I export portal users only the email address is exported. When I import them in the target portal, the name that is associated with the user does not match the name in the original portal. Unfortunately,
Weird account stats
Can someone tell me how this is possible lol It says I'm using 2 out of 1 applications, and according to this, I'm way over my storage limit, but it still lets me upload more files.
Whitelist Zoho Creator IP Address
Hi there, For a 3rd party service i need them to whitelist my ZC app ip. I couldn't find a list of Static IP's. Is there any? Thanks
Add dropdown options via form
Is there any way that I can have a form with a text field, and when I submit the form, it adds the value of the text field as an option in a dropdown field in another form?
Issue with Publishing Changes in Zoho Creator
Hello Zoho Support Team, We are facing an issue with the publishing feature in our Zoho Creator app. Previously, when we made changes, they were highlighted in green and red. However, for the past few days, this feature has stopped working correctly.
Adding 'member portal' member to form.
Hi, I'm new to the Zoho universe (and not a web developer) and I am currently trying to add a form to my Zoho site. I've started building a website with Zoho Sites and have managed to activate the member portal, as I want signed-in users to have access
Connecting Zoho DataPrep with Creator as a Data Source?
Currently its not listed as an available Data Source for Creator, We have a FTP connection set-up to get data from a client database, I just want to know if there a way to link it up to a Creator's form with workflows as the data source? So that we can
Hiding date field [dd-MMM-yyyy]
ZHC is showing [dd-MMM-yyyy] next to my date field. How do I prevent this?
Looking for what code to use to link two Creator apps using Functions
Let's just say i have 3 programs Creator's CRM Creators "lead management" Creator's "Sales Management" I would like to enter a new lead in CRM, and have it "upserted" over to "Lead management" instantly on submit so, if i'm creating a new lead, in Creator CRM, it creates it over in "Lead Management" and If i'm Editing a old Lead in Creator CRM, it Updates it over in "Lead management" but, i want it to go both ways. so that if i create a lead in "lead management", it also creates in "Creator CRM"
Zoho Creator and CRM data source integration
I am trying to create a portal for clients to give us information. I need to be able to associate their creator portal accounts with their CRM IDs so that CRM data source forms would be prefilled with what we know and then can be updated with new information
Creator Integration with RDBMS
We are currently extracting data from Creator using REST API. We load this data into our data warehouse for analysis. However, the product page lists Databases under Integrations. Is there a direct database integration available for Creator? https://www.zoho.com/creator/integration.html?src=hdd
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
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:
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 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?
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
Next Page