Populating a picklist another form
I am creating an App for ATTENDANCE MANAGEMENT for a School. I have the forms: - Students (Form1) - Classes (Form2) - Attendance Management (where I monitor the ATTENDANCE of students PER CLASS) (Form3) In the ATTENDANCE FORM (Form3) I have the fields:
Get the future date a number of days from the date in a column in a Pivot Table
Hello, I hope that someone can help me. I have a pivot table which has a column with dates in it (Date A), I wondered if it is possible to create a new column that shows the date 180 days from Date A. Is this something I can use a formula for? If so how
Print Option Accessibility Issue in Zoho Creator
I hope this message finds you well. I'm encountering an issue within our Zoho Creator application where I'm unable to access the print option when combining forms and reports into a single page. As printing is vital for our workflow, resolving this matter
Zoho Creator how to publish forms specific to each client in the Zoho Creator App.
Hi I see how you can publish a specific form to be able to access it externally. But what if I had a Zoho Creator App that multiple clients on it and I wanted to publlish public forms that are specific to each client? Such that I can embed those forms
Zoho Creator - [Free Webinar] Application Development BootCamp 1.0 - 3 Day Series
Hello Everyone! We are thrilled to announce the addition of another exciting webinar for all of you, titled APPLICATION DEVELOPMENT BOOTCAMP 1.0. About Application Development BootCamp 1.0 Application Development BootCamp is a dynamic three-day webinar
How can I get records from zoho people in zoho creator?
I try to get all employees from zoho people in creator using deluge I faced this error
Nesting one searchRecords function inside another
Hi all, I am trying to nest one searchRecords function inside another, but when I attempt to save the Deluge I get the following error: Error at line number: Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Support Inquiry for Website Development Issues
Hello, If I encounter any issues with the website I have developed and launched on the internet, how can I contact you to request a programmer to address a problem I have on the site and receive a prompt response? Do you have a WhatsApp number or customer
How do you add pagination to a Zoho Creator Page with zoho.crm.searchRecords
I have the following Deluge query which is correctly searching my records of up to 20 records per page, up to 5 page: l_Pages = {1,2,3,4,5}; m_SearchParam = Map(); m_SearchParam.put("sort_by","Registration_Date"); m_SearchParam.put("sort_order","desc");
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widgets and extensions in Zoho Creator - Part 3
Hello Everyone! About the Creator Tech Connect series The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while building
Best way to add custom CSS to Zoho Creator App
Hello, I'm using Zoho Creator to develop a custom app and I was wondering: what is the best way to add custom CSS? I'd like to use classes and ID's in HTML Snippets so I can control styling from a custom CSS file I'll create. Thank you
How to use deluge scripts to insert rows to subform
I have 2 forms, Box form with Seed_Packs entries that links to another Form Seed_Inventory entries. After I have use the import functions, the entries did not link from Seed_Inventory to Box.Seed_Packs, I want to use scripts to do the linking by creating
Stateless Close Pop-Up Window
Good day, I have a pop-up window with a Stateless form, when I click a button it should close the window, initially it works fine, but now the window stills open, I use the following script openUrl("javascript:window.close ", "Same window"); Best Regards,
How to create grouping a report in scripting ?
Hello Guys, Is there any possibility to group the records in the report by scripting. Scenario : If the user click the panel in the page .the report will shown as popup . I am also set a criteria by using Query parameter. Is there any option to group
Verify user permissions for form or report
I'm trying to write a custom function to determine if the current user has access to a report or form. Something like variable = canAccess(<report_link_name>); Is there a function that returns which roles have permissions to access a particular report
Creating a Unique ID (GUID) in deluge
Hi, Is there way to create GUID in deluge? I will have to use this Creator. https://en.wikipedia.org/wiki/Universally_unique_identifier Thanks PS
Long multi line field. Page break in template
Hello. When I have a multi line field in my report that occupies more than one page, a previous page break occurs during printing and exporting to PDF. How can it be avoided? I have inserted in the template, the value div, both "page-break-inside: avoid"
Default audit log on forms/reports/workflows on Zoho Creator
Namaskaram Zoho Creator team, There is no default audit log on forms and reports for finding that who and when the changes were made in a form/report. It is very important feature to track the form and report history.So basically we need to be able to switch on audit logs for any workflow. If I just go and tap on a checkbox, then all the activity happening in that workflow or using that variable should be captured automatically without any extra scripting. Crafted with ❤️ Zoho Gurus | Zoho Creator
Deleting from a Collection Variable
Hi All I have a collection variable, obtained like this course_Options = Schedule_Courses[Start_Date_Time == time]; This give me a collection variable of courses starting at the above time. If I wanted to remove one of the results from that collection
"If data has changed" function ?
Hi Zoho, I have a form with a name, date and type of a certain product. I need Zoho to run a function on "On Success" on Edit mode, ONLY if the date has changed (not if the name of the product has changed). Is there a function that can check "data before edit" or something like this? Thanks Ravid
notification(send mail) when users delete record
The system notifies adminusers by email when users change or delete data from a report. It need to include the data in email so that adminusers know what data users have changed or deleted. When users make a change, the data is attached, but when delete
[Free Webinar] Learning Table Series - Creator for the Real Estate Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. 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
reload the parent page
Hi, I am trying to reload the parent page with On Add -- On Success Action.I was trying to with below code that closes the popup window but not reload the parent page. Could anyone please help me ? openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:page.close", "same window"); openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:page.parent.refresh ", "same window"); Below is the screenshot: Thanks Arfater
Cannot Publish Application Due to a Problem
Hi guys, Just stumbled upon a confusing error when trying to publish an update for our existing application. We stumbled upon this error: "An error occurred while fetching the Form Field Order that belongs to the 'Biaya Promosi' subform of the 'Laporan
Multiple user viewing permission
Hello! I'm building and app for users that will connect with the customer portal. Many companies with many users will use this app. For obvious privacy purposes, I need to have a filter for the users of the same company to see only their records. For example, company "A" has 3 users, U1, U2, U3. U1 must see and edit U2 and U3 record...an so on. Is there a way to do that with Deluge? As a admin, I will manage the users in each company in a form. Thank you very much
Autopopulating lookup fields from multiple forms
Hi all, Been struggling with this issue for a bit and I feel like it is pretty simple, but I am just missing something obvious in the workflow script so any help for a beginner would be greatly appreciated. My goal is to have different forms auto populate
Zoho Creator to CRM Subform issue
I'm trying to move entries from creator to CRM. In this case, the entries create a new account on CRM and transfer the information in the subform as well. Deluge is saying that there is an error in line 5. The sub form in creator is called SubForm and the one in Accounts is called Products Requested. Please help me out with this accountInfo=Map(); accountInfo.put("Account_Name",input.Name); accountInfo.put("Account_Site", input.Class); productsList=List:Map(); for each Product in input.SubForm
Set default focus field in published page
I am working on a queue application for my organization. We have a touch screen kiosk in our lobby to allow for customers to check-in to the queue. Since the customers will often be checking in with a barcode, I would like to find a way to make the top
deluge scripting
Hello, I am trying to update a customer's details in billing from creator using deluge and i wanted to inquire if there's a way to update the customer's details by using the customer's email or phone number used in billing or creator instead of using
Before field - Schedules
Hi all, Can you guys help me understand this option, and why this accepts only the Single Line field for reference? I have not found any document talking about this.
Seeking to Hire Zoho Creator Developer
Hello Zoho Creator Community, I am the VP of Operations of a service company with field engineers who work on utility-scale Renewable Energy power plants across the US. We are seeking to hire a Zoho creator developer to help us migrate to our own native mobile application built on Zoho Creator. We currently use Google forms to capture data from the front line (service reports, timecards, mileage reports, and expense reports). With each form submission, it adds the data to specific google sheets,
Getting Error when Making API Call in Zoho Creator to FreightCom API
I want to make an API connection between my Zoho Creator app and the FreightCom API. Here is the code for my function: ``` string FreightComTest() { endpointUrl = "https://customer-external-api.ssd-test.freightcom.com"; apiKey = "This is my API KEY. I
Need Help with Creating a Sales Order Form on Creator
I asked ChatGPT to write me some code for a sales order form that pulls data from Zoho Books and Zoho CRM. Essentially, I want to be able to check for duplicates using the email address, and also pull the auto-generated sales order number from Books.
Barcode input - Field Action On User Input doesn't work
Dear Sir, While using barcode input, Submit form after capturing works but Field Action On User Input doesn't work in my app. But, if I do not select the Submit form after capturing feature, it works fine through manual submission after capturing data via mobile barcode scanner. I have tried creating forms both in Creator and Appcreator directly but it doesn't work. Pls help. Thanks. Kashif
Decimal Field error: rounding off decimal places
A decimal field set to show 2 decimal places is instead rounding to the ones place (rounding off the decimals). The images below show that in spite of entering 27.64 in the Non-Taxable Reimbursement field, that field in the report is shown as 28.00. The correct 27.64 is added to the 804.25, though, in order to get 831.89.
Automated vlookup price field getting information from a different form
Good afternoon, Is it possible to obtain automated values in a price field getting information from a different form? Thank you very much!
Updating a record in zoho books
i am trying to update fields in zoho billing upon edit of a record form in zoho creator but it does not seem to work. Can someone please help.
Deselect (empty) a lookup field
in On Edit / On Success of Form A I can manipulate a field (lookup/single-select) in Form B like this: rec = formB [ID == 12345]; rec.lookupfield = "option 1" ... as long as 'option 1' is a valid selection in this field. But how do I empty the field (it is not a required field)? These 3 do not work: rec.lookupfield = null; rec.lookupfield = ""; rec.lookupfield = "-Select-"; Any suggestions?
creating Variants for a product
I am trying to create teh same functionality as zoho inventory has to create item groups. As and when the options are added to a attribute and seperated by a comma a new list of products is added to the table below. How to achieve this functionality in
Emojis in HTML Snippet
I am not able to add emojis in the HTML Snippet. Everytime I add one, all the code disappears. Is there a special way to add them?
Next Page