Calculate Price based on duration and extract business hour and out of business hours.
Hello Everyone, I’m looking for some advices on how to or help to code from you. Let me introduce my request, i have an app in Zoho creator i use to track my interventions and make invoicing at the end of the month it’s a app I made myself and I’m not
I would like to keep a record every time my item gets modified in my Inventory Report
In my Zoho Creator, I currently have an inventory report that gets populated from my Receiving form. The items need to pass through a sorting form where their Container numbers/types/materials/etc may change during this process. I would like to have an
Deluge statement execution limit
Hi I try to use a function iterate all records (about 10,000 records) and revise some fields Here is the error message I got "The number of deluge statement execution limit exceeded the maximum limit." Is there any way I can easily to do the batch revise over all records Thanks Regards, Matthew
Formula Field - How to count number of specific weekdays between two dates?
I'm using a formula field in a Request Time Off form to determine how many work days a person will miss if their request is approved. This part of the formula works fine using the workDaysBetween function. However, I want to determine how many regular
Zoho Creator - [Free Webinar]Learning Table Series for Hospitality
Hello Everyone! For the month of November - Bringing on to your table - Zoho Creator for Hospitality 12 Months 12 Industries Hospitality Industry The essence of hospitality lies in creating a warm and welcoming atmosphere, where guests or customers feel
Zoho Creator to GMAIL API Setup - Where Do I Begin?
Does anyone know how to connect Zoho Creator to Google Workspace (Specifically GMAIL?) We have FLOW setup and working fine to send emails via GMAIL, but Flow doesn't accept file attachments which is a major problem. So, we need to be able to send an email
Note field does not show value on mobile app
Hi there, has anyone noticed that the Note field no longer shows value on the mobile app? I am using the latest version 6.13.8 for Android.
How can I submit a form through deluge?
I have a form that has records which include information on each unique product we sell. Each of these products have their information updated frequently, and thus need new reports printed out each time they're updated. Currently we have to edit the record, submit the update, reopen the record, and click the link that sends us to the report to print. Is there a way that I can click a decision box, have everything in the form update, and then have an openURL pull up the report with updated information
Help !!!!
Je souhaite réaliser des calculs sur les montants de ma table 'table_faits' en les multipliant par les coefficients correspondants. Cependant, il est essentiel que cela soit fait de manière séquentielle, en commençant par un type de mouvement spécifique,
Zml formating for mobile view
Hi, I've got a zml snippet with about 8 elements consisting of panels and charts. When in mobile view the charts and panels don't dynamically move to make it mobile friendly like they do when you just have the drag and drop elements. I've tried to make
How can I pass the zoho.currenttime to a Zoho Creator Date Time field from Zoho CRM
Hello guys, Maybe it is an easy question but whatever way I am trying to use I always get an "Please enter a valid date time format". I would like to pass somehow the Current Date/time from a zoho crm function to a date/time field in creator like the
Check if every field has been filled in.
In my form I want to check if all fields are filled in and if so, set the value of a decision field (Info_compleet) to true. If there is any field that's empty, I want that Info_compleet to be set to false. Info_compleet, together with another decision
Limits of images file in per record
Hi Community, Could you help me out with this. Is there a limit on the number of image files per record in Zoho Creator? Regards, Utkarsha Gupta
Multi tenant in Zoho
Can I do multi tenant in Zoho and add subscribers to use my zoho with a diffrent permissions?
filter in Reports with "Search and Auto-Complete" ability
It will be perfect, if users can use search and autocomplete (as for Lookup fields in Forms) in Filters in Report headers
Canvas Scroll Bars Query - How To Hide Them?
I've just started playing with Zoho Creator's Canvas Feature to create a Job overview screen. Can anyone advise how to get rid of the scroll bars on the table/subform inserts? I've tried reducing the number of fields shown, adjusted width of various containers,
Built in Search, Last n Days not including Today
I'm seeing a strange behavior using the built in search option on date fields. This is a field that I populate through the Zoho API. If I choose any of the available "Last n days" date range functions, i.e. Last 7 days, Last 30 days, the view does not include records with today's date. The "Today" option returns today's records. The field uses the following format: yy-mm-dd hh:mm:ss I have not tested other formats to see if it is specific to this one. Update: After looking at the code zoho generates
Page embedded report "Add Record" button
A fundamental need is to embed a report in a page and add records to this report. When pressing the + button on the embedded report the form size is limited to the report size, which can significantly reduce the user experience. I would appreciate if
Update subform dropdown field choices - on load workflow
Hi, I have a "Check In" form that has "Contacts" subform and a "Tickets" subform. When the form is loaded, I want to populate one contact and the number of tickets. I want the "Contact" field in the "Tickets" subform to have the choice of "Contacts."
How can we pass the zoho.currenttime form Zoho CRM to Creator date time field
I am trying to pass from a CRM custom function the zoho.currenttime (or the date) to a Zoho Creator date/time field. I have written multiple ways but I always get "Please Enter a valid date/time for the field" I have written ways like for example EndDateTime
View uploaded File in browser not as download
Hi all, I have an application where multiple PDFs are uploaded. In the reports, when we click on them we are automatically asked to save the PDFs instead of viewing them in browser in a new window. Is there a way to change this so the files don't have to be downloaded?
Multiple Criteria in a variable
Hello, I am looking to create a variable that searches on 2 criteria, <Target_School == "Yes"> and <Received_Tickets == "No">. I cando a single variable, but not multiple. Is there a way to do this, or do I have to do it a different way?
Call End Point of app script in Creator
Hi google app script provide web api but this api only work in postman when same api you call its work in creator. support team not help out sort this. when any api we call support team always ask is this api work in postman. if its work in postman then
update selected records selected in list view report
Hi I have a report that i would like to run a custom function on the selected records. The user will select the records in list view, press the button, a form would appear to input some data and the selected records will update with the info on the form on success. I'm relatively new to zoho and struggling to find how to do it. Cheers
Report Filters on Pages
Hi I have a Page with a stateless form and a report. The report is filtered on a value entered in the stateless form. The page is shown using openURL and passing parameters. All works fine except that I don't want to show the filtered field in the report
Print Mulitple Template at once
Hi all, I setup a template to includes a QR code as label for my record entries, I can print out the template using the Detail -> More -> Print. However, it going to be time consuming for me to print out the label one by one going into the detail
How do you get a value in an embedded stateless form out to use somewhere else on an html page?
I have an html page with two items: 1. Stateless form without any buttons. 2. An HTML button that triggers a function. I need a way to get the value in the stateless form into my html button that runs a function. How do you get a value in an embedded
How to embed a form to edit in a page
Hi, is it possible to embed a form to edit to a creator page? like below but to edit?... thanks for any answers... <div elName='zc-component' formLinkName='Orders' params='zc_Header=true&&zc_SubmitVal=Submit&zc_ResetVal=Reset&'></div
JS SDK - Zoho Creator - React
Hi, I am testing out the JS SDK, and wanted to load React no-build libraries. However I am not able to load React library. In the sample app I can see that JQUERY is being used in the same way that I am implementing ReactJS external libs. For reference,
Deluge Script - Print multiple records, one per page
Hello Is there an openURL command that can do the same as printing a summary of chosen records? For example, if i choose three records in a report, and choose print, then print as summary. This will print each record on a different page. How can this be down with Deluge script? Thanks
Bulk/mass email from a filtered list
Hello, I am looking to send an email to a filtered list. I have a form called school_details that has an email field and from this form I have a filtered list report. When I create a record in form b I want it to send an email to the email addresses in
Getting valuefrom a field in one form to populate a field in another form
Hello, I'm fairly new to Creator, I am trying to copy the value from one field in a form to the field in another form. I have a form called Allocate_Tickets_Form and another called add_edit_schools. I want to copy the data from a radio button in the Allocated_Tickets_Form
Update existing record and not create a new one
Hi Can anyone help with my code below. On form submission, it should check if a record with the same estimate number already exist. The Estimate_Number field is a look up field to another form (Client Info). The problem is that it is creating a new quote
Help pls !!!!
I want to perform calculations on the amounts in my 'table_faits' table, multiplying them by the corresponding coefficients. However, it's essential that this is done sequentially, starting with a specific movement type, for example 'MAT', where the amounts
Fastest and easiest way to test / interact with deluge scripting?
I have a background in ruby / JS so the actual programming logic of deluge is obviously no trouble but the main struggle is trying to actually see what information I have available where and how things are working and I haven't found any great test environments
Loading a saved draft automatically
Is it possible to improve the UX of drafts? My forms are not particularly complicated but can require my users to gather information so the save draft functionality is very nice to have. However using it can feel strange where you save a draft and your
Zoho Creator Subform horizontal space/ appearance
in Zoho Creator I have a subform that will show or hide depending on the task selected by the user in the main form. However it looks terrible because on load, the subform shows fields horizontally and this spreads out a lot wider than I would like. ie.
Get prefix of field, get distinct list, insert list as new records in new form
I'm trying to get fetch records in a form, get the first section of data from one of the text fields (everything before a "-"), then filter out duplicates, then use that list to make new entries in a new form. Here's what I think it should look like but
Page Scripts
Trying to get my head around Zoho Creator Pages. Can someone point me to a decent tutorial on how the Page Script functionality can be used? Thanks Kevin
Zoho Creator Actions button when selecting Submit and Cancel/Delete on a form
I would like a to know how to create an alert or action when Submit or Cancel/Delete is selected at the end of a form. I know it is possible to do it as a successful submit action but more along the line of the cancel/Delete.
Next Page