Send an email with all data from a subform
Using the following code, I have been able to include information from a subform into an on success email. " + input.SubForm1.Single_Line1 + " However, it is only displaying the first value of the field. I have tried to fetch the data using the following code with different iterations x = form1 [ID == input.Single_Line1] but I am always getting an error. Is there any way I can display on an email all the records stored in the subform for a particular field? Thanks.
Invalid JSON String Format
Hello, We are trying to fill-in the pincode of a customer through an API call. The API returns the values in JSON format such as: {"query":"Delhi","pincode":"110001"} If the pincode cannot be found, the API returns with the values such as: {"query":"Searched Address","pincode":"","error":"Not found"} We get a "Invalid JSON string format" error when address fields are left blank on add customer record form. The code we are using to make the API calls is: if (input.Address_Line1 != null || input.Address_Line2
Posting form data to another url and and opening page in the new url
Hi, I am quite confused with the process of postUrl. On submit I need to post form data to an external url which will auto populate matching form fields and trigger an event (submit Form). All this must happen in the same window. Please inform where I am going wrong. input.adult_no2 = postUrl("http://demo..co.uk/searchhotel",input.adult_no2);
how to set admin permissions to notes?
hi! need document all fields by notes there are more than 50 fields how can i set for notes view permissions "Admin only"?
Add product detail in PurchaseOrders of CRM
Hello, i user ZCREATOR to create PurchaseOrders in ZCRM. I put only Product in a List as itemsList = List:Map(); ..... For each ligne in MyView..... { itemsList.add({ "Product Id" : ligne.ID_produit_ZCRM, "Unit Price" : MonProduit.get("Unit Price"), "Quantity" : newQty, "Total" : newTotal, "List Price" : ligne.Prix_achat, "Net Total" : newTotal }); } My ItemsList is full with product. responseCreate = zoho.crm.create("PurchaseOrders",{ "VENDORID" : idFournisseur, "Subject" : Subject, "PO Number"
can't able to imort app?
When i just trying to import app as a .ds extension it shows me Invalid Request
Lookup Multi-Select
Hi, I am building an attendance app. I created a lookup multi-select field. When I select the attendees, I want to put a 1 to their individual names to indicate their attendance for the event. How can I "remove" the commas in my report and show their names individually?
Dropdown field is showing "Other" option
We have a Creator application where we are tracking Customer's visit activity. Currently the Activity dropdown field has 4 options: Buy - Yes Buy - No Decision Pending Return/Exchange When adding a record, we get the desired 4 options. However, on the edit screen, Creator shows an additional option - "Other" as shown in the image. We suspect it has something to do with the On Load screen of that form but can't really figure out whats the issue. Any help would be appreciated. Thanks!
No CA certificate imports for private HTTPS
No where in the Deluge reference documentation can you find mention of certificates for transport layer security (TLS). Apparently this is because there is no getUrl() support for importing a CA certificate which means that you may only use an https:// scheme with an HTTPS server which has paid a yearly subscription for a certificate from a CA recognized by Zoho.
getUrl() does not support ports other than 80
The Deluge reference page for getUrl() says: "By default, it supports websites running in port 80 and 443." I was dumbfounded when told by Zoho support that it ONLY supports these ports! Apparently the standard URL format of http://host:port/path is not supported at all. It uses port 80 for the http:// scheme and port 443 for the https:// scheme and does NOT do the right thing to allow us to specify the actual port the HTTP server is running on. This obvious shortcoming rules out using Creator
How to "Add Comment" to a Case in zoho CRM
I'm trying to "Add a Comment" to a case in the CRM via a Stateless Form. The code below "should" work but does not. The caseResp says "Successfully Updated Record". Am I missing something? caseMap = map(); caseMap.put("Add Comment", "test"); caseResp = zoho.crm.updateRecord("Cases", "841019000007280001", caseMap); alert (caseResp) ;
How to download record summary pdf when a new entry is added?
Hello, I want to download the pdf of a record summary PDF when I make a new entry in the form I have tried this On Add / On success openUrl("https://creatorexport.zoho.com/danielmndez2/recibos/record-pdf/Recibo_Report/<ID>/<contratista>/(Report Secret KEY)?<ID>=" + ID + "&<contratista>=" + Contratista,"New window"); The problem is that the resultant URL is the next one https://creatorexport.zoho.com/danielmndez2/recibos/record-pdf/Recibo_Report/input.ID/input.Contratista/Report Secret KEY)?input.ID=3112670000000106103&input.Contratista=3112670000000078982
lost field in report!
hi! previously was made a report all works well few days ago lost 1 field "дата доставки" in field it is, but in report there it is not how to solve it?
Help with CRM integration
Hi, i just started using zoho creator because i need to creat a new application for insurance policies. The objective is that using Zoho CRM when i see a contact information to be able to see the insurance policies he has with the pdf and the image of the car or house insured. I created the aplication using Zoho Creator in wich yo can add the following information: 1.- Image (upload image flied) 2.- Document (upload pdf field) 3.- Policy number 4.- Premium 5.- Related to: (contact in Zoho CRM) After
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
Next Page