How much of Creator is Low-Code [a discussion]
The following table is my take on how much of a low-code environment Creator actually is. My takeaway? The minority. I welcome your edits and comments! Record Event Created C Edited E Created or Edited CE Deleted D Hide, Show, Enable, Disable, Set Fields
Viewing details for : maximum Customer Portal User
We have recieved the following message : Hi there, You have reached 90% of the maximum Customer Portal User permitted for this account. View here Upon reaching this limit, the associated actions will not be permitted in your apps. We recommend that you
Approval flow from update
Hi, i'm setting up an approval flow in Zoho Creator. However, it seems it's only triggered when submitting a brand new entry. We have the situation where the entry is already created, but approval is requested when a certain field is updated. Is this
Customer Permissions
How can I restrict records access for customers? Right now, customers in the portal can see everything another customer enters. I want to set permissions so that customers only see/edit/add their data, not anyone elses. I can't do that in the permission
Zoho Creator - [Free Webinar]Learning Table Series for Agriculture
Hello everyone! For the month of September - Bringing on to your table - Zoho Creator for Agriculture 12 Months 12 Industries Agriculture Industry The agriculture industry is the backbone of our food supply. It encompasses everything from planting crops
How to auto populate fields based on an entry?
I seem to run into brain fade right when I need the answer most. And when I'm about to go out of town. Thus I'm asking an easy question that I can't find through forum/help searches. I have one form that starts with a radio button with 5 possible choices (called "Team"). The following fields should be auto populated based on the response to to Team: Team_Head_Coach (5 possible values) Team_Coach_Email (ditto) Team_Coach_Phone (ditto) If a new record is being entered and the user choose "Team 1"
Code that insert attachment to zohobooks expense
Hello there, i already did code to insert attachment into zoho books projects, so i copied the same one and changed the values to expense and it doesn't work, so i need a help to send an image from zoho creator to zoho books expense as attachment, could
Auto populate field when creating new record in lookup field.
I have 2 lookup fields on my form, new repair request form, one lookup field for the customer and one lookup field for equipment. I already have the customer and equipment forms connected with a bi-directional relationship and only the equipment related
Passing a parameter from a URL to a Form in a page
Hi, I can see you can easily pass a parameter from a URL to a form, simply by putting: xxxxxx/?Field_Name=Value I have tested this and it works passing a parameter to a form. I have created a Page, and embedded the Form within that page. The page has
How to create a new sales order from deluge?
I have a creator app that creates a new sales order. For the line items, I'm specifying the product Id, quantity, rate, description, and the item total in the following code. subformRows = List(); subform = Map(); subform.put("product_id", "2728329000000450184");
Zoho Creator Save Drafts or Tricks
Hi, I would like to ask if there's a way to increase the number of saved drafts or is their other way to do like how this drafts do? TIA : )
Is it possible to fetch a list of data based on a criteria?
Hello, I'm new to Zoho Creator, so I'm unsure if its even possible to do so. So I have 3 forms: Form Name 1: F.Forms Form Fields : F.Name Form Name 2: M.Forms Form Fields 1 : M.Name Form Fields 2 : M.Connection Form Name 3: FT.Forms Form Fields 1 : FT.Name
How to create a new record in Zoho Creator via Node.js code
Hi, I am running a workflow via Pipedream and I need to create a new record in Zoho Creator with node.js. I have gone past authentication, but I am very new to node.js coding - can anyone please point me to the right doc/reference how to do it and where
10 suggestions for Global Search
Global search is great! And it is new so we know you may have improvements coming :-) Suggestions: DEFINING "SEARCH OPTIONS" add these settings and of course obey them in the UI and searching: * Whether that form is available at all for Global Search. (If no, ignore all settings and do NOT show in GS dropdown, and do not search that form.) * Which columns to display (already available) --but please actually show all fields selected, not just the first 7) * Which fields are actually to be searched
Add Subform Row Into Existing Main Form
Hi, I have a main form A with subform AA. I want to add data from main form B to existing main form A subrows. How can I achieve this using deluge scripts? The current example I see is adding subrow in new main form record, but how do I add to existing
Ticket
I can't find from where I create ticket in zoho creator please give us a proper tutorial on this if you can.
Solution to circumvent API Limit
I have a report (1) for which I make 1 API call to get 200 records. Each record is connected via lookup (2_id) to another report (2). Now I want to get some fields from report 2 for each record in report 1. (without adding every field as a lookup) I tried
Photo Upload Field: Reduce File Size
Hi Zoho Team Do we have a roadmap for this topic to reduce the uploaded file. As of now, we noticed that whenever our Engrs. upload a photo onto our service report app, Creator will retain the original file size. Unlike Zoho Forms, it does have an option
How do I find out the user account id from an email ?
I'm creating an employee register by using an API from our HR system (not Zoho People) and I want to link the zoho account of employees to this record. However I can't use the associated email and I can't find a way to get the account id. For example
Data Dictionary code
FYI: void Utilities.Data_Dictionary() { // the following code INFOs tab-delimited form and field info for analysis in a Google or Zoho Sheet or Excel // "allcreatorscopes" is an internal connection that has access to all Creator scopes // // the delimiter
Concern with the Record Template
Hi Zoho Team Do we have a way to have this alignment issue be addressed. Here's an issue when a report been generated back to Zoho Desk as an attachment on the email. On the report, if a page been added tendency is that the alignment was off on the 2nd
Control Over Pre Set Print Settings
Hi, I was wondering if theres any way to have control over the print settings. For example i have two HTML pages that require printing frequently. However they both require different printers with different settings. It becomes annoying having to set
barcod
pl
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.
Is creating this Order Management tool possible in Zoho Creator?
Hello! My company is looking to automate our open orders (we still use paper…) and has tasked me with finding a solution. I have worked with Smartsheet and ventured down a few other platforms that have not worked. (Our POS is pretty limited and does not
View Audit Trail field
The Audit Trail feature is great, but its data is only available to admin users. It would be really great to have a system field "Audit trail" that we can add to the detailed view of a record. This would allow supervisors, directors and etc. to quickly track what changes have been done by whom for each record. It is a current feature from a client of mine and while it's probably possible to hard code it, since this data is already available in Zoho, I would be surprised to hear how hard it would
How to add and remove fields that can be mapped when importing from Excel
I am trying to import an Excel sheet which will come out of our POS and create an Order Management tool. When I try to import it says I have to map columns, but when I go in to map them, there are "required" fields like "Delivery Agency" which we will
Create dynamic link in HTML snippet - link change based on form input value
I need to create a page in CREATOR, where there is a form and a iframe below the form. The iframe will show a picture so I need the link to be changed dynamically each time the field input (field name: ClassID) I added the form as usual, then add a HTML
record_summary ID?
How do I get the ID? I have this as an example for a a "comment" I @ mentioned myself on. <SNIPPED>/record_summary/UAS_Aircrafts_Report/3850763000000308019/ How do I get this full URL???
Create multi-value lookup field for recording class attendant
I am a newbie for Zoho Creator and facing an unsolved challenge. In a lesson, the teacher need to record all attendant student (children). These are two requirement: - The student data should be retrieved from ZOHO CRM (Account object) so the teacher
Custom filter with muti select partially working/broken
I have configured a custom filter on my report as <multi select field> does not contain <value from options> OR <multi select field> is null. I have done this through the UI, which leads me to believe such functionality is supported. If I only select
Redirect to Form populating field based on the report item that called up the form
I have a Report named "All Invoices". I have added an Action button to that report that once clicked redirects to a Form "Worked By" where I select the staff that worked on that invoice. That Form "Worked By" has two fields: - Invoice Number (lookup to Form Invoices); - Staff (lookup to Form Staff); Is there a way to pre-populate the Invoice Number on the Form "Worked By" based on the line item on the Report "All Invoices" that caused it to be opened? Thanks, OV
"Copy Link" missing on web?
I see copy link on mobile for a form item, but its not on web?
Join us for the Zoho Creator Developer Meetup on September 12th!
We're excited to announce the Zoho Creator Developer Meetup, scheduled for September 12th, from 10am to 1pm at the Zoho campus in Chennai. This meetup will celebrate creativity, collaboration, and innovation in low-code application development. Here's
When I am creating a new customer, after filling all necessary details I am getting this error message "Invalid value passed for attention" . I am not able to figure out what is causing this.
I haven't done anything different from other times but not sure why it wont let me save the new customer.
Calculate Hours Minutes Sec in Zoho Creator Using Deluge
check_In = "8-Aug-2023 10:00:00".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong(); //difference = start.timeBetween(end); check_In = "8-Aug-2023 17:56:50".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
Error parsing XML List
Hi, I'm trying to parse an XML list the way it is shown in the Zoho documentation. Here is my code: mapvar = getUrl("http://xxxxxxxxxxxx"); xmldata = mapvar.toXML(); strdata = xmldata.executeXPath("/root/value/items"); xmllist = strdata.toXmlList(); for each thing in xmllist { datestring = thing.executeXPath("/items/date/text()"); } When I execute, it gives me an error when it gets to the last line. This is the error: Execution Failed Error details: Error occured while executing
Custom SMTP relays
Hi, It is possible to use a custom SMTP relay server to send out email? Thank you
Redirection in iFrames
Hi, I have a Form which is published. The Form directs to a Page on submission, which is also publushed. When I put the iFrame code provided for the publish Form on a website the Form works fine, however the redirect to the published Page does not work.
Dynamic Lookup boxes?
Hi, I have 2 forms. One is a form of Training Sessions (location, date etc), and a form of Bookings, where people have booked the sessions. I need to create a Register, so another form where attendees can register their arrival to a session. I want the
Next Page