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
Subforms : Clearing and only showing matching results in drop downs (pick lists)
I have a script that creates rows in an attendance subform when a training course is selected. So that I can add an employee to multiple courses. It works great, however there is a drop down for each course containing a list of modules - this currently shows every module for every course. I have been able to use deluge to only show modules that are related to the selected course - but this does not work in a subform for me. My Code : for each subRecord in input.attendee_subform { ModuleIDs =
Upcoming updates - July 2019
Hello App Creators, We’re here with another set of updates. During Jul-2019, the Zoho Creator team will be rolling out the following feature updates: subform.insert() and subform.clear() Zia-powered smart data import during form creation Ability to control rendering of HTML content in Formula field Lookup data from Radio and Drop down fields Setting background images for panels Here are the links to the recent posts in this series: Apr-2019 updates, May-June updates. Refer to our changelog for the
generate pdf of customized HTML contents using zoho creator deluge script
Hi Team, I am creating a request to send a set of HTML contents using SendMail function of zoho creator. I can send the HTML contents succesfully in email but along with that I want to do is to create a PDF file of that HTML contents & send it as an attachment from zoho creator's SendMail fucntion. Firstly is it possible.? If yes, how do I achieve this scenario.? Thanks & Regards Amit Thakkar
Can a embedded Form be passed different values depending on the Webpage that it is accessed from?
For instance, I have a website that allows the customer to select their sales agent and proceed to a page with an embedded Zoho Creator Form. Is there a way to prefill the sales agent information on the load of the embedded form? I know I can use redirect
Zoho still sending us spam mails
Lee Joseph from Zoho Creator (Lee Joseph <lee@zohocorp.com>) still keeps sending us spam mails, though we were told some weeks ago he would stop doing so. Can somebody please tell him to stop his spam mails? Thanks Juergen
Upcoming updates - August, 2020
Hello App Creators, We'll be rolling out the following updates this month: About upgrading to Creator 5 File preview in reports Displaying published components inside published pages External hosting for widgets, and more Supporting record templates in
Quotation marks in a string
I see this same question multiple times in the forum, but no answers. How do you set a string variable with a " embedded in it. I need the resulting string to be ... "text"... It cannot be a ' Help please, thanks!
I'm new and don't know where to start
I currently have a few applications built on Caspio and I am looking to migrate those applications to zoho. I have a large database of addresses that I want to build a custom search for, and I can't figure out where to start. I have imported my addresses
Creator and Zobot
My company has the whole umbrella of Zoho apps and are looking to fully integrate across the platform. We have used Zoho Creator to create our webspace and want to use a chatbot to interact with out clients using the power of deluge and zia... I really
Fetch records from Books especially the General Ledger accounts?
Hi there, I'm trying my hand at creating an app and I need some help in fetching records from Books but especially the general ledger accounts and cashbooks. I havent been able to find a reference to this. I would appreciate some help... Much thanks, Shawn
Can't access Creator Form from Edge or Chrome or Monzilla but can via IExplorer
I have a form created and has been running for years by another person. This morning they can no access it. Only the title comes up in the top left corner. I said to try other browsers to try and narrow the issues. Chrome - fail Edge - Fail Internet
Clicking on link in detail view brings me to blank page
I have my detail view for a report set up for clicking on a related item and going to that related item view. When that view shows up, I see it on the right side and on the left and background is the report view but it shows no records. I close the detail view of the related item and the page still shows the report with no records. I have to refresh the page for any records to show up. It should be showing records for me to click on after loading the related item detail view on the right. Also,
Updates - January, 2020
Hello App Creators, A very happy new year to all of you! The interactions we had with you last year made Creator's 2019 journey remarkable. And we'll be working hard to make sure Creator gets even better in 2020. We'd like to welcome you into the new year with some updates: Support for reading NFC tags Accessing apps as PWA - - - - - - - - - - Support for reading NFC tags Zoho Creator's native mobile apps can now read data stored in NDEF tags and input them in form fields. Learn more NDEF - NFC
Internet facing
Is it possible to have a Zoho Creator app internet facing with no login? If yes is there an add-on or cost to make that happen?
API V2 Issue for HTML Form Submit to Zoho Creator
Hi There We have multiple Html Form that use API V1 to submit into our Zoho Creator. It seems the new API V2 requires user to login to zoho before can generate the token and submission. is there a easier way for us to continue submit our form to Zoho
Take time to load & unexpected error.
Hi, Team form today morning Zoho creator is not working well. it takes time to load. sometimes doesn't show data. I have tested with diff accounts on the EU domain but the same issue. after checking the console it gives a lot of error. Anyone when it
Integrating biometric device with ZOHO Creator
Integrating biometric device with ZOHO Creator for tracking Attendance with in ZOHO creator. I am new to ZOHO Creator i am creating an application. In that application i have to manage data or attendance from a biometric device So how to integrate
Ignore empty criteria when fetching?
Is it possible to ignore empty criteria when fetching? Color = "blue"; (Food is missing / empty) Animal = "cat"; fet = Form [FavoriteColor = Color && FavoriteFood = Food && FavoriteAnimal = Animal]; @Damien?
Form Structure for Multi-Level Manufacturing BOM
Hello Zoho Creator community! I'm looking to use Creator to help me with our inventory management, ordering, etc. for our manufacturing business. I'll be hiring a developer to help eventually, but I'd like to get some core parts of the structure in place.
Next Page