How to set calendar date field start Monday
I have a report displaying record in calendar view. I'm based in europe, weeks starts Mondays. Calendar view shows correct. as shown in the screenshot below To add a record, the form uses a Date field. But this field show weeks starting Sunday. See screenshot
Update Stock Sold
Hi I am sorry to bring this on here but I am really stuck. So I have a form that lists all our products we sell with a field for Purchased Stock and Sold Stock. I have another form for Purchase of Products, which when filled out, updates the Purchased
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
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
Is there a way to see the code in parallel to what you are creating.
So when you are creating a form, or making layout changes you see what is happening in the code. Similar I guess to some website editors, thanks
[Free webinar series] Get to know Deluge: Zoho’s powerful scripting language
Hello Everyone, We are much elated to invite you all to our upcoming session in Zoho Deluge! Bringing on to your table - Get to know Deluge: Zoho’s powerful scripting language Understanding Deluge Zoho’s suite of applications offers robust solutions for
Uploading file to workdrive from creator
Hello I am trying to upload a file from creator into my zoho workdrive but it does not seem to be working. A file does get uploaded but there is nothing when I try to look at it and just gives an error message saying "We couldn't generate a preview due
Setting value while adding new entries to lookup field
I have a question regarding this process: https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/add-and-manage-fields/articles/fields-lookup-allow-new-entries If I set a value for a lookup field while adding new entries, and the form it looks
[Free Webinar] Learning Table Series - Creator for the Healthcare Industry
Hello Everyone! We're thrilled to invite you to the Learning Table Series—a year-long initiative to demonstrate how Zoho Creator can transform industries with innovative and automated solutions. Each month focuses on a specific industry, and this time,
Sorting Grouped Records by Last Opened
So, I have a form. For simplicity, lets say that this form only has a job_name field, a room_name field, and a order_number field. (the order_number field is to input a number for sorting purposes) On the report, I have it set to group by job_name, and
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?
Subscription Pricing for Zoho Creator
How can an organization charge Project Subscription Pricing to the client for Zoho Creator? Could you clear this out? How much do they need to pay for Zoho? If the client needs only 3 users, what plan to subscribe and how much?
Export CSV from published public report
Is there a way to create a perma link to a pull the CSV or other export type for a published report?
Tip 3: How to dynamically filter reports using URL parameters
Hi folks, As part of Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on how to use URL parameters to filter reports. You don't always have to play with filters to drill down reports. Yes, that's right. You can pass URL parameters to set filter values and view only the required data. This technique is quite useful while linking reports in an email, a document, or when bookmarking an important report that you would like to view on a regular basis. For example,
Find form by inline subform criteria
Is it possible to filter down to a form using inline subform fields? For example, I have a Contact form with an inline subform "Phone_Numbers" that has a "Phone_Number" field. I'd like to be able to get contacts by their phone number, but I'm not sure
Disabled virtual keyboard in handheld device with barcode reader.
Hi I created a APP try to scan barcode by barcode reader bulid in handheld device. But creator will jump virtual keyboard. Could you provide a setting to disable virtual keyboard for single line or number field in Creator android and Iphone.
Unable to Duplicate Zoho Application
Dear Zoho Support Team, We are facing an issue while trying to duplicate a Zoho application. When we attempt to do so, the process does not complete and instead remains stuck on a loading interface. To help you understand the issue better, we are sharing
Pass page variable via ZML execute function
I am attempting to pass page variables through the parameters field of a zml element utilizing execute function, but it does not appear the page variable is getting parsed. Am I missing something? <pc padding='25px' hAlign='left' action='ExecuteFunction'
pdf export of form data
Hi , I have 10 form pages in one application of CV in zoho , i want to export all these form data in one pdf document with well formatting(resume) , how can i do that ?? Looking froward for your reply soon Pavan
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
Problem passing map to function
Sry for the long post. Including all documentation. Zoho is triggering the following error when I try to pass a map to a function, and I can't figure out why: Error during validation: Error at line : 14, Function specified in criteria has returned null
Disabled button until field workflow executed finish in mobile
Hi In stateless form I change value in one field and this field have a workflow execute a lot of code. but before workflow finish if I click the button . Creator will cause a error. Cloud you Disabled button until field workflow executed finish in mobile
Attach image from Creator Subform to Deal
Can anyone help me figure out how to attach an image from a creator subform to a Deal? I have read through all of the documentation and can't find anything for my specific scenario. Everything I have found is attached from the Creator form (not subform)
Time field is empty text in pivot chart report
Hello all, I am currently trying to create a pivot chart, where the y-axis is supposed to be a total sum of time. The problem Im facing however is actually using the field, where my metric is stored. It shows up as a simple time field in the form builder.
Creating Packages
Hi I am trying to create a database for my company. I need to create packages from individual products. I have added products ie item 1, item 2 and item 3 I need to create a package where Package A will have items 1 and 3 Lookup only adds one product
Copy Creator file field to CRM file field.
Hello, I am trying to transfer the content of a Zoho Creator record afer form submission to a new CRM deal record with a deluge form worklfow. I am trying to see of I can transfer the files fields. creationMap = Map(); if(Revendeur == "IEL Technologie
Zoho Creator Page, how to display detail view of a record
Hello, i am not that knowledgeable in coding and am trying to figure things out as i go. but i am trying to get it so that when a user clicks on a "Page" i have in zoho creator, i would like it to display the detail view of a record assigned to the logged
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
Creator Simplified #12: Track the no.of button-click downloads
Hey Creators! We're here with yet another episode of Creator Simplified for you! In this post, we'll see a workaround to count the number of button-click downloads made in the report. Usecase In a training app, students can download the course material
Getter error message Number of statement execution limit exceed Line:(216)
Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range) displayname = "Pay Period Details" content <%{ /* Get The current Pay Period Record */ Int_Pay_Period_ID = PayPeriodID.toLong(); Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID]; Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID); /* Checking Agent
How to Add Portal Users in Zoho Creator's Development Environment for Testing?
Hello, I’m working on a Creator app with a customer portal and implementing filters based on the logged-in user (customer). To test these filter functions, I'd like to simulate or add customer portal users in the development environment/database. Is there
Report support List data.
Hi Could Report support use list data? I hope I can create a list with deluge and push to a report. It will increase efficiency .I don't need insert data to a form.
Get Creator Form Record ID and Subform ID's
Good Afternoon everyone. I have a Creator form with a on success workflow. I'm trying to get the form record ID and the subform record ID(s) but they keep coming up null. There is data in the subform I use it elsewhere. Can anyone help me pull the ID's.
WhatsApp and Zoho Creator Integration
How we have integrate WhatsApp App with Zoho Creator without using external application ?
Initiate data import using Deluge script
Is it possible to open the screen to begin the importing of new records using Deluge? So for example, my users would click a button on a form that starts a workflow action. This action would then open the screen to "Import Data for Current User Projects".
Lookup field - Can I avoid using advanced search?
I have a lookup field in my app that has surpassed 500,000 records, now basic search is disabled and I'm forced to use advanced search. That adds multiple steps to what used to be very simple. Before: Select field > Type last digits of product code and
Next Page