Creator Subforms Question
Should every subform I create be it's own form? I can either add a subform directly within the main form OR make it it's own form and then add it as a subform in the main form. Are there any major pros/cons to these options? I keep getting the feeling
Customer Portal and Field-level Permissions
Under Settings, Users & Permissions, 1 of the 4 menu options is "Field Permissions" Under Customer Portal, I see no such option. My question is "Can I control Field Permissions for Portal users the same way that I set Field Permissions for Users? Thank-you, Kevin
"Add New" Items in stateless forms cause issues when touched on a click "On Submit" workflow
This is a new error. If I select a existing drop down record in my stateless form and try to use it on a onclick workflow, it works, but if I select "Add New" on that drop down and use a new item it wont work. If I exit the form and begin again I can
Input fields in HTML or ZML snippets
I'm trying to design a html search-result list report page. I used the search option to add one field on the page but i need to add more fields. Is there an option to add input fields on the pages?
Using dropdown append and add functions on a dropdown field inside a dynamically generated subform row
Greetings i'm working on a subform where i will create rows dynamically and assign them values on form load. i also want to assign choices dynamically to the dropdown menus of each generated row. the issue is when i try to access the :ui of the dynamically
Access registered Zoho People user data from script in Creator
I am working on an app in Creator that would allow for employees to submit tickets for manger review and designation to various departments. I want to have only the "manager reviewed" tickets to be viewable by employees in the departments designated my
User ID based data filter
I want a function similar to the ZCRM, Owner-based data filter is the standard functionality in CRM right? Similar to that each line of data has a "User Email ID" field, the code needs to fetch the logged user email ID and filter the "User Email ID" column
Creator Map Report: Latitude and Longitude
Hello. I have a form named Add_Property. Within that form we have an Address Field named Address (see image). The problem is that all of the properties being entered are not getting the correct Latitude and Longitude for the Map Report. In the photo,
Zoho Creator - [Free Webinar] Learning Table Series for NGO
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Zoho Subscription Pricing
Greetings everyone, We have a deep appreciation for all the remarkable Zoho products, and we take great pride in our partnership with Zoho. However, we have encountered a significant challenge concerning the pricing of Zoho subscriptions, which has resulted
Related record count in Creator
Excuse me if this is a very basic question. I have tried to find it in the docs and forums but I didn't see anything. Can I have a field in Zoho Creator that counts the number of related records in a different table? If each record in table A has a lookup
Creator: Page Parameters Help
I need help understanding Page Parameters and making a lookup page for records specific to the lookup field. I made 1 minute video showing where I'm stuck: https://www.loom.com/share/7f905f0ec09146ad979f5d6a2a4f7051 *I've tried duplicating examples in
Scheduled Report - Pivot Table as XLS Attachment
Hi Guys, I was wondering if anyone had a workaround to this problem I am having. Currently, pivot table reports are only allowed as PDF attachments when added as an attachment in the SendMail function (https://www.zoho.com/deluge/help/misc-statements/send-mail.html).
Creator: How to fetch images attached to a record
Our technicians submit a Form before and after each job they work (see attached Form). Once the form is submitted, I want to do other things with the attached items. How can I make workflows with the attached items upon submit of the form? Can someone
Google url Shortning API call with Deluge
I am attempting to shorten an url using the Google url Shortning API. However the scripting is returning an error Below is how I have scripted the API call in deluge: headerMap = {"Content-type" : "application/json"}; requestBody = {"longUrl":"http://www.google.com"}; response11 = postUrl("https://www.googleapis.com/urlshortener/v1/url?key=AIzaSyCXSvaYtT2Yr3TxKcesN9OU2FXNVvzM3tQ",requestBody , headerMap,false); Here is the error return in the response: {"responseCode":"400","responseText":"The request
Email data to a form
Hey everyone, I set this up per the instructions here: https://www.zoho.com/creator/newhelp/forms/email-data.html The emails are not generating records in Zoho Creator. I BCC'd the "Form Email Address" when sending the test email. My test email is a
Creator Subforms: How to loop through subform and calculate sum total of timestamps?
We have a subform that tracks Clock-In/Clock-Out for our service technicians. One of the fields in the subform (Job_Time) calculates the difference between the Clock-In Time and the Clock-Out Time, leaving it in minutes format, see attached image. How
How To Get The Data From One Form To Another Form
EX ; 1.I have enter details in Powerreading From 2. when i open report and i enter data values and dropdown values then autoplate next two fields 3. can help me 4. Add Attached Both Form Also can check it and tell me
Hide values in a lookup field for non-logged in users.
Hi all. I have a form that contains a lookup field. Let's call the form "Booking form". The lookup field is called "Package". Basically, it lets the customer choose the package they want to book. This field is a lookup to another form called "Packages"
HTML Styles in forms
Hi all I just wanted to share something I have found to be useful. I will start with I am not new to Zoho Creator but never have posted. I find the biggest shortcoming of Creator is its look and feel and the lack of control over it. I have spent many
Zoho Creator Map Report: Question about map icon labeling
See attached photo of our test map report in creator. Each one of our records has a field named "Route Order". When I look at the list of records in map view I want the route order, which is a number, to show for each icon on the map. How can I achieve
Approval Workflow Trigger Issue
Hello, I am running a function via a scheduled workflow every month that creates an entry in a form. I have added an approval process to a form but the approval process only runs when I manually enter data into the form and not when a function adds the data using add record deluge script. I am also unable to trigger the approval process from the function using deluge script after I have created the record because the approval workflows are not accessible like the functions are. I can send an email
Rename file uploaded
In a Form, how to rename a file uploaded. Field 1: Name ..............John Field 2: Upload file .......cat.jpg (student assignmement) record: John ........John_cat.jpg Thanks !!!
Integrate Grammar Corrections/Spelling Suggestions
Hi, Often while using Zoho Creator app, people make mistakes while entering text, it would be really helpful if autocorrect/grammar suggestion is made available using Zia in Zoho Creator. Regards, Sushanth
Form Buttons not working when form is opened in some reports but works when opened in others
We have an "Email Quote" then when opened up in any of our quotes reports it allows you to send or resend an email and lets you customize the message. For some reason this morning none of the buttons within that report work. Including a test button i
Stateless Form button of type button triggering validation
I have encountered what seems like a bug with buttons in stateless forms. The button is checking for required fields on the form even though the button is not submitting any data. I would expect a button with type Submit would check for required fields. I would NOT expect a button of type Button to check for required fields. Take the following example: This is a stateless form opened into a popup window from a list view action. Notice the single required field. This form has two buttons. - Submit
Adding Subforms in Deluge
Hi I'm trying to add new rows in a subform, but keep getting an error. I have posted unfinished code below, and getting an error at: row1 = Suppliers.SupplierParts(); with Suppliers being the form link name, and SupplierParts being the subform link name.
Rounding values to nearest 500
I have a series of numbers that run from in the tens to the ten thousands. I want to set the following rounding rules: Above 10,000, round to nearest 1,000 Below 10,000 but above 1,000, round to nearest 500 Below 1,000, round to nearest 100 // Work out
Zoho site with dynamic content
Sorry for a newbie question (first time user here). I'm looking to migrate a Mendix project to Zoho Creator. It's a publicly accessible web portal (so looked at Zoho sites too), but the examples I saw were more static content websites - at least at first
Purchase Order can't be created for the non-purchase item
Hi, I tried to create Purchase Order from Zoho Creator to Zoho Books.But I got error as "Purchase Order can't be created for the non-purchase item."I also created the item for this. What was the issue I'm facing?
Customer Log In Times
Is there any way of having access to the last login dates/times for portal users ? I could really do with some idea of when my customers are logging in
Count the number of responses in an Invoke URL call
I have a qc function that is comparing data between a report I have in my Zoho Creator app, and that of an API dataset. I am using for each to iterate through a day's records by a unique ID (Appeal_ID) and calling the api by each f these ID's . So far
Zoho Creator and Automation platforms
Hi, I have a requirement to move information form Zoho into Monday.com. I have it working great, but any field that contains files (.PDF,JPEG etc) don't show in any of the automation tools I have tried (Zapier,MAKE, ZOHO FLOW). Am i missing something
Connection between Zoho Creator and CRM impossible
Hello everyone, I am trying to pull contact entries from ZOHO CRM to an application I am trying to build in Creator. Unfortunately, I do not get my entries showing up, I always get "null". Please have a look at my configuration and tell me if I am missing
Display single Record from Zoho CRM in a form based on URL parameter
Hello everyone I need to do the following. I created a form with 3 field . Based on the URL parameter which has the contactIid I need to fetch the specific record and display it in a page. https://creatorapp.zoho.jp/julien_dunes/fetch-it/#Form:OkOK?contactID=987238392832989382
Push notification message limit
Do the <message> has a limit of letters or combination of variables and text limit?
Best method for Logging Time
I'm developing a pretty extensive app and I want to include logging time to specific jobs. I know the method for time tracking in the gallery app is to basically use text. However it is a bit clunky when it comes to summarizing time in reporting and in
Using for each to iterate through a collection of records and invoke url for each record
I am trying to set up a scheduled function to compare and quality control check between 2 sets of data. One of these is within a creator app that I built, and the other I am calling from a 3rd party API. My planned workflow involves selecting all of the
Delete subform rows in creator
Hi, I am using a subform for adding rows dynamically. The insertion will be done only based on the decision field's value. If it is true, I will show the subform fields for entering. After enabling, if i make the field as false, the entries in the subform has to be deleted. So, can anyone please help me to delete the subform data through deluge script.
report merging several tables
Hello There I am trying to build an application to manage payrolls. I built several tables such as: Companies Company name (field) Company ref (field) Departments Company name (lookup) Department name (field) Employees Employee Name (lookup) Employee number (field) Contracts Employee (lookup) Company (lookup) Contract # (field) Salaries Contract (lookup) Salary (field) Bonus type Contract (lookup) Bonus (field)
Next Page