Record Limit on Report
I have set up a report that I'm putting on a "page". I have filters set up to only show the records with deadlines in the next 45 days. But I only want the report to show the first 3 records (and if possible have a pagination option at the bottom to access
Unable to rollup calculation by group regardless of report
Hello, I have data related to several forms in my system. "Raw Material" is Form 1 and is the name of the item I want to roll up totals for with related forms. I have a lookup field in Form 2 "Production" that relates the record to "Raw Material". I will
Errors with isEmpty and toLong
I have some old code that just stopped working and nothing I am trying to do to fix it is helping. first of all, I am getting an error of for code that reads: if(response.isEmpty() || response1.isEmpty()) { alert "The Registration Number you entered wasn't
Pull (Parent Form) variable into (Sub Form) as the function iterates through recordset??
Hi guys, I need to update just over 23,000 records from 2023. I may be overthinking this; however, as you can see, I've added a single criteria to the function and initially designed it to run on the click of a single record. I would be there for years
Zoho Canvas review
I have recently explored the Canvas feature, and I'd like to start by discussing its pros. I'm optimistic that the list of pros will be longer than the cons. Finally, we can create a front end that looks and feels current. While I appreciate the scalability
How can I open / edit an existing record using deluge openUrl in zoho creator
Is there a way to open a specific record of a form using deluge? When trying to edit the record, the Url is the generic url for all the reports. What would be the url to open the same view (edit mode of a record) without using the same generic url for
Remove item from multiselect field
My basic issue is that I would like to be able to remove an element from a multiselect field (i.e. the inverse of ui.add...like ui.remove, which doesn't exist). Here's the set-up. I have a "unattached" form with a search function that lets the user add items to a multiselect field one at a time. (search, select the desired item, that adds it to a multi select field by ui.add:, and all items in the multiselect field are selected). That all works very nicely. I would like to add the ability to select
Can Deluge be used for conditional formatting of records?
Hi all, I need to highlight records in a report that meet certain criteria. Unfortunately this criteria depends on related records from a different form, so regular conditional formatting in the report "configure fields for web" page will not work. There
Creator App, Auto Generated form comes in .pdf, can it be altered to .xls
In the Creator App we have created a form for requesting test products. When this form is completed and submitted zoho creator generates an email with a .pdf copy of that filled out form and starts a workflow. Is there a way to change that auto generated
How many storage are left in my account
In previous event we couldn't use this product as a production for few days as because lack of storage. This is our past experience. Now we are using "Zoho creator". Please let me know the current storage status.
Make record in subform clickable
Hello, I'm creating an app to keep track of the procedures used in the company. For each task run in the company there's a "Task" record containing some information + a sequence of steps (procedure) needed to perform the step. Is there a way to make each
Zoho Creator - [Free Webinar] Creator Tech Connect - Cloud Functions in Zoho Creator - Session 6
Hello Everyone! Technologies like Java and node JS has an extensive user base and has an enduring demand amongst the developer community. Zoho Creator as a platform has revolutionized the solution building/application development process with minimal
Page parameters - Button custom colors
Page parameters can be configured to pass values to pages and display them inside page elements such as panels, charts, gauges, forms, reports and so on. I have a page and buttons to activate these filters. Is it possible to configure them like this?
Get min and max value from subform
Hi, I would like to show the min and max values of the subform within the parent form e.g. Parent Form = Products Subform = Variations Variation entry 1 - price =$200 Variation entry 2 - price =$300 Variation entry 3 - price =$400 Variation entry 4 - price =$500 The parent form would show "Price $200 to $500" Please can someone advise on the deluge script I could use in the parent form to calculate this Many thanks
Process large CSV file | forach limit
Hello there, given is a CSV file that usually has between 500 and 1000 rows and consists of 31 columns. I would like to change the file uploaded by a user, a certain value must always be set in one column and only under certain circumstances in another
Optional Function Arguments
How do you define optional function arguments in deluge?
pre-fill a form field from report
hi all i embedded a report on a page, and want to pre-fill a form field when opened from this report ("+" button). i've tried using - url params page vars report filter no success. anyone know if it's possible, or only with a custom zml snippet? tha
How to get the link /url to an attachment
I need to get the url / link to download files uploaded through the form. this link needs to work for people who are not logged in (i.e public link). Can anyone help ? The old format i found won't seem to work. Thanks!
How do you change the date format in a form?
I'm trying to create a form in creator, and i've inserted a date field for the user to fill out, but I want to change the date format to MM/DD/YYYY.
How to style a form using CSS
I put my programmer on this task and they found a solution. Using your browser's Inspect feature, get the CSS classes of both the <label> and <span> of any element you want to style in your form. Create a page. Embed the form in the page. Add an HTML
Use openUrl() to edit a specific record
I am working on a queue app for my organization. I have a master queue that is a report of meetings with workflow buttons to manipulate the records. One of these buttons I would like to open the record and edit for the purpose of changing the queue lookup
Select records from a list and insert into Sub-form on a form
Good day, I really hope someone can help to point me in the right direction. I have a form with a sub-form, in the sub-form users can insert new records for items that they want, almost like a shopping list. The sub-form is populated through a Lookup Field from the Item list. This part works well. I would LIKE to first take the user to a Report that show all the Items available. I then want the user to select the items from the list / report and then click on a button to take them to the form
Update other records values based on last record input
Hello Community, Maybe a simple question for you guys, but I'm struggling with the following use case. We need to ensure we have only Approved Supplier which we can deal with. Those approvals are based on evaluation and qualification as shown in the illustration
Update Multiple Fields Before Submitting the Creator Form
Let's say I have a Zoho Creator Form with the following Number fields: A, B, C, Score1, D, E, F, Score2. When A,B,C are filled, Score1 should be calculated as the average of A,B,C. Similarly, when D, E, F are filled, Score2 should be calculated as the
Filtering report when embedded in page
Hi Is there any way where a can filter the view of a report when it is embedded on a page in Zoho Creator? Is want to redrect my portal users to a page after submitting a form, but only show the result on the form filtered by some input from the previous
Will we have Custom Solution again?
It's been two years without the solution tab available! Will we have it again or not?
Multi-Select Lookup Field and Zoho Analytics
Hello, My Zoho Creator app has several multi-select lookup fields that I used to create many-to-many relationship between forms. When I import my Zoho Creator app into Zoho Analytics multi-select lookup fields are not recognized by Zoho Analytics app. Zoho Analytics only recognizes single-select lookup fields. How should I implement many-to-many relationship between forms in my Zoho Creator app so that it is recognized when I import the app to Zoho Analytics? Thank you very much.
Zoho Creator - [Free Webinar]Learning Table Series for Insurance
Hello Everyone! For the month of October - Bringing on to your table - Zoho Creator for Insurance 12 Months 12 Industries Insurance Industry The insurance industry: The safety net in an uncertain world - Whether it's safeguarding health, home, car, or
Read Only Field after Entry
Is it possible to make a field read only after entering information? For example a decal field for tracking assets.
Filter dropdown lists
How can I filter the data users can select from a drop-down list? Example: A sales person wants to enter a sales meeting it had. He selects his name from a dropdown list and after that he wants to select the company he visited ( he previously entered the company in another form, with all its details ). How can the dropdown list with companies filter only the companies he is accounting for?
Problems with outbound mail from Zeptomail
Hi, We are getting many softbounce errors using Zeptomail via zoho creator stating connection issues. Some examples are below. We dont send many emails, but most are having problems which is incredibly frustrating and problematic for us. I have been asked
Cannot give public access to Html Snippet in Zoho Creator Page
Hi, I created a form in Zoho Creator and published it. The permalink works but I want to override the css of the form. (style based URL parameters is not good enough) So I created a page and added an Html snippet. I can now override the css, which is
Save as Draft Button Missing in Zoho Creator Form
Hi, I already enabled "Save Draft" option in my Zoho Creator form. But when I go to the published permalink, I only see Submit and Reset buttons in the form's footer What am I missing here? I also tried filling the required inputs but still no "Save as
Find all duplicate Names
In a form with many records imported, I need to find and mark (Suspected_Duplicate field ="Yes") all the records with the same Name.
Subform on add row reload form does not reload
As per the title, just set up a form with a subform click add rows with the deluge command reload; It just lets u keep adding rows To be honest it did once or twice but i was testing a whole bunch of combination's if you set it up a basic test no reload happens Thanks
File uploaded - how to attach and send using sendmail
Hi, My form has these fields Document: [upload file] Contact Email: XXX@domain.com When a new record is added, i want the document/file uploaded to be sent to the contact email. i tried to add it into the message using "input.Document". But when i received the email, input.Document just prints the name of the document into the message body. There is no email attachment. Anyone with any idea! This is pretty important to the application i want to build... anyone with any ideas?
Sort HTML snippet embed Report through params
I would like to sort HTML snippet embed Reports through params. Is there any possible way? Thanks advance😊😊😊.
Subforms in stateless forms
I think the title says it all. We need to be able to add subforms to stateless forms. Currently the only workaround is to create a Form and delete each record upon submission of the form. I need to build an interface to update our inventory. Basically
Zoho Creator Upcoming Updates - August 2023
Hello all! We're excited to be here again, bringing you the latest updates and enhancements for this month: API v2.1 Custom sorting/grouping of records Enhanced navigation in forms QR and barcode scanning for PWAs - - - - - - - - - - Now let’s dive into
Field to use for inputs of ft and inches
What is the best field to use when you want user to input data in like ft and inches. Can I use a single field and have the string (') as a seperator. So it will show up like 5'6 when user input a data? I dont want to use 2 seperate fields. And can I
Next Page