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
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
Filter a Zoho Creator main report by a field and display other related reports in sections on a Zoho Creator page
Hi, How can I filter a Zoho Creator main report by a field and display other related reports in sections on a Zoho Creator page? Part of what I was given below is setting up sub-reports, but the subform field prompted me to link a form, not a report.
Display an uploaded pdf in zoho creator record template
Is there a way to display an uploaded pdf in a record template? Functionally I'd like it to work like the image field does. Not sure if there is a way to utilize a rich text field to do this or not.
Generating Reports with Data from Unlinked Forms in Zoho Creator
Hello Zoho Creator Community, I'm facing a challenge in creating a comprehensive report. I have multiple forms in my application, but they are not directly linked through lookup relationships. I need to generate a report that includes data from these
How to get data from a file that is saved on zoho work drive to then update creator app.
So we have a few machines, and they have a consumables. There usage is tracked in a file, I would like to pull that data from the .ini file and import it into the zoho app so we can keep track of usage, is this possible with flows and how would the data
Countries and Towns - Lookup Multi Select
Hi, Sorry I'm new with Zoho Creator and Deluge. ---------------------------- Form A = Countries Form B = Countries and Towns (with relation) in a Form C, i have a lookup field "Country" and after user input, i would like to auto populate the lookup multi
Print template in list view
Hi, is there any special way to use a template when printing in list view? I have followed the online examples, but can only get it to work in summary view so far, which is no good at all.
"Invalid entries found. Please correct and submit again." error needs to be clearer
Hi Zoho, We have had many users email us in frustration because they get the "Invalid entries found. Please correct and submit again." error and get angry because all they see is an unclear error and they think they have to start over. They are not aware that there is a red error message on the field indicating the problem after they click OK. Many are abandoning the form. Please add information to this error such as: Invalid entries found. Please correct and submit again. Click OK to go back
Lookup field, odd issue
So I tried creating and app that has the names of engineers so I can use that for a lookup in the other apps that are being created . I add the look up in a new app, launch the app and when I try to fill out the form its just blank in the drop down menu
Date Range Field
Hi Guys Does anyone know how I can create a date range field on a form? Cheers Chris
Calendar Overflow in Open URL popup
Hi everyone, When Opening a form which has a date field in openurl popup, this happens. Is there any way I can change the calendar width and height or is there any other possible way this can be changed? Thanks.
Assistance with Code to send email on subform data
I am trying to trigger an action off the successful submission of a form that emails the details of the subform to a distinct email. This subform is setup as another form in the app and I can get the below code to work: for each subrow in input.New_Payment_Subform
Link Images to a Excel Report
When I export to a spreadsheet. How do I get it to create a link that goes to my image. Right now it shows up in Excel as: /sharedBy/appLinkName/viewLinkName/fieldName/image/1510098844838_Image_07-Nov-2017_18_54_03.jpg
Emailing lookup field but placing this as an ID or number rather than text
Hi there, First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code. We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form. In
Update Multi select field values to another form table as individual record
Hi, I am new to coding and do basics within deluge. I need help with the deluge script to meet the following requirement. Form Student Attendance The fields are : Attendance Date Course (Lookup to Course Form) Class (Lookup to Class Form) Students (Multi
How to call a Creator function which is in a different Creator application?
How to call a Creator function which is in a different Creator application?
Creator Subform to CRM Subform
Hello all, Has anyone successfully written data from a Creator Subform into CRM subform? I have a Creator form that once submitted creates a new Location in the CRM. Inside a Location there is a subform for hours of operation. I collect those hours in
Multiple date selection
Hello, we want create app for our company. We need create tasks for our employers. For example - 1 employer have task every Friday the whole year. Second have task every Monday for 6 months. For simple way create Multiple date selection in date form
How to find the number that appears most often in a list (the Mode of a list)
I have a list that contains a list of 5 string values. I want to find which value is repeated most often and place that value into a single line text field Example List1 = Learning,Learning,Shaping,Leading,Learning In List1 the value “Learning” appears
For each loop with available time slots
I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:
Can the code in my "Successful form submission" WF be invoked from a function?
Can "Successful form submission" be invoked from a function? Data gets into a form manually and programatically. My code in "successful form submission" is good and I want to reuse it/call it, from another function which does Insert Into How to achieve
Load form in iframe without header
I am trying to load a form into an iframe without the header, but I am not having any luck. I am using openUrl() to load the iframe with the form URL and zc_Header set to false, e.g. #Form:Add_Case?zc_Header=false but it is still loading the header. Any
Next Page