How do add more than three columns In creator.
Hi there, I am recreating an Excel quote form in creator, and part of that form has multiple columns that are needed how do I do this in creator, thanks :)
Popup / Expand option not showing for Subform with less than 20 rows in Zoho Creator
Hi Folks, I am working on a project. Where there is a subform with around 15 Columns. In order to see other columns, we need to scroll to the right. We have a popup option for Subform, with which we can view the subform data in a popup view. But the issue
Fetch Records within a Date Range
This seems like it should be an easy thing to do, but I can't get the syntax right. I want to fetch all the records in a form that are within a certain date range, say the last six months. I have seen syntax like this rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; referenced here: https://www.zoho.com/creator/help/script/fetch-records-within-range.html I do not understand, however, how a range for Added _Time can be an integer like 1 to 5. I would think if it as a date-time field.
Restore Deleted Records
Today I was the victim of accidentally bulk deleted records. The process to get them back is onerous, long, difficult, and almost impossible. I would love to request the following feature. The record audit tool is a great tool and can show me all the records that were just deleted. It would be great if you could add a button next to each record that was recently deleted, to restore that record. And maybe even select many of them, and then click restore to the whole group. This would make it so that
Making form fields mandatory dynamically - input of one field changes if a field is required or not
Hi all, I am trying to see if there is a way to dynamically change if a field is required or not - I found some forum posts from years and years ago about workarounds and showing alert messages, but nothing that was recent so I wanted to see if it is
{"4834":"Invalid Ticket Id"} as response of ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials");
Today all fetchs to zoho crm give me the error {"4834":"Invalid Ticket Id"} All calls that I made are of the style ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials"); crmResp = zoho.crm.getRecordById(("Accounts"), input.Cuenta_ID); etc. I have found some post with this issue and it seems that it's related with the auth token.... but i don't know what i need to do to fix this issue. Could you help me?
How to add or reduce the number of columns in a form based on the value of a field from another form ?
Hello, I'd like to know if it's possible to add or reduce the number of columns in a form based on the value of one (or more) fields from another form. The idea would be to be able to have a form with date columns that would vary according to the company's
How to restore values of a deleted field?
Hi, Lets say I'm editing the development environment of an app. The app has a form, I deleted a field named "field1". But in the production environment, there are several records of the form that contains values in the same field. Now in the dev environment,
Zoho Creator's v2 API GET Record - Detail View Missing Fields
As the Title said. I tried to use Flask request.get() and Postman and both of them only showing a some of the fields availiable. It seems it's showing what's in the Overview and not real Detailed data fetching. How can I get this field? I feel Detailed
Duplicate a row in a subform
Hello, I want to either duplicate the previous row that has been populated in a subform or better still copy some of the fields using code. Any ideas? Is this possible?
Passing data from form to subform
I have successfully passed data from Form to Form and subform to subform but cant find any information on how to pass from a form to a subform. Let me explain; I have 2 forms, A and B. Form B is embedded into Form A as a subform. I want to achieve the
Try to get a work flow to work on CRM
So the work flow is meant to send a reminder e mail 40 days before the contract ends. Tried a few things and cant seem to get it to work, also is there a way of testing this instead having to wait for the trigger time. Thanks
[Free Webinar] Learning Table Series - Creator for the Technology Industry
Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various
Upload Image from ZOHO Creator to ZOHO CRM
#Tips & Trick of the Day data = Ar[ID == 4227213000000688005]; myImage = data.Site_Picture.replaceAll("/sharedBy/appLinkName/", zoho.appuri); myImage = myImage.replaceAll("viewLinkName", "All_Ares"); myImage = myImage.replaceAll("fieldName", "Site_Picture");
Formula field not working properly
I have an input field "Basic" and some other fields and one formula field "Total" in a form. When I input data into "Basic", then an workflow runs (on user input). The workflow populates some values and puts those into other fields. The formula field
Formula fields do not update
Hi, I've found that the Formula field does not update it's results dynamically if any of the data changes. I wondered, are formula fields supposed to update? Many thanks, Katie
Issue in Zoho Creator in Billing Page
Hi Team, I have found an issue on the billing page in Zoho Creator. In the application usage, I noted that the ‘User Connection’ usage appeared twice.
Matrix Choice - Is it possible in Creator?
Does anyone know if creating a matrix/grid choice type questionnaire is possible with Creator? I wasn't unable to find anything via KB or Forums. The only mention of things similar are over 10 years ago and appears to have gone nowhere. By matrix choice,
Any way to refresh publish page?
I have published page that include: 1 - stateless form (published) 2 - report (published). the stateless form has a field for user input and a button. I've created workflow for the stateless form button click that do some updates for the records showing
Zoho incorrectly interprets incoming email Content-transfer-encoding when charset is not UTF-8
In nordic countries (Norway, Sweden, Denmark, etc.), Microsoft Outlook default setting is to produce email headers like this: Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable or Content-Type: text/html; charset="iso-8859-1"
Boolean operators
Why can't I use != (not equal to) when comparing 2 booleans?
Tip 33: How to create custom forms and reports using widgets
Hi folks, In this month's tip, we're going to talk about how to use widgets to create custom forms and reports in your Creator application. But, before that, let's cover a few basics. What are widgets? Widgets help you extend the capabilities of your
Get form name?
Hi Zoho, Is there a way to get a form name (to be used in the "On Success" script)? Something like the formdata function, but for the form name... Thanks! Ravid
Creating a local text file with deluge script
Hi, I'm looking to find a way to create a text file on my local disk with deluge script. Just want to put text field in a sample.txt file. Anyone has a tip on that ? Thanks, Pascal Veilleux
How to change name of the portal user
Hi Team, I am not able to change the portal user name. By default, it is taking the email prefix. Is there a way to give or update name of the portal user?
Increase or reduce the number of columns when creating a form, depending on the value of a field from another form.
Hello, I'm wondering if it's possible (via Deluge, Workflow, Blueprint or whatever) to make the number of columns, when creating a new form, depend on a value entered in a field from another form. In this way, with the same field, you could decide to
Microservices Missing in Zoho Creator
I'm listed as an admin for Zoho Creator but I can't see an option for Microservices. I need to manage connections and from the kb articles, it would seem admin permission is sufficient for this. I'm an organisation admin in Zoho one if that means anything
How to fix this error
// Get the selected user from the form selectedUser = input.Meeting_With; // Fetch the email of the selected user from the User list attendeeEmailList = Users[Full_Name == selectedUser]; // Check if a valid email was found if(attendeeEmailList.count()
Adding a customer specific record to customer subform
Hi, Can anyone point me in the right direction I have customers as a form with all their details on it. I also have separate jobs, tasks & assets forms that I can also fill out, now when I create one of these records let say for Customer A - I fill out
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
Zoho Creator | Panel not saving after editing keeps on loading.
How to use different print templates for the same report.
I have two record templates that I have set up to be used for printing a PDF, but it seems only one of these can be associated with a report's detail view "Print" and "PDF" buttons. Is there any way to access the second template from detail view, or do
How to embed public report in html snippet
Hello, I want embed public report in html snippet. If i add iframe, the report button-urls are not working(navigating). How can i acheive this. <div elName='zc-component' viewLinkName='<string>' params='zc_Header=true'>Loading View...</div> if i use above
Potential migration from NetSuite to Zoho One - this customer of ours is in the Custom Decorator industry
We have a customer for many years on NetSuite, and they may be interested in migrating to Zoho One. Since they are in the Custom Decorator industry (they purchase products into inventory and then apply logos, pictures, etc to those products as part of
Improving Zoho Creator's email deliverability
Hi all, We're pleased to announce updates to email handling in Zoho Creator to improve the deliverability of the emails sent from the Creator platform. These updates have been designed keeping in mind the fact that emails from domains with strong sender
Subform is possible for OCR ?
Hi Folks, I am wanted to track invoice details using OCR AI Field. but i am faced challenges for track details on subform, because my invoice have one more Quantity, rate... How Subform using in OCR AI Field. image attached for reference. Thank you for
Creator Page Transparent Background
Is there any way to make a Creator page have a transparent background? I only see that I can change the color.
Page Refresh After Report Popup Closure
Dear Zoho Support Team, We would like to inquire if it is possible to configure a page to refresh upon closing a report that opens in a popup window. Currently, we have added a button to our page, and when clicked, it opens a report as a popup. Our requirement
Use Zoho Analytics tables as data sources for Creator apps
I am currently using Zoho Analytics to create reports using data generated from a 3rd party web-based case management system. It would be very helpful if users in my organization could create applications/forms using data from the Analytics tables and
Issue with Fetching Data from Zoho Creator using Custom Outlook Add-in
Hi Team, I am encountering an issue while trying to fetch data from Zoho Creator in a custom Outlook add-in. The goal is to retrieve origin and destination information from a specific report, but I'm facing CORS-related errors and failed requests. Error:
Next Page