Pass information from popup subform back to main form
I am developing a form that has multiple subforms on it. The subforms work great on a normal computer however the Zoho Creator mobile interface has a defect as it cuts off the subform fields, doesn't resize when I turn my phone and to scroll over you
Use values from one workflow in another workflow
Hi, i created a "Load of the form" workflow for when starting the form to create 5 lines of the subform. Now want when I fill in the fields of the generated lines and press the SEND button, run a script that takes the data inserted in this subform and
Deluge Scripts when editing from a report
I have a deluge script that works great when I'm adding a new form entry, but doesn't seem to fire when I'm editing a form entry. The script hides a field based on the input value of another field on the form. When I'm adding a new entry, the field
How to get old value and new value of a field of a row in sub-form
Hi, How can I store values of any field before it is modified as I need both old value and new value in my application. Also it is not one field but I want this for a field in each row of a sub-form. Is there any way to do this? If I write a code on User Input then only new value is available old value is gone. Similarly it is difficult to store these values on On-Load trigger as there any many values. Please help. Thanks, Milind Manohar
On form submission check if similar record exists
I want to run a check on each form submission. It should check all existing records on any matching records based on two fields, DOB and Last name. If a match is found it should send an email. I think I am close but not exactly the right code. Can anyone help? Tried this as a workflow on created on success: pnRecord = Register[ID != 0]; for each pn in pnRecord { //fetch matching person records by DOB and last name pm = input.Date_of_Birth == pn.Date_of_Birth && input.Name.last_name == pn.Name.last_name;
Update parent form with data from subform
Hello, I am trying to set up a workflow that will allow me to pass some data from a subform back into fields in a parent form. The Subform does have a lookup field that refers back to the parent form. How can I reference this in the deluge script in
Auto Update a Date field
I have an employee form where the "Years of Service" date is calculated based on his/her hire date. yos=dateofhire.days360(zoho.currentdate)/365; When I view the record, the Years of Service is incorrect. If I go in and create a new or edit the date of
Auto-fill name field
I have created an app with the following forms Registration form -User enters their Name in a name field Scheduling form -There is a name field that should auto fill with the user's name based on what they filled in the Registration form. How can I do
Calculate ages
Hi I'm not technically minded and need to be able to show peoples ages in the Contacts app based on the Date field. Is this easily done? I've had a look at the formula field and got a bit lost! Thanks. Richard
Validate of Form Submission Workflow not Running on Create
I have one workflow for validating a form that runs when editing or creating and works properly. However, for all new forms I cannot get the validation to run when creating. I created a new app with a simple User form and the attached workflow. It runs when editing but not creating a user. Similarly, if I create a workflow that should run only on creation it does not run either. Any idea why this would happen?
Fetch a range a records based on criteria and insert each record as a string into multiple form fields
See the most recent attempt below. Basically I've found lots of info on fetching data but not too clear on how to then put it into form fields when you're fetching a range. I would like my users to be able to see the three previous entries into this form (Daily_Nursery_Log), when they are adding a record in this stateless form(Nursery_Action_Log). I thought it would be easier to input the key fields as one single line field combined, as you can see below. But that is not a requirment. I've tried
is there any way to set height for html snippet?
i use the snippets for embedding reports inside a Page
Number formatting in reports
On screen, when large numbers are un-formatted they are quite difficult to read: What would be really useful and user friendly would be the option to apply number formats for numeric fields in reports. In particular, thousand separators is what I need. For example, I would like to format the numbers 1200000 874000 2000000 like this: 1,200,000 874,000 2,000,000 It seems to me that a reasonable place to put this is under Report Settings -> Column Properties. There is a work-around which involves converting
download attachment API
Hello, I tried download attachment API of zoho, which returns above data how will I convert this above data to proper image type.
How to perform field on user input action in subform
I have a form, Data, that has a subform, Calculation. In the Calculation subform, there are 4 fields, Component (lookup), Concentration (decimal), Unit (dropdown), and Concentration in Percent (percent). The goal is to convert the concentration in the unit selected to % using the Unit as the On User Input trigger. For example, the user selects the component, type 1000 in Concentration, then selects "ppm" from the Unit (dropdown) field, the script should run and output "0.1000%". I can make this
Creating a in Creator using Data from Zoho CRM
Hi, I'm looking to create a customer viewable portal using the Creator app. We would like to be able to create a "Payment Profile" table from data in zoho CRM to be displayed in the customers page. For example in CRM we would have fields such as Payment
Adding Subform data to Books Purchase Order Subform using API
Hello, I am trying to add creator forms subforms data to Books purchase Orders Subform but i am not getting any exact format as of how to map the subform data. This is the code i tried mapp = Map(); mapp.put("vendor_id","177093000000077066"); mapp.put("purchaseorder_number",input.PO_No);
Zoho Creator Third party Access
Dear All, I hope you are well and healthy. I want to ask a brief question regarding Zoho Creator. Is it possible to have third parties accessing the Zoho creator through a web interface and without providing them the right to edit or modify the data?
Is it possible to change relation Call_X>Contact_1 to Call_X>Contact_2
I've got a bunch of data in Zoho CRM. By some reason I'd like to make some historic Calls be related to another Contacts. I.e. Call with ID=zcrm_0...x relates to Contact_1 with ID zrcm_0...1 (or even has no related Contact at all) should be changed to
Trying to SUM or ADD prices in subform
I am having trouble adding the currency field in a subform. I have tried quit a few different way but cannot seem to get it to calculate. I have other calculation like this for another form and it works just fine. Attachment shows what I've tried.
[Subform] Select fields to show instead of hidding the rest
Hi, When adding an existing form as a subform, all fields are displayed. More often then other, there is no need to show all fields from that form. Usually, we will want to display a minimum of fields to allow for a clean UI and hide the rest. Instead of having the create a workflow to hide all the extra fields, please allow us to select which fields we want to include in the subform. This could present itself in the same way we select fields to appear in a blank subform. This is convenient, quick
Sendmail task: How to improve deliverability?
Hi, My sendmail email always end up as junk. How do I improve the deliverability? Thanks!
Syntax for Tab and Enter keys
Hi: In a Multi Line field a user can press the Tab and Enter keys. I would like to know how one references these "invisible' characters inside such a field with Deluge commands like ... <string>.getPrefix(<substring>) ... is there some special syntax that can be used to define such characters for <substring> ... like "\t" or "\n" or "	" or "
" etc. ? In one of my projects, I need to parse entered values separated by spaces ... but users might mistakenly type Tab or Enter keys ... so I want
Numbers appear as strings in API v2 JSON data
Hello. I have developed an application that retrieves data from Zoho Creator by calling the API. When I used API v1, all the numbers in JSON data were just numbers (for example, ints), but when I use API v2, numbers are treated as strings, which (in my
Send file to external service in base64 format
Hi, I need to send an uploaded file to my Zoho Creator app to an external service. But my file is unreadable at destination. I'm trying the following code // MBL_File was uploaded to the form. I also tried without encoding it file_content = zoho.encryption.base64Encode(input.MBL_File.content);
Comparing one list to another fails
LIST1 = ("cat", "dog", "bird", "fish"); LIST2 = ("cat", "dog"); for each element in LIST1 { if (element not in LIST2) { // do something } } Gives an error "Left expression should be a field name for 'not in' operator". REALLY? The help section (https://help.creator.zoho.com/Operators.html#List_Operators) states that The List Operator not in checks whether a value is not within a set of values Syntax <expression1> not in <expression2> where, the right expression should be of type
Keep lookup field value when adding new record
When a user types in a lookup field to find a matching value, and there is no match, they can click the Add new record link. We need a way to keep the text they began to type, and transfer it to the new record. For example, there is a lookup field named
Multipage forms
The below is a quite good example how to create a multipage forms in Creator with next and previous buttons Each of these buttons redirects to another form vice versa https://app.zohocreator.com/sampleapps/next-previous/#Form:Form_A My question is, if someone lets say stops the process in step 2, is there any way the system to 'recognize' that the process is 'uncompleted' and to continue from this step another day? Or maybe to add a button in the report (as function) to continue the process from
Creator API - Setting up and using the OAuth process
So full disclosure - I have never done this before, but after following all the steps I have hot a brick wall. All the IDs and codes, below, are redacted for security - I have been using the unedited versions :) My end goal is send a URL request to search
Proper() statement for a multi-line field
Hi, I have a small function to tidy up address data from a mix of lower/upper/proper case formats. The Address field is a Multi Line text field in the form, and I find that when I run this script, it only applies Proper case to the first line, and lower case to subsequent lines in the field. For example: ADDRESS LINE 1 ADDRESS LINE 2 TOWN CITY becomes: Address Line 1 address line 2 town city where I am expecting: Address Line 1 Address Line 2 Town City My initial guess is this is a bug, does anyone
How do I return to the originating form when the user completes a form in a pop up box?.
I want to do something really simple. I have a form that a user fills in then presses decision field that then opens another form to complete in a pop up window. If the form exists it opens the existing form otherwise it opens a new form for the user to complete. What I'm trying to do is go back to the original form when the user closes the pop up window. In other words. From a report view, open new or existing application form. FORM A, whilst completing FORM A, the user launches FORM B in a pop
zohopublic not working
I have a zoho public which have been working fine last week, but now it suddenly stopped working in guest browser in chrome, but when trying it in regular chrome by being logged out from my zoho account it does work... very interesting, please help
refresh form
I have a form to generate orders. at 3 pm you can no longer generate orders for the next day. but somehow they have been able to place them. My question is, how can I make the form after some time of user inactivity, even though I have already filled
Sort data by Date in Collection
Hello, I am fetching data from multiple forms and i am trying to sort the data by date wise.But i am unable to get success in that. Following Eg. is the way i want Invoice No. Invoice Date Purchase Qty Sale Qty 15
Unknown Error when using User Role to set Field value
I have a form with a "Location" field that should be preset if the Role of the user filling in the form is "Storekeeper". I therefore have the following 'Created or Edited' -> 'Load of the Form' workflow: if(thisapp.portal.isUserInProfile("Storekeeper"))
Community Webinar: Bring your own code to Creator with Java functions | Nov 10, 2020 [Completed]
Hello all, Our next webinar is a session on using Java functions to Creator scheduled for 10th November, 2020. APAC/ MEA 10 AM IST/ 2 PM ACST Register here Americas and Europe 9.30 AM PT/ 5.30 PM GMT Register here Third-party programming languages will
How to link fields between forms? How to add a "copy content" option to a field?
Hey, Question 1: How to link fields between forms? I have a form on which I manually add data, let's say Name. I have a second form that contains separate data, let's say Address. I have a third form that contains other separate data, let's say Phone
Zoho Creator positioned as a Visionary in 2020 Gartner Magic Quadrant for Enterprise Low-Code Application Platforms
Hi folks, We come bearing good news! We are delighted to share that Gartner has named Zoho Creator a "Visionary" in this year's Gartner Magic Quadrant for Enterprise Low-code Application Platforms (LCAP). Gartner Magic Quadrant for Low-code Application
Pushing data from Creator to CRM Lead
Hi there, I'm trying to make a booking app by using a pre-made Appointment Management app in creator. Form works fine but even there is no error message, somehow I can't push data from creator to CRM Leads. Is there something wrong on my code or do I
Date/Time fields on iPhone Using an Invalid Format and being set 2 Hours early
A user of our app recently noticed that date/time fields were causing problem when a record was updated. When a user clicks "Submit", the app pops up a warning claiming that "Invalid entries found. Please correct and submit again.". At this point the app focuses on one of the date/time fields and shows an error message that reads, "Enter a valid date format for date/start time." The date has not changed for this field, and the format has not changed either. This only happens on iPhone - desktop
Next Page