InvokeURL variables from another form
Hi, I'm hoping the answer to this is easy and I'm just being dumb... just can't get the syntax right I have an InvokeURL task that works, but instead of making the same task for each company lookup, I want to substitute values from another Form. ie. I
How to filter Values in a Dropdown List
I have a form to collect equipment category name. eg. Dryer, Heater, Cooler etc.... Form Name - 'Add Equipment Category" Field Link Name - "Equipment_Category" Then, I have a form where equipment names are being collected and each of them are being mapped
How can I compare data from two reports into a third report?
I'm using zoho creator to make a simple interface for me to manage a client database and the services I provide. I have two forms: Student form - has a numeric field where I record the number of minutes that student is allotted to receive
API calls and security
Hi All, This is really just a call for general advice about security I make API calls to grab info from an external resource into Creator for say 6 companies Each of these API calls requires a username, password and token, and they are all different.
Unable to select save "Print" of PDF" Option in Page
Hello, Today I attempted to enable the print or pdf option on a page in creator. When I hit the Gear icon in page edit mode, creator shows me the options: I am able to select the option to print and enable pdf. When I exit, nothing changes. I am still
Sorting the records using a date Field
Hello all, I have an income expense application and I am trying to show the last 15 days spending in my page. While trying to fetch the records from my expense report I am trying to sort the records based on the date field. I am trying to set the range
C5 Dashboard with embeded report has strange page break
I'm just using a creator pivot report from within the same application but I can't get it to show full length on the left hand side. Instead theres a grey page break in the panel itself.. it's not the end of the panel, just seems to be the end of the
Dashboard to be sent as email attachment
Hi, I can send view in PDF format via email to users using the following code: sendmail [ from :zoho.adminuserid to :"user@email.com" subject :"Report Summary" message :"Report Summary" Attachments :view:Report_Suammary as PDF ] but is it possible
Publish/Deploy app (ROI calculator) to any visitor
I built an ROI calculator as a marketing tool for my SaaS company. It is a multi-form based app that asks users to input certain values, then the app will calculate how much new revenue my company can help drive. I want to publish/embed this app within
HTTP 429 - Too many requests
I'm trying to add multiple rows using v2 Creator API method https://www.zoho.com/creator/help/api/v2/add-records.html Unfortunately after 100 requests (done in aprox. 20 seconds) I'm receiving response with HTTP code 429 Too many requests (which could
Empty a field when clicking submit in a stateless form.
I am trying to null a field on the submission of a stateless form with an alert but it's not working. if(input.Time_Slot == null) { alert "Date slot cannot be empty"; input.Type = null; input.num = null; } Its working on user input of a field. if(input.Type
Add Record with info from separate form
Hello. I've looked through some of the documentation and other posts but need some help. Please see the info below and I've also created a 1 minute video of the process. Thanks for your help! Video: https://www.loom.com/share/665825740aad46d5993172e6ec6c0c49
How To Prevent User from Adding or Deleting a Row in a Subform?
Is there any way to prevent a user from adding or deleting rows in a subform? I preload the subform tables with just the rows I want the user to update and I don't want them to add or delete any of the rows. The number of rows in the subform will depend on data in the parent, so I cannot use the feature that limits the number of rows (and that feature doesn't help me in preventing the user from deleting rows). Jon
I can't push the uploaded image from the app zoho creator to crm
How can i push the uploaded image to crm? I already created the code for it but its not working. newEmployeeInfo = Map(); newEmployeeInfo.put("Name",input.Name); newEmployeeInfo.put("License_or_ID",input.ID1); response = zoho.crm.createRecord("Employees",newEmployeeInfo);
Parent Child Form
I want to calculate Job Count but I didnt Pls help me
Google Address Validation API (JSON issue)
Hello, I am trying to build address verification with Google API as per instructions here - Validate an address | Address Validation API | Google Developers I am required to pass JSON body as follows: curl -X POST -d '{ "address": { "regionCode":
Auto fetch records App B from App A
Hi I am to fetch records between apps from App A to App B and I tried some deluge code and functions but I got two Issues. Code from App A ---------------- string getApprover(int Admission_ID) { fillName = Admissions[ID == Admission_ID].Name.firsN;
Summary Report
Hi all, We send test reports to clients in PDF format. The client has requested to receive the data as CSV. Our system is set up with the main form called "Groups", and sitting inside that is a subform called "Samples". The samples subform contains a
Passing Variables from Widget to Page
Hi is it possible to pass variables from a Widget embedded in a Page back to the page - and allow this variable to be used via HTML snippet, ZML or Deluge? alternatively, how can a widget redirect to a form (not published) with variables (#Form:Myform?field=variable)
Send record reference when redirecting to a form
Greetings, i need to add "rejection" button to records in my report. when this button is clicked it will redirect the user to a rejection form (unrelated to the original report's form) where they can fill rejection details, but i want to also refer to
how to make reports record button disabled?
Greetings i'm looking for a way to make buttons of records that has certain status disabled, something similar to what the creator's quotation management does, but i can't find the scripts that achieve this purpose there..how can i do this?
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
Next Page