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?
Storage of secrets/ token/ credentials
Hi, How can I store credentials and tokens in Creator so they aren't accessible to others? Or perhaps 'what's the best practise for this'? I created a form to store the values for a bunch of API calls, then encrypted those fields, but of course we can't
DataBase
Creating and working with DataBase.
How to filter page values?
Hi, I am new to Zoho creator. I created a page with panels based on form values. But I couldn't find a way to filter the page values with user selected filters. Please refer the attached screenshot. I am seeing Search component in Page. But it is not allowing me to add drop down or calendar which is required in this case. Could you please point to the right direction?
Adding a single item through Zoho Books API returns {"code":4,"message":"Invalid value passed for bulk_update"}
Hello, I need to update an invoice with hidden items (rate = 0) in order to have the inventory updated accordingly, as well as monitoring the full project's economical efficiency. To do so, I am passing the Zoho CRM customer ID, Project Name, Article
Filtering an embedded Analytics dashboard in Creator
I have an Analytics dashboard that shows key stats by organisation(s), based off two main tables synced from Creator (projects and project members). Within Analytics, it works beautifully. However, when embedding the report into Creator, I need to pre-filter
GetProjectDetails Integration Task returns only 100 last projects ?
Hi Everyone, I am new to Zoho and Deluge, so this may be an easy one for the experts :). On Form load, I am populating a dropdown field with the list of all active projects. I do this using a Zoho Projects Integration Task: projects_response = zoho.projects.getProjectDetails(portal_name);
Can i create a booking form that doesn't allow double booking?
Hi, I'm trying to create a room booking form with online payment. There is one room available between 9 and 11pm. Is there a way of creating the form so that more than one person can't book the room for the same time? Ideally, there would be a calendar that is greyed out on already booked days. I want to use a form because i need to push the record through to a calendar report. Thanks
Duplicating Reports with different values from API
Hi, I want to be able to duplicate a report (same fields and layout), but I want to have different data in the columns from API calls from the CRM. So, for example, my original report would have fields like 'Seller', 'Total Sold', '% Sold' with data pulled
Invoicing Software
Hi, Is it possible to create invoicing software with Zoho Creator? with the possibility of implementing SAF-T (Standard Audit File for Tax purposes)?
ANY HELP WITH WRITING BACK TO An EXISTING SUBFORM RECORD
Tried this so many ways... How can I write this back to this "subscriber list"-FORM with Field List "Demo" or ID "3412703000009959015" ? My Inventory List already is setup with a list of contacts and I want to write more records from another form with
Customer Portal - Restrict/Hide/Modify form fields to customers only
Hi, I am attempting to setup a customer portal for my existing database allowing customers to add new orders. I would like to restrict, hide & modify different fields for customers inside the portal, without changing the fields for existing user accounts that are not in the customer portal (our staff). Basically the same form will be viewed/interacted with differently depending on whether its a staff member or a customer. What is the best way to go about this? Is there a guide to follow that will
Renaming Record Template
Hi Zoho Team, I would like to confirm if this possible to rename the template once successful submission of form -> sent email notif I haven't tried yet but will Display Name accepts this? - declaration of variable
Notifying portal users with specific permission
Hi, I want to use deluge script to send push notifications to the portal users with specific permission. How can I do that in Zoho Creator?
Strange deluge error trying to access data from List
Hi all, Some background on my problem: I have a form that accepts some values from keyboard input pictured below. The form section values are named "Non_Discountable_1" and "Non_Discountable_1_Quantity" from 1-10. The left field is a multi option dropdown,
Duplicate record in form and related form
I'm looking to create a "duplicate" button. I have a form and a related form. By clicking on "Duplicate" the record of the first form and the linked records of the related form should duplicate themselves. Any idea ?
AI that checks text content quality and for plagiarism
Hello, A client has a requirement where the users will be typing in content consisting of multiple paragraphs in Creator. The text box will be checked for plagiarism and also for its quality. What would be the best approach for that?
Zoho Creator On-Premise
Hi, It would be great to have a On-Premise Zoho Creator version/solution for clients/organizations that require to store the data on their own servers. Is that something to come on the near future? Thanks.
JAVA RENAME FILES
Hil All, Its possible to change the name of the File that user upload in a file field (PDF format) with data that already exist in the record? Best Regards!
Hide form *section* with Deluge?
Hi folks, I have a form with questions arranged into sections. I want to hide/show a given section or sections on user input with a given field. I'm obviously aware that I can hide individual fields with Deluge - but I can't see a way to hide/show a section. Does anyone know a way to do this, or is it only possible at field level? Thanks in advance, James
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widgets and extensions in Zoho Creator - Part 2
Hello Everyone! About the Creator TechConnect series The Creator TechConnect 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
Next Page