Dispatch Track Integration?
Has anyone been able to integrate Dispatch track with zoho? I want the 2 programs to "talk " with each other.
Add query string parameters with record redirect action
Greetings I have a page that displays dynamic content based on record id sent in query string parameter in the url. i need to access this page via record actions from report..so i have a report that contains many records, i defined my redirect action
Zoho Creator - Customer Portal API Access
Is it possible to create new customers in the customer portal through and API? I've been looking through the documentation and don't see anything.
Export form and subform data into spreadsheet
Hi How do i export my data from a form with subform into spreadsheet where the subform with multiple rows are exported into individual rows and columns? If i do a normal export, it join all the subform data into a column seperated by space/comma. I need
How to autofill lookup field within subform?
Hello. I need help using deluge to autofill a subform lookup-field depending on selection made from dropdown field within the subform. Please see details below. Thank you for your help! Chris Main Form: "Add_Customer" Subform: "Programs" Lookup Field
Import data from reports to page
Greetings basically i have a form that users can fill and submit, upon submission new reports are created with the data that was entered by users. i want to create a page that shows such data dynamically.. so i have the reports list that contains: report
UPLOAD JOB FROM ZOHO CREATOR
HI GUYS I HAVE ONE FORM IN ZOHO CREATOR NAMED AS JOB UPLOADING. I WANT TO KNOW IF THERE IS ANY METHOD FROM ZOHO CREAOTR TO UPLOAD JOB DIRECTLY TO WEBSITE , WITHOUT USING RECRUIT ? AS I AM NEW TO ZOHO NEED SOME HELP
Zoho Creator: Using Forms in "Detail View"
I'm having an issue with the sizing of a form opened within detail view. Can someone take a look at this short clip and maybe point me in the right direction? Thanks! https://www.loom.com/share/513860387b084153a844ddc84d513ecc
Upsert a record in the CRM
Hi Im building a customer portal. The user's details are already in the CRM. I want them to login to the customer portal and see a form that is autopopulated with their Contact record's details from the CRM. I have done this and its working. However,
Updating Sub-from with a Main-form value during insert into function
Hi All, I have an auto-num field Quote_ID in a main form and on successful submission I run a loop to update a numeric field Quote_ID in the subform of the main form. for each line in Line_Items { line.Quote_ID=input.Quote_ID; } I have a workflow where
Published Form not displaying correctly on Mobile
I have a published form that contains a single-line field which has been configured for Barcode/QR input for Mobile devices. When I access the form using the permalink, the form displays as the desktop version rather than mobile version and the QR input
Nested If Statements
Having a problem creating a nested if statement. This works: if((Imported_BPD > -1),Imported_BPD,((Feet * 12 + Inches + Quarter - Previous_Production_Inches) / ((Date_Time - Previous_Date_Time) / (1000 * 3600 * 24)) * Tank_Factor)) However, I am wanting to add another check to say if the formula is <0, then BPD = 0. Here is what I have tried but can't get it to work. Formula Field Both the argument should be same type for 'IF' task. Expecting 'IF' expression found 'BIGINT' expression
On Mobile, Closing a Popup/New/Same window via the "On Submit" of a form
I think I have found a Creator Bug. Or can someone help with a workaround? Scenario: I have an app that is used primarily through the Zoho Creator iPhone mobile app. As part of a custom workflow on report, when a user taps a button, it executes this deluge
There needs to be a single, universal way to TEST for EMPTY INPUTS
I am so sick of having to code multiple conditions just to see if a field is empty or not. EXAMPLE SITUATION I have a Validation workflow that runs when a user hits Submit on a form. The workflow looks to see if the user filled in a required field (Before
How to integrate zoho creator with google drive?
1. Create record in Zoho Creator 2. Deluge sends record data to Google Apps Script 3. Google Apps Script creates a folder with and returns the url to the folder 4. Zoho Creator receives the response and updated the Url field of the record 5. Users can use the Url to access the Google Drive Folder How can i do it?
Update status field of record in Zoho Creator when document signed in Zoho Sign
Hi, I have a Creator app that sends a document via Zoho Sign when a record is entered. I want to updated a status field in this record when the document is signed. I think i need to set up a web hook in Zoho Sign to point to the url of the report the
"other" option in Drop down form
I would like to create a drop down menu which looks similar to the following: Where are you from? Berlin London Paris Wellington please specifiy The user shall be able to pick from the existing options or to insert an additional choice (which is then not added to the list for all other people, it just appears in the respective cell on the spreadsheet). How would this work?
Zoho Creator Subform Auto Populate Lookup Dropdown field
I have a Main form called "New Order" and a subform called "Material Order" field name is also called Material Order (Link name SUB_Material_Order). Material Order Main Form has following: Type - Which is autopopulated in deluge so users know what "Type
Single Line - No duplicates
HI I have a form with an inital lookup field. Lets call it Country. I then have a single field called City. What i am after is I cant choose USA from the top field and then enter Boston twice as that would be a duplicate. But i would want to be able
Stateless Forms Popups are suddenly being stuck on page after submission.
My application that has been working great for 3 years now suddenly this morning has a error. After submitting(Are you sure? message) the popup doesnt go away, it removes the background shading and just sits on the frame. Anyone else seeing this? Like
Quick filters in embedded report resetting on refresh
Hi, When using quick filters on any report, the browser remember the filter after refresh. It doesn't happen when the report is embedded inside a page. Any solutions for this?
Grammarly and Zoho Creator
Hi there, I cannot get Grammarly to work on fields in Zoho Creator - this is especially important when we're writing important client documents. I have run the tests suggested by Grammarly, all of which pass (https://support.grammarly.com/hc/en-us/requests/new#/resolve-a-technical-issue/grammarly-browser-extension/i-don-t-see-the-grammarly-icon-in-some-text-fields/) This needs resolving as a matter of priority. See from the screenshot there is no Green icon in the bottom right of the text box.
Collections, Lists and Strings, Oh My!
Has anybody else run into the issue? You pass a collection of string elements to a custom function. Then iterate through using for each and Creator interprets each variable as string that includes the quotation marks. So a string "Dog" isn't actually
Need help with auto populating and filling subform
PROBLEM: We have a form named "Add_Program" and within that form we have a subform named "Services". Within the main form "Add_Program" we have a dropdown field named "Program". If the user selects "Cleanup" from that dropdown, the subform should autopopulate
Open Source Driving Distance Solution
Hi – I am looking for a solution for the following: I have two databases. One is a list of contacts with addresses. The other is a list of events with addresses. I am looking for a solution to map the driving distances between the contact address and
Uploads added to Zoho WorkDrive by Zoho Creator can not be read or viewed
We created a form. That form contains a subform with File Upload Fields. Files get uploaded and shown in the report. We created a Deluge Script that uploades these files to Zoho Work Drive into separate folders depending on the clients name. It works
How do I find the right Zoho Creator developer?
Hi Everyone, I am the owner of a small English language company in Costa Rica. I have a fairly robust app that we had developed a few years back by an expert who we will call Mr. X. I knew I was not capable of creating the app on my own as I am not a
Delete parameter page zoho creator
Does anyone else have the problem that the trash can icons do not appear to delete parameters from the pages? I have tried with several browsers and once a parameter has been added I can't find a way to remove it.
Default Drop Down Value when List Retrieve from other Table
Hi, I am adding a list from a table for one of my drop down menu using the following method: input.DropDown:ui.add(MyList) But when the list get fetched but there is no default value in the drop down menu until i click the dropdown. Anyone can give
Lost trying to use the Zoho Creator API v2
Hello, I'm having trouble getting started with the Zoho Creator API -- not even sure which client type to register. I have some business customers that log into my Zoho Creator app as Customer Portal users to add sales information, etc. Some of them have
@SUPPORT STOP EVERYTHING YOU NEED TO FIX THESES FIRST!!!
Now that I have your attention, let's make this thread a recap of BUGS and IMMEDIATE redesign/feature needed for Zoho Creator to be somewhat more user friendly for devs and users alike. Yes this is a spamming thread intended to get Support's attention,
Refresh/redirect parent page of iframe
Sooo, I'm fairly sure this is impossible, but I need to ask in case someone is much smarter than me. I have a bunch of forms/reports/pages that have workflows/functions that will either bring the user back to the homepage or refresh the current url. Those
Fetch Records From a Specified Date
Hi, I've been looking for a solution but cant find anything yet. Is it possible to fetch a record from creator using deluge for a specified date. For example i have a schedule running daily and i want it to fetch records for that day a week ago or 3 months
Fetch a Record, Rename and Upload to WorkDrive
Hi all, We have thousands of test records and we can click the 'download button' on the report on a single record and it will rename and download, as below. It works great, nice and easy. //groupReportNo = frmGroup[ID = input.groupID].groupReportNo; //groupReportID
Multi-organization SAAS application
Hello, I am considering using Zoho Creator to create a large-scale business application. Since this SAAS application will have to serve several different clients (organizations), I plan to make it accessible through a Zoho portal. My question is: How
Create a record/row on subform from existing fields on crm record
Hi there! Not sure if this is possible, but this would make a huge difference in our system. I want to create a row in a subform (with four fields) from existing four other fields in the main record for my module 'Migration'. The fields are the same
Sort function out of work
I create a collection and try to sort by date. but no matter I use sort or sort key . the collection order didn't change. aaa.insert("1231231","2022-10-10"); aaa.insert("1231232","2022-10-11"); aaa.insert("1231233","2022-10-12"); aaa.sort(true); aaa.insert("2022-10-10","1231231");
Checking fully booked on form load
Hi all, I have a system I have built that allows people to book on an adaptive form based on the company I want them to use. This is just piped into the end of the URL and then they fill the form out filtered on that. They have weekly options too so they
Creator Widget JS API Example
Does anyone have example code they could share which uses a ZOHO Creator widget to add a record. There are code snippets at the link below, but they aren't very extensive. https://www.zoho.com/creator/newhelp/app-settings/widgets/creator-api-for-wid
Working offline in Creator?
Hi all, I'd like to know if there has been any development in the past few years? One of my potential customers would need a reliable and intelligent solution (not only on mobile, easy and user friendly upload). The company has mobile agents, who work
Next Page