How do I add button on a form?
I want to either have a button on link on my form which can take the ID and show respective details for that that record? For e.g. Let's say I have EmployeeInfo form and VacationRequest form. In the VacationRequest form, I have lookup called EmployeeName that displays all employees. I want to give a link or button right next to the EmployeeName look up field where the user can view the Employee details, in a popup, without leaving the VacationRequest page. Question: How do I add a button or clickable
Classes and CSS styling in Zoho Creator form fields
Hi, it would be nice if you could assign CSS styles and classes to the form elements from the field properties. And also, to be able to write CSS somewhere for the form, so that it is applicable on the form in any situation. Since I am currently using
Setting Up Deploy Mobile
Hi zCreator Team, Just want some help navigate where can I find the deploy section for me to create an SDK for Users.
Contains operator in Creator REST API
Hi, How can I use the "contains" CompOperator from the REST API ? If I do http://creator.zoho.com/api/csv/dvd/DVD/view/matchall/Title=Heroes/apikey=... it will work for exact matches. But how can I search for fields which contain the string I specify? Many thanks, Richard
How to find time difference between Date-Times and set to Time field of Creator
STEP 1. FIND TIME GAP using `timeBetween` startTime = zoho.currenttime.subHour(2).subMinutes(24).subSeconds(4); endTime = zoho.currenttime; timeGap = startTime.timeBetween(endTime); STEP 2: Structure Time String for Time Field There's an issue with the
File upload and send email
Hi I created a form on Zoho Creator and some fields are file uploads. I would like an email to be sent to me when the form is sent, with the form information and the file uploaded in the form attached. In Zoho Form, I've managed to do this, but I can't
Redirect USER to new url after submitting form
As it is, when a user clicks submit on the form on my website, it appears as though nothing happens because the form is so long, you cannot see the "date submitted successfully" message that pops up. Nonetheless, all the input is still there and nothing else happens. What I would like to accomplish is for the form data to do what it's designed to do (send confirmation emails and send data to zoho for storage), but the user be redirected in the same window to a new url on my website, such as, ".../ThankYou.aspx."
Hyperlynk local file
Hi, I am trying to create a hyperlink to a local file, however I keep running into an issue. The user should enter the path in a string field. From this string field I then make the hyperlink as followed: mypath = input.filepath; filehandle = "file:///"; new_link = "<a href=\"" + filehandle + mylink + "\">" + mylink + "</a>"; input.url_link= new_link input.new_link_string = new_link //this variable is to verify the newly created link new_link_string displays the newly created link properly, however
How to fetch parameter from url
Hi there. I have an application (a sample is available on https://creator.zoho.com/zoho_dhl/dhltest/#) where I want to send my users a URL with their userid so my form can fetch the ID and fill out part of the form up front. So I would like https://creator.zoho.com/zoho_dhl/dhltest/#Form:RMA?User="Happy User" to result in disabled User field being updated with "Happy User" (and then having my deluge script finding the email for that user etc. etc.) But I cant seem to pass on the parameter to the
How to use creator edit mode form in a widget
I can publish a creator form and report with embed code and use it in the widget. but I need a edit mode form embed. is there any way to get it ?
App Custom Icon Not Work
Hello Zoho team, I have set a custom icon in the code-signed Zoho Creator application but not work. Also discussed this with the Zoho support team but still have not solved this issue. As per the Zoho technical team's suggestion, We checked by installing
License manager for custom (non-Zoho) app
I am a Zoho One customer and am developing a non-Zoho app to be installed on premise for which I need a solution to manage subscription expiration. I have built little database apps in Creator before, but this would need to allow querying over the internet
Error Message with Deluge Workflow
Hello everyone, I have this Deluge script that executes whenever another form is successfully submitted: insert into New_Site_Assessment [ City=input.City Homeowner_Email=input.Homeowner_Email2 Homeowner_Name1=input.Homeowner_Name Homeowner_Phone_Number=input.Homeowner_Phone_Number
Input validation phone number
I am trying to find a way to make field constraints for input of a phone number. Example: France (country code 33) local number 0142687984 should be input as 33142687984 and not for example 00331 42687984, 0033 (1) 42687984, +33 1 42 68 79 84 etc basically the number should never start with 0, should not include spaces or signs like + ( ) etc and should have at least 9 digits I have been trying to find a sample for deluge scripting but no success. Please help
Three state decision-box
Hi, if i use a decision box field in a form and make it mandatory, i can submit the form only if i flas as true. I thinks that is better to make it with three state, true (V), false (X) and null(-) if i make it mandatory cause of a mandatory decision
Workaround to follow both physical stock and project-related expenses.
Hi All, I built an Asset Management App in Creator and now want to exclusively use this app to keep track of the physical stock as well as the related expenses on associated projects. I do all that through deluge scripts using the api's. Each asset is
Stumped by OpenUrl when trying to open a filtered report with the click of a button.
I have two Forms, Accounts (parent) and Jobsheets (child), with their respective reports. They are related in 1:N relationship. I tried adding a button in the Accounts report, as a column labeled "View Jobsheets". The intent is for the on-click action
Spacing between fields
how do you control spaces between fields? I have a lot of fields to put on a form and want to put the fields more closely together. It seems like the spacing between the fields are automatically set and I am not sure where I can change this if possible.
Free version
This has been discussed elsewhere but I can't find a specific answer relating specifically for Creator. I have signed up for the free version (I think), at least I did not enter any payment details. As I have invested quite a lot of time and effort into developing (quite a good) app, I want to know exactly what will happen when I hit day 15? Will the app behave any differently or will I be forced to upgrade my account to keep using the app? Thanks
Subform properties
Hi, I need to understand the behavior behind a subform. If I create a form called "subform" with some fields and workflows related to each field (e.g., enabling fields, setting values, etc.), why can't I inherit that behavior when I use my subform within
Change the File Name before Downloading the file ?
I need to change the filename before downloading using deluge. Is this possible?
Please share the steps to done it.
Can I get page variables when I execute a button in a report which in that Page?
Can I get page variables when I execute a button in a report which in that Page?
Find next available integer in sorted list
I have a custom function that finds a next available integer and creates a part number. The function currently takes a sorted list and loops through each item to find the missing number in sequence. On some part numbers I run into an issue where statement
how to calculate difference between time?
hi there is Added_Time and Modified_Time how can i calculate how much time between Modified_Time and Added_Time Modified_Time - Added_Time = time_X ? in days, hours, minutes, seconds
How to get the request object on zoho Creator API.
Hello, I'm trying to create a Deluge function that runs on an incoming webhook. I made a custom API on Zoho Creator and connected it with the custom function, but I can't get the request object in the function. I found an article that shows it can be
2MFA in ZOHO Creator Portal User
How can I implement 2FA (Two-Factor Authentication) for Zoho Creator portal users?
Help me! Error {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"}
Hi, Good mornig , I have a problem with add data to creator API and I don't understand for why. The same process be have correctly excute the last week. {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"} I need your help. Thank You
How to update a Creator form record checkbox value to be true (checked) or false (unchecked)
I can't find the answer to this... I have page which is successful pulling record from a Form, and now I am making a custom function which will update a checkbox when it loads. My function is: dataMap = Map(); dataMap.put("Company_branding", true); otherParams
Prepopulate a field name based upon a zipcode table
I have a created 2 forms, an application that people will enter their information. Once they enter the field zip code I want to pre populate a field in form 1 with the city information. Form 1 is the application Form 2 is the zipcode with city and county fields Pls help I am new with building scripts
Creator Form - Form Submission Confirmation Popup not working
I have a form in Creator, and in the Form Properties, I have selected the checkbox for "Open form submission confirmation popup when Enter key is pressed". However it doesn't seem to work. When editing my form, if I enter a new value and press enter,
Change name of PDF download
Hi! Is there a way to change the file name of the PDF to the input of a field before downloading it? Ex: When I download the PDF of a record, I want the file name to be the input of " Date_of_Event". So it will download as 1/1/2017.pdf
Checking Expiry Date
Hi, Im new to Zoho creator, i need to create a function or query for my report to show records expiring in the (x) days. I have a expiry_date field and i try using Expiry_Date.toLong() / (1000 * 3600 * 24)) <= 30 Im getting an error " Invalid Search Criteria" Thanks in advance
List report with totals for Group and Subgroups
I have a List Report with Groupings of Division, Department I total some numeric column Now I get Totals for Department and totals for the whole report (the whole company for all records included in theForm. How can I show a row of totals at the end of each Division?
Regarding Multiple user dashboard
"I have created a dashboard that includes information on the number of students who have joined and the number of colleges, among other details. There are two portal users, Tharun and Abi, who are adding records to the form. I would like to track which
SUM a field with related record and update in another form
Hi, I have one form called Record form for portal user and admin user to add record accordingly. In this Record form, there is one Amount field. There is another Profile form where each portal user will be prompted to create their Profile upon first login.
How to change chart color
Hi In Creator, when you add a graphic, you can choose a color template, but you can't choose the exact color for each element of the graphic. Is there a way to do this? Thank you :)
Unable to create new Zoho Connections in Power BI
I am no longer able to add new connections into Power BI for automated refreshes. Existing connections appear unaffected as they are still functioning.
Does Zoho have a feature to create virtual membership cards for clients? Or any ideas on how to achieve this?
We are establishing agreements with companies to obtain discounts for our clients. We want the clients who wish to participate in these agreements to have a type of membership or affiliation card that they can present at these companies to receive the
Access Uploaded Files for Printing via PrintNode?
I'm trying to set up an automation to print uploaded PDF files via PrintNode upon submission. The problem I'm running into is that the URL for the files (shown redacted below) cannot be accessed directly with the call to PrintNode, at least when using
Zoho Creator - Multi Select Options as a New form
I have a form in Zoho Creator with a multi-select field named Software. For example: Task: Task A Software: Software 1, Software 2, Software 3 I need to create a new form called TaskSoftware that will store each Software entry as a separate record along
Next Page