Update Main Form Date with Most Recent Subform Submission Date
Hello, I have a field in my main form (equipment info) with the "date of last equipment inspection". I have a subform (equipment inspection) That wheen submitted for a piece of equipment I would like the submission date of the subform (equipment inspection)
Filter by Portal User Reports no longer work
I've had multiple reports that filter the data that shows based on the portal user - thisapp.portal.loginUserName(). They have worked fine for years but a few months ago they stopped working. Currently, no records appear in the report. Also, this is the
How to get Monday as 1st day of the week?
Hi, The first day of the week is Sunday in Zoho Creator calendar.So it is hardly usable as in Europe the 1st of the week is always Monday. How can I get Monday as 1st day of the week? Best regards, Chris
`insert into` Always Fails with “Improper Statement” — Even with Minimal Code
Im develeping my inventory database using ChatGPT to help me and I´m running into an issue in my scan inventory form script when I try to make a form for logging the scanned items. 🆘 Zoho Creator: `insert into` Always Fails with “Improper Statement”
Count the number of subform records associated with parent record
Hello! I have a main form which contains all the details of a particular Issue, and then a subform where we can enter some information about each client who is affected by that Issue. What I want to do is have a field in the main form contain a count of the number of clients who have been affected, and automatically update when a new client's information is entered in the subform. Essentially, just a count of the records in the subform that are associated with that parent record. I've tried variations
Zoho Creator HTML Page
Hello Team, I have a query related to the HTML page I created in Zoho Creator. I would like to apply some filters on this page without passing them through URL parameters. Could someone please guide me on how this can be achieved? Thanks & Regards, Piyush
How to integrate single-sign-on using Linkedin in Zoho Creator
How to integrate single-sign-on using LinkedIn in Zoho Creator need step by step integration.
m2 is converted to Kader when switching from Dutch to English
By default, our company works in Dutch. We sell a lot of products with m2 as a unit. Now we've noticed that if we change the language in Zoho to English, the usage unit 'm2' gets replaced by 'Kader'. We've got no idea why. I'd expect that the translation
Export Data & Attachments
Hi, I am wondering whether it is possible to create an export of all data in creator, including attachments, for either backup purposes, or migration purposes. Thanks.
Inner height of calendar inside a page
I have a page in Creator with 4 calendars inside it. I reduce their height to all make them fit inside tha screen without scrolling(see image blue contour). I would like to remove the scroll INSIDE each calendar. Is there a way to modify the height of
Direct URL to "View Record"
I would like to create a button (Deluge Script) to jump to the "view record" without passing by the record menu, but I can not aford to find the right url. I don't want the "view record" as a single page. I want the "view record" in the application like the picture below: Thanks in advance for your help
Payment before Submussion
Hi, would like to create a form in Zoho Creator, in which at the end a payment is made. Right now, i only can submit the form and then the payment process is started. But the payment process needs to be finished BEFORE the submission of the form. Can
Incorrect Record ID
Whenever I create an entry in my form, the record ID shown in the report is wrong. I have a test script that simply calls zoho.creator.getRecordById after form submission using its own record ID and it keeps returning {"code":3100,"message":"No Data Available"}.
Inner height of calendar inside a page
I have a page in Creator with 4 calendars inside it. I reduce their height to all make them fit inside tha screen without scrolling(see image blue contour). I would like to remove the scroll INSIDE each calendar. Is there a way to modify the height of
Restrict form submissions based on records of another form
Hi, is there a way to restrict submission of one form based on records of another form in creator? For example, there are two forms: one to collect user registration details, and one for a registered user to submit information. If there is not a record
How can I make a part of a form be divided into two columns?
Hi, i have a form, and i want to have 2 columns in the form but not completely, so, the first part of the form have 1 column but in the bottom of the form, i want 2 columns, how can i do? Thank you.
How to Dynamicaly display image in the Detailed View Report ?
I have an "Add Employee" form that includes an image field for uploading an employee's profile picture from their local computer. In the "Apply Leave" form, I also have an image field where I want the employee's profile picture to be auto-populated based
Capture GPS location field
When using a mobile phone to complete the form, I need to capture the GPS location. When this field going to be available? Same question for taking pictures with mobile phone and capturing that picture automatically. Thanks
Deluge Script
I am new to ZoHo, and my company has a form setup to input different data. I am trying to setup a workflow to hide certain form fields from which user is logged on. It is not working (either it does not hide the fields or it hides them for everyone).
Trying to export a report to Excel via a deluge script
I have this code from other posts but it gives me an error of improper statement, due to missing ; at end of line or incomplete expression. Tried lots of variations to no avail. openUrl(https://creatorapp.zoho.com/<username>/<app name>/XLSX/#Report:<reportname>,"same
Add comments to a form
Hello, I'm trying to add comments to a form using a subform with one field named comment, but I don't want prior comments to be editable or deleteable by anyone (except the admin). Is there a way to only display prior comments (with a datetime, user and comment field preferably) but still be able to add new ones when editing the main form? I'm not tied to subforms if there is an easier was to do this?
Custom date filter in report (Up to specific date)
I am trying to add a date selector to a page to filter through a report as shown in this video. https://www.youtube.com/watch?v=Otm3_7jJE7A I want however to make a slight modification. I want to make with the selected date a in between (between today
File Renaming and PDF Export Issues
Using the Zoho Creator app on mobile, I need to rename draft files and export them as PDFs, then forward them to the LINE app. 1) Is it possible to set the file renaming as a variable (from the form's variables)? For example: Customer Name + Date. 2)
count unique records
how to count only unique record with "aggregate records" task in script builder? something similar to .distinct but that return total number of distinct not the list. Example: I have multiple entries with the same date in a date field. I want to count days (duplicate days just count ones)
Zoho Creator not loading
Hello. I can not access my Creator account. After I login, it wont load to my pages, Has been doing this since Friday. I have checked with my I.T dept and cant see a problem on our side. I have also tried logging in via my private laptop and PC and have
submit/upload form as csv
Hello Everyone, I've created a form in Zoho Creator to capture notes, details and images from a monthly meeting. I can't seem to figure out how to ensure the form is uploaded via CSV and into the Zoho Database. Any guidance would be GREATLY appreciated.
Pivot Chart - Zoho Creator
In Zoho Creator, I want to enable an edit option within the Pivot Chart itself. Additionally, I want to avoid showing duplicated values for certain columns. For example, I’ve created a month-wise sales report for each product type. The form contains fields
Building a form with Categories and multiple sub-categories
Hello, I am completely new to Zoho and the Deluge programming language. I would like to build an easy way to lookup a set of previous orders from my order tracking sheet. What I have done so far is import my Excel order list into Zoho so it shows all
Generate a QR code from Form data
Hi everyone, Simple function from which I can't seem to find other people in the same case. I want to create a form with a few fields (client name, product name, date). Whenever the form is filed up, a QR code is automatically generated from the data filled in and available for printing. Is that not possible? Looking much forward for your help! Cheers.
Passing Information from ZohoCRM to ZohoCreator
I've got a use case where I'm attempting to use a button within ZohoCRM to pull a list of options into buttons on creator when page is loaded. I'm pretty well versed in Deluge, but I'm having a difficult time trying to understand how to dynamically place
Problem when condition with lookup field in Zoho Creator
this is my code: if input.promotions1 != null { info input.promotions1; } And this my result: when i info input.promotion1 (which is a lookup field), it turn back nothing, so what type of this field is? normally i use the condition: if lookup_field ==
E-mails to suppliers
Hi, i want to upload a spread sheet every day and send an e-mail to our suppliers every day (or when triggering a button?) with info from the spreadsheet lines. The supplier e-mail would be on each line. Unfortunately, when creating a scheduled automation,
Rearrange web - hidden components
When you have a good number of forms, reports and pages, searching for one among the hidden components to add it to the menu is simply hell. Huge amounts of time are wasted.
Telegram -> Zoho Creator answer via API.
Hello! Did anyone work or established back connection from Telegram to Zoho Creator via API? I'm able to send notification from ZC to TG Bot successfully. (webhook is set) My notification consists of some information and inline buttons "yes" and "no".
SA data center for ZOHO
I think there is an issue in zoho.sa , a lot of apps are not working well
Preview an upload PDF or File
I have a form where the customer has to upload a file (normally PDF - never jpeg) When in report view I want to be able to preview the uploaded file without having to download it. If I click on the upload it downloads to my computer, I want to be able
How to bulk edit on subform field
Hi, It seems impossible to bulk edit on subform field. Is really it impossible? The subform field is well shown on view, and we can search as criteria, but the field doesn't appear in "bulk edit" dialog. Is there any other way for add the same subrecord in all records of a view? Thank you very much, Bernat
Changing the Super Admin in Zoho Creator
I can change the Super Admin for all of my other applications in Zoho One very easily but the change owner button is not available for Zoho Creator. How do I go about changing the Super Admin for Creator?
Where do I get/create the API Key for my zoho app to talk to zoho calendar
So I manage to cobble some code together, but how I sort out the API side things to get the app and zoho calendar to communicate with each other.
signature on PDF too large
Hello, I've set up a record template for my form so that I can print PDFs in the format that I need. My forms need a couple of signatures from our internal staff - BUT the staff do not sign the form directly... Instead, I have a separate form that each staff person signs (one record per staff person) so that their signature is readily available for their regular reports. So, this means that on the form (the one that I create a PDF from) there is a look-up field where the staff person selects their
Next Page