Adding rows to a subform of an existing form
In Zoho Creator I created a "Deals" form, which has a subform to an existing form of "Deal Items". I want to add deal items to an existing Deal record, using deluge. I know how to do it for a subform of a blank form (as detailed in this documentation),
ENDPOINT ZOHO CREATOR
I created a function to perform the action of POST, GET and PUT in order to use it outside our portal and create more dynamic forms using a cloud server. Params = “qAvhbBBJJsQysd45DdkvTR34A” Curl = “https://www.zohoapis.com/creator/custom/admin2844/vallesalud_julaje_private?publickey=”;
VIEW HEADERS PARAMETERS
A function was created in zoho creator. In the microservices “https://creator.zoho.com/userhome/<adminuser>/admindashboard#/microservices”. A custom API was created and associate the function. In the postman I send some data, how can I visualize what
Using pages as webhooks - how to return a json response
Hello, I'm working with an external service that needs to send some data to my Zoho Creator app using a webhook. SO I created a simple page with three variables and published it. Although I'm able to get the webhook data correctly the external service
Getting error while calling API in extension widget
Hi all, We are trying to call an public API in a Zoho creator extension. I am getting as follows r Refused to connect to xhr.js:188 https://www.zohoapis.com/creator/custom/user2_demo2127/testApi?publickey=TCCn@7KEpRUAEuxDz4VMt...because it violates the
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
Zoho Creator customer portal limitation | Zoho One
I'm asking you all for any feedback as to the logic or reasoning behind drastically limiting portal users when Zoho already meters based on number of records. I'm a single-seat, Zoho One Enterprise license holder. If my portal users are going to add records, wouldn't that increase revenue for Zoho as that is how Creator is monetized? Why limit my customer portal to only THREE external users when more users would equate to more records being entered into the database?!? (See help ticket reply below.)
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
Next Page