What is wrong with this code?
I am new to Zoho Last_Purch_Price, Sup_Cost_Factor, & DPI_Cost are decimal fields, Units_in_Purch is a number field In the same form. I want to calculate the DPI_Cost, but only if there are valid values in the 3 fields needed for the calculation I tried to enter this code in the On User Input field action of the DPI_Cost field: if(input.Last_Purch_Price != null && input.Sup_Cost_Factor != null && input.Units_in_Purch != null) { input.DPI_Cost = ((input.Last_Purch_Price * input.Sup_Cost_Factor ) /
Creator Learning Resource
I'm new to Creator and have seen all the demos, tips and tricks etc. Is there a course-like resource that takes a new learner step by step through Creator? I just want to find an organized method for learning Creator- going from simple to complex.
How to migrate from old price plan to new?
I have a real old Creator account and want to migrate to the new free plan to try it out. How can I do that? Bruce Letterle Red Lab Media
Filter for for Creator Report: count of a certain value for a field > 1
I need a filter for a Zoho Creator report, where I only want to display rows where a value in a field has appeared more than once in the form.... This filter does not work: (FORM1 [FIELD1 == input.FIELD1] ).count() >1 Any idea?
How to pass data through openurl link into an Embedded form (in Wordpress)
Any idea how to pass data into an embedded form? Preferably Zoho Creator form but I can use a Zoho CRM web form. For example if I pass a link into a scheduled email - that says "Update Billing Information" I would like to pass the ID of the Company into the embedded form so the data links properly.
Searching in a lookup field
I am trying to set up a search page based on a lookup field (Child's Name). This generates the ID number. The search field (Search Child) is defined as a Bigint but in the HTML page the searchParam is defined as a string even though it is actually a number. This means the searchParam never matches the Child's Name field. I tried changing the searchParam to be defined as a number but it gave an error saying it was trying to update to a different data type. How can I adjust the code so the search
Child fields
Hi all, I am building a simple database and I would like to focus on 4 forms : Companies: legal company details Addresses: a list of addresses, zipcode, city, aloso defined by an "address name" Sites: association of a company and an address, because companies may share the same address. I have two lookup fields by company legal name (relation to Companies) and address name (relation to Addresses) People: all details for on person with a lookup field to Sites, so that each person is linked to a site,
ZOHO Creator can not access Edit Record
Today, for some reason, many of my records can not be edited. I get the circling and the "Please Wait" message forever! See attached.
Connecting from Creator to CRM
Dear, I have created a (very small) application in Creator, which includes CRM data fields, e.g. Accounts. I have created a list, in which the CRM accounts are visible. This field is "imported" out of CRM. Now I want to go to the account in CRM and do this by clicking on the "Account Name" in the list. This opens the CRM application, however the message is that I have "Insufficient privileges to perform this operation. Contact your Administrator.". I am the administrator and have full access in both
Filtering Lookups
I am a newbe to Zoho I have three forms: Inventory (with among others 2 lookup Fields, Product_Class and Product_Sub_Class) ProdClass (with one field, Product_Class) containing all unique ProdClass in ProdSubClass ProdSubClass (with 2 fields, ProdClass and Product_SubClass) containing all valid ProdClass and Product_SubClass combinations The Product_Class lookup of ProdClass works fine. I want to filter the Product_Sub_Class lookup to only include records where ProdSubClass.ProdClass = Inventory.Product_Class
filter with date in for each
hello, how can i make to have all items where DATE MODIFIED < year(current date) ? i try for each i in MyForm[Modified_date < year(zoho.currentdate)] for each i in MyForm[year(Modified_date) < year(zoho.currentdate)] do you have an idea ? thanks you
Displaying data to user upon form submission
I've created a form via ZOHO creator which appears to be working well, but the feedback we've received is that users would like to be able to review the data they've entered as a confirmation, once it's been submitted. For instance, once the form has been submitted, it'd be great if the data would be displayed so that the user could print or download a PDF of the entries they'd made? I know that I can have the form, upon submission, redirect the user to an HTML view, and that said HTML view can
Using dynamic lookup fields in subforms
I figured out how to do this on a regular form, but then I had the "brilliant" idea to make it have a subform so that more than one item could be ordered. It isn't working though. I would appreciate any help. I am anxious to learn Creator and seeing all that it can do. So, i created two new forms. salesTemplate - The subform with the lookup fields on it salesTemplate2 - The form that the subform will be on. The code I wrote for a regular form is this: //Set Price field newprice = Products [ID
Fetch and Update
Hi, I have a form "Lesson Items" with the dropdown field "To_Do". I have a second form called "Plans" that has a lookup field to "Lesson Items", and (also) a dropdown field called "tasks". I already have it set up to pull in the values of the lookup items "To_Do" field and populate the "Tasks" field. That works fine. But what I want to do is make it so that when I update a "Lesson Items" form, it will update any "Plans" forms that have the same ID in the "Lessons Items" lookup field. I have tried:
Record Summary format is modified when printing and downloading as pdf
Hello, I have a record summary design but when I try to download or print one in the report page, the format is changed and it looks very different from the original design, I need it to be exact the same format. I attach the original design and how it moves when I try to print it Note: It is duplicated because I need two copies in the same sheet Thanks
Function to populate a field in a report with corresponding data from another report
I have a form and report (A) in which I forgot to add a field called 'User1'. I have another form/report (B) that has the the field 'User' in it. They both have a field called 'Patient ID' that is common between them. I would like a function script that I can execute as a one off that will do something like this: for each record in FormA where 'FormA Patient ID' = 'Form B Patient ID' update 'FormA User1' with 'FormB User' There are 15000 records to update. Would this be possible? Thanks in advance
Update and insert into form at the same time
I need to write a script so when importing records into a form, the existing records are updated, while the new records are inserted. How can I start writing such a script? Thanks!
Insert Image or logo in a form
Dear Sir I have create on form having two field "Name" and "Image" and create a function module and use above code Code as follows string Pipeline_Management.Image(string name) { imagelnk = Image[Name = input.name].Image; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","#View:Image_Report"); imagelnk = imagelnk.replaceAll("fieldName","Image"); return imagelnk; } But the return statement
Subform Record Delete Behavior
Hi, Can someone confirm for me that as soon as i click the "X" delete button on the subform, that record is deleted, regardless whether i Submit the main form or not. Is there any official documentation about this behavior? Is the subform On Delete script executed before or after the subform record is deleted? Again, can't find any documentation that addresses this.
Avoid duplicates while importing, with a composite key
I am trying to import records into a Form, and need to avoid duplicate entries ; the key for each row is a composite key made from field A and B. if ( (FORMX [A = input.A && B = input.B ].count() >= 1 )) { alert "Duplicate! Please check your entries！"; cancel submit; } But the same script does not work for ON ADD validation . Can someone shed some light into this?
how to extract email from muti-line text?
hi there is records which contain one email in mutli-line field how to extract such email from whole text of this field?
Form Timeout?
Hi all, Is there a way to implement a form timeout? Ideally, I'd like to be able to set a timeout on a form for a period of time where there has been no user interaction define an action when the timeout is reached (in this case load another form) I could try this by building a page with a timeout if I was using a browser, but my app is used within the Zoho Creator Mobile app so I specifically want it to load a form or view on timeout. Thanks in advance!
too long time - adding field to form
hi there is too long time when i add new field in big form https://creator.zoho.com/appbuilder/rfclient/ikeaserv-app/form/zayavki_form/edit was tried on firefox/chrome/safari, macos when i add in a little form - all works well
How can i make a two colum layout only for particular fields?
I just created a form consist of two columns. i arranged the fields. While arranging the subforms field i just want to display in the single column is it possible ? Please suggest me
zoho.currenttime
Hi Sorry of these are dumb questions .. just started using the system ... When I create a timestamps using zoho.currenttime it seems to include the date .. is there a way to only include the time .. Also is there a way in formula to work out the delta between two timestamps .. Example .. first record is (time) 15:00 and second record is 15:12 - so answer would be 12 Thanks Mark
Error login Mass Downloader
Hi Since 2 days ago I cant login anymore using the file downloader found here: https://help.zoho.com/portal/en/community/topic/download-all-file-attachements I need to back up all my files stored in ZohoCreator locally Please help Raul
open url
hi. can someone please help me i am trying to pass values from a report to a stateless form my reports url shows as: https://app.zohocreator.com/******/*******/#Report:Quotation?Fare_ID=3 and i wish to open a form using open url and assign fare id field in the form the value of reports fare id. i appreciate your help regards adeel haroon
Failure to receive Email confirmation on Outlook
Please help us on our problem - We are not receiving email confirmation from Zoho to Outlook emails but in Gmail were able to received all the email confirmation - Before we were able to received it even the recipient use their Outlook emails Hope you can help us or advise us what to check or what to do. Thanks!
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record?
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record? I would like to go with Zoho creator to interact with existing records. If not possible, any ideas? Something like this.
Customer Portal
Hi, I have created an application and enabled customer portal thru application settings. Later I registered 2 users to this portal for testing purpose. I created a few records by logging in with user X. However when I logged in with user Y, then I am able to see the records created by X and vice-versa. Both the users have default customer profile. This should not happen as one user should not see the data (records) of other user. I am not sure why this is happening. Anyone please help ? Thanks, Milind
One app two CRM accounts
Hi, is there a way I can share an app from my account (A) to two users that are in two different accounts (B and C) and the app access the users corresponding CRM (A, B and C) ??
Newbie Question
I am looking to see if I can use Zoho to create an application for a mobile device where I can have a set of icons on the screen and pressing an icon or a combination of icons automatically updates a record or number of records depending on the combination of icons pressed Thanks Mark
How to show an activated checkbox in an order listing to indicate that the "notes" field contains additional info
I have set up an orders application in Zoho Creator which includes a “notes” field for additional info. On the order listings form, I want an activated checkbox to show up indicating that the “notes” field contains additional info (if the "notes" field is empty, the checkbox is non-activated). On the orders entry form, I need to include a checkbox, which, when activated, shows the activated checkbox on the order listings form. Any help would be very much appreciated.
How to create a daily attendance sheet that automatically populates
Hello. I have this screen shot from an application from the Marketplace, but I can't find the app anymore. I would like to create something very similar to this in my app. After selecting an Instructor, the Enrolled Students section is displayed & populated. Does anyone know how I would achieve this format in a form?
How to unhide fields that have been hidden on load, when i choose an item from a visible dropdown? Then unhide another dropfield or fields on select from this now visible dropdown and so on???
Hide many fields with hide on load. Now when i make a selection on "Product types" want to unhide some hidden field / fields. Getting errors.. not sure about the script needed
creator customer portal permissions
I see in the user permissions for a zoho creator app that i can define field based permissions. I do not see a way to do that with the customer portal. How would I do this?
Display school result system
I want to create a school result system in zoho form, when user enter their roll no they go their result page
customer portal profile fields
I am working on a solution in zoho which is centered around the customer portal. The firs thing I need to do is have some additional customer profile fields. How do I add fields like mailing address, phone number, billing address etc.. to the profile fields? Currently it just asks for email and password.
Form cannot submit
Hi, I created a form and tried to submit it. It just hangs. Could anyone help? https://app.zohocreator.com/zoho_zoho812/hbhd2016/#Form:Pendaftaran
how to send email from custom email address?
hi! there is email of application admin - "app-admin@email.com" and custom email - "custom-email@mail-xyz.com" how to make sending using internal "sendmail" of zoho creator so that 1) from address will be "custom-email@mail-xyz.com" 2) emails from zoho creator's email service will be not in spam because of SPF and DKIM settings of mail-xyz.com email service
Next Page