How to get value from subform fields?
Hi all, I can't get or assign value to a subform field when the trigger is on "User input". "Harvested_Line" is a field in the subform. Snippet: lineList = List(); for each record in Lines[Parent_Farm == input.Farm] { lineList.add(record.ID); } row.Harvested_Line:ui.add(lineList);
How to load a Rich Text Field with information that is already formatted as a table?
I am trying to upload information from a subform to be displayed in a Rich Text Field. Ideally, I want the information to be uploaded as a table within the RTF. Is there any way to do this? If not, how do I print the information to the RTF and also have
"Invalid cliet task found" error while filtering Lookup Field values
Hi, I am encountering an error message, "Invalid clist task found," while trying to filter out the lookup values in Zoho Creator. Here is the script I am using: clear input.deploymentDate; availableDates = DeploymentWindows[availableDate> zoho.currentdate].availableDate.getAll();
Zoho Creator On-premise
Hi, Does anyone have experience with On-premise app development using ZC? I can see the documentation here but I can assume there are unwritten limitations and subjects we should be aware of. I would like to hear from your experience. Thanks, Naveh
Embed Report with Auto Height
Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditions
How can I filter a field integration?
Hi, I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
Consolidate Zoho Creator records to send via email.
I have been trying to figure something out for quite some time now but haven't had any luck. I need to consolidate multiple records from a Zoho Creator form into a single email based on certain criteria. For example, I have a form for which each record
Best way to display API data within a Creator Page?
I'm trying to build a Page that includes: statelessFormA w/ Lookup and text fields, a report view, and a section containing data from an API call. I've got statelessFormA and the report in place and the report is updating based on my inputs in the stateless
How to get zoho.loginuserid or loginuser in JS SDK Widget in Creator?
I want to use zoho.loginuserid and zoho.loginuser variables inside my JS widget. How to achieve this? Keeping in mind that these 2 are very important variables. Would parsing as parameters be an option?
Add Slider Field for Zoho Creator Forms
Dear Zoho Creator Team, I'm writing to request a new field type for Zoho Creator forms: a Slider field. This functionality currently exists in Zoho Forms, and its integration into Zoho Creator would provide significant benefits for data collection and
Skipping rows with certain empty column fields .csv upload in Creator
Hi, I have a script that parses data from an .csv file upload and pushes the data into a Zoho Creator Form. The script below is supposed to assign "0" value to the empty fields and delete them from the upload if they match the criteria. Unfortunately,
Stateless form on-click of custom button not doing anything, mostly.
Can functions be called on click of custom buttons in stateless forms?? I have: input.note_field = thisapp.function(input.field1,input.field2) and nothing happens, but this very function runs on user input of any other field in the form. I've tried something
Zoho Creator - Extend PowerBI connector to Excel
Hi, The Zoho Creator PowerQuery connector for PowerBI is great. This could be extended to PowerQuery for Excel which would be equally useful. At present I am going Creator -> PowerBI -> Excel and would love to be able to skip the PowerBI layer. Chee
Simple math return wrong result, or I am wrong somewhere?
Guys, please see below, am I wrong somewhere?
Display a Sign-up form on first logon
Hello, I am working on a customer portal and would like to somehow conditionally display a form (can be stateless) to a new user only on their first login or until the complete the form to collect more information about them, which I would then use to
Vertical Continuous Scroll Calendar Report
I'm assuming there's no way to do this, but I thought I'd ask just in case. Is there any want to make a calendar report that has all the months on one page, or like all in line vertically so that I can just scroll through the months instead of having
Subform of subform in layouts or record template
I have a form that has a subform with parts that also have a subform. Say I have a work order object, with part objects as a subform or lookup, and the parts just have a normal subform non-linked with two fields(operation, and runtime) Work Order ----Part(link)
How calculate total of rows from a subform in the mainform?
Greetings. I would like to calculate the total of the rows from my subform in my mainform. It is a screen to add transactions, so I have: Mainform with three fields: Transaction Type, Transaction Category, Transaction Amount Subform where each row has: Item Description, Item Price, Item Qty I would like that on each row added in the subform the field Transaction Amount in the mainform be updated with the total. Thanks in advance.
Whats the Time out Limit for API Calls from Deluge?
Hi Creator Devs, We are making API calls to third party server via Deluge. Getting this error message: Error at line : 24, The task has been terminated since the API call is taking too long to respond. Please try again after sometime. Whats the default
Update Related Records - Need Deluge Assistance
Thank you in Advance. I know enough to be dangerous - and i need help with a Deluge Script. I have two forms that are linked. Client_Details - (One to Many) - Associations I need a way to update specific fields on all of the related Associations when
Add multiple records from another form - deluge help needed
I know enough to be dangerous - thus i can't seem to figure out what i'm doing wrong here on this script. It won't let me save, saying error in line 1. Any help is appreciated for each fetchrec in Client_Details [(Status == "Customer") && (Status == "Pending
Record-Edit view in Page
Hi, I've been looking around but haven't found a solution. I'd like to have a page that displays a record in record-edit mode. I've tried an iframe using the structure below, but the app menu shows. https://app.zohocreator.com/<app_owner_name>/<app_link_name>/#Form:<form_link_name>?recLinkID=<record_ID>&viewLinkName=<report_link_name> I've attached a picture that shows this problem. Any help on this?
Using Zoho Creator Widget JS API with External Widget
Hello everyone, We are willing to use Zoho's Widget to serve an already published external website. The reason we want to use this external link inside a Zoho Widget is to use Zoho Creator Widget JS API to use Zoho itself as a data source for part of
Needing help with coding workflow
I'm not great at coding and haven't been able to get a lot of help. I'm struggling to get this coding right and nobody has been able to solve it yet. I will try to summarize and explain as best as I can. We have a parts form with all of our parts that
How to find out Leap year using Deluge Script
We need to find out the given year is Leap year or not in some calculations. any one Suggest ways to find leap year via script or any functions in the Deluge Platform. Thanks & Regards Thisai Moorthy.
Basic API Help
I've been learning Creator/Deluge for a few years. I don't have any other development experience, so I might just be in over my head right now, but...I think I've made a very basic API call from Creator to the music database Discogs.com. I can select
"Multilevel" lookup
Hi, I'm dealing with the following scenario: -I have a form to manage customer registry, containing fields like name, surname, telephone, email, etc. -Another form is used to manage contracts. Here, I input contract data and reference the customer using
Zoho Creator - [Free Webinar] Creator TechConnect Series - Customizing mobile applications in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
[Free Webinar] Learning Table Series - Creator for the Logistics Industry
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
Adding Data to Subform via Node.js API in Zoho Creator.
I hope you're doing well. I'm currently working on a project in Zoho Creator and facing a challenge with adding data to a subform using the Node.js API. While I've succeeded in updating data within the subform, I'm unable to find a solution for adding
Integrating Chatbot with Zoho Creator Application
Is it possible to integrate a chatbot with a Zoho Creator application?
Item Quantity
So, I have a form to take orders. I would like a dropdown/multi select to select the items the customer is ordering. I need a way to also specify the quantity for each item they are ordering. What is the easiest way to do this? I have about 85 items to
Auto Number Field
I would like to have an auto number field in my form that automatically resets back to 1 when it reaches 31. Or, if I can't reset an auto number field, is there any way to do this with a number field and a deluge script?
How to mass update field in one form with information from another form in Zoho Creator
Hi, We have a database in our Zoho Creator app with thousands of records. We have a 'Waiting List' form for children who register for our programmes and once they are enrolled (there is a button that 'enrols' them) they are pushed through to 'Students'
Zoho Creator Widget readFile API is Responding with the Outdated File (cached file)
What is the issue: - The download API is responding with an outdated version of the file (cached file). How to replicate this issue: In a form with a file input, upload a CSV file. Download the file using readFile method. Replace the file of the same
What is the purpose of CANCEL SUBMIT?
I have been researching the Alert command for use in a script. The documentation says the syntax is alert "type your message here!"; cancel submit; But you can only use Alerts on "Validate, on Load, on User Input" and you can't use cancel submit on "On Load or On User Input" BUT you HAVE to use cancel submit on "On Validate" or else "On Validate" will ignore it. AND when you use it with "On Validate" you don't get a pop-up box with your alert message and the option to "cancel" the submission or
Is there a Deluge way to DUPLICATE or COPY a record?
I have a need to duplicate a record from inside a Deluge script, and then modify one or two fields in the duplicated record. Is there a facilitated way to duplicate or copy a record in Deluge without having to manually do an Insert Record and set each field value, which is extremely tedious on long forms? Thank you. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
ENTER key triggering Submit
Is it possible to stopped the ENTER key from the mandatory triggering of the Submit button on Creator form? I want forms submitted "ONLY" when the Submit button is pressed.
SubForm Custom Sort - Deluge Workflows
I have been experimenting with the Custom Order function of Subforms, it works beautifully within the subform itself and retains the sorting order. However, I need to be able to iterate through the records in Deluge using the sort order (The usage case
"Code sign failed" when trying to download Zoho Creator application as Android Mobile App
Hi All, I'm trying to download my Zoho Creator 5 Application as an Android Mobile App. I fill the form with keystore credentials, package name, Firebase config, FCM server key. After clicking "Code Sign" button the process of generating the mobile app seems to be started. After some time when I refresh the page I get an error "Code Sign Failed", "Error occured while connecting to the server. Please try again after some time." I have already tried couple times with same result. What could be the reason?
Next Page