Verify User on Last Record with Current Submission
Not sure if this is possible, as I am not sure when the Added User field can be verified during submission or after. I am attempting to make sure the user who is submitting form is the same person that was on the last Record. I have it set up that fields
Stumped on map variable script error in Zoho Creator
Hello, The script below is simplified to the basics that include the error line for easier debuging and is used in Action Button in a report for Form "RCMfrm_Jobsheet_Tasks". Goal is to open the existing record on-click of button to update a signature
Restricting Fields in Bulk Edit
As simple as the title, we would like to have a feature to hide certain fields in the bulk edit.
Can a rejected record be approved later in Zoho Creator?
If the approver rejects a record and return it for edit can a rejected record be approved later? and the user will be able to edit it and resend the approval request?
How to import OpenAI SDK correctly for use in a Node.js function in Zoho Creator?
I am trying to integrate OpenAI's Assistant API v2 with Zoho Creator. It looks like I need to use a Node.js function to achieve this, but it requires access to OpenAI's SDK. How can I accomplish this?
[Free Webinar] Learning Table Series - Creator for Professional Services
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
Monitor total of records across apps
Hi guys, The total number of records for all applications is increasing dramatically, is there any proper way for me to monitor this? Including how many records of each table in each app. I remember this can be monitored easily in ZC5.
Need Help With Inventory Application in Zoho Creator
I am creating an inventory solution which captures how much of a product was consumed and produced on a particular day. Any idea how to get the closing inventory on each day / user selected date? Thanks
Embedding Widget in a custom layout
I am currently trying to find a way to embed or display a widget in a canvas custom layout. Does anyone know of a way to embed a widget or embed a page with the widget on it in the layout? It doesn't look like i can use iframes on the custom layout or
Multiple criteria in searchRecords
Hi, is it possible to search with multiple criteria in zoho.crm.searchRecords? I have tried several variations of the following without much success. CustomerRecord = zoho.crm.searchRecords("Contacts", "(First Name|=| lee)" && "(Last Name|=| spencer)"); Thanks. Chris
Displaying multiple images in a Notes section
Hi, I'm hoping someone may be able to help me with an issue I've run into. I have followed the guides provided by Zoho to successfully create a deluge code which displays an image in a note section based on a selection from a dropdown field. However in
Printing records 8 to a page
I have a form for a label for a package, and the user needs to be able to print selected records as 8 (2 x 4) fixed size blocks on an A4 page. They don't have a subscription to Zoho Writer. But if I can generate a pdf document, I can email that to them
Conditionally mandatory field
Hi, i have a problem with On Add/Validate. I'm doing quite simple form (few fields hide on load, few condition for fields to show on user input - every condition on the same dropdown field) to my company contact site. But i'm trying to do one of on load hidden fields as mandatory if there were be executed condition for showing that field. Below i'm pasting my Validate code, can someone tell me what's wrong with it? I read lots of posts on this forum and i can't see differences between my code and
Multiple PDF File Uploding and Downloading as single PDF File
Hi I am having a requirement as below We ll upload multiple PDF file in mutliple records.- For Example : Each Trip will Each LR Copy Next we will Group multiple Trips as a single Records.And We need to download all that File as a single file Once selected
Auto Refresh Zoho Creator Page - Zoho Creator - Reports / Dashboard
#Tips & Trick Sample Code:- <%{ %> <head> <meta http-equiv="refresh" content="05"> </head> <body> <h1>My Website</h1> <p>Some text...</p> </body> <% }%> Paste the entire code in zoho create HTML Dashboard Option Thanks & Regards Piyush Goyal LinkedIn
Record/edit view to pop-up simultaneously with button click from report of a different form
I have two forms: Form A & Form B. Form B contains all of the same fields of Form A, plus a few additional fields. I've created a button in the report view of Form A that creates a new record in Form B and populates all the applicable fields, (I've posted the code I used below), but visually nothing happens on the screen. If I want to finish filling out the remaining fields in Form B, I have to navigate to the report and open the record. How do I get this new record to just pop-up when I click the
Email Deliverability - Caught as Phishing
email provider : Intermedia We are using Zoho Creator and Analytics to send emails on our domain's behalf and they are being flagged as External and Phishing in Intermedia and not being delivered to inboxes (quarantined). I have authenticated the domain
How to Create a Widget in a report in Zoho Creator?
Hello Team, We need to create a widget for a specific records in some report of Zoho Creator. can you please suggest a way to achieve it's. Thanks & Regards, Thisai Moorthy.
Custom Icon on zoho Creator APP
Is is possible to have a company logo as the APP image rather than the Zoho image? thank you.
Overlapping schedule
Hello, I recently started developping an app with Zoho. I am trying to build a form that will allow another user to enter a DateTime for an appointment. Once the time is picked, i want it reserved in a schedule. My problem is: After user A picks monday 9am to 10am, i don't want user B to be able to pick times between that timeframe. I want to avoid all overlaps. Also, is it possible to change the precision of the Date-Time field? I dont need to pick "december 3rd at 9:52.54".
Can I push stateless form entries into subform (inline) in another mainform?
My client wants to log all calls that come in from their registered customers. This will very quickly chew up their record limit. I am trying to figure out the best way to do this which balances simple UI with minimal record usage. One idea is to make
Label name limited to 50 charcters?????
When using teh new builder I received a msg 'Field display name must be lesser than 50 characters.' Switching back to the old builder allowed me to enter a longer label name. Will the label length be enforced? If so what will happen to long label names in existing applications. Herb Wexler
Linked forms
I have two Records: Account and Installment. One Account have at least one installment and one installment have one and only one installment. The idea is: when an user creates one Account, he informs the total value of the account and the number of installments
How to hide or show options in dropdown B based on selections from dropdown A
I have created two dropdowns A and B. I want to show certain options in dropdown B based on the selection in dropdown A. Is it possible? What is the relevant coding to perform this function? Please help me Many thanks
Connect to an API that needs to whitelist my IP
Hello, I need to connect to an external API and they only allow connections from whitelisted IP addresses. How can I achieve this if my app is hosted on Zoho Creator? Is the IP the same (static) for all Zoho Creator apps?
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
Next Page