Subform
Good afternoon, I am trying to get the list of e-mail addresses from a subform Contact. Form : g_commande (= means order) Lookup field : Fournisseur (= means Supplier) Subform : Contact I submit the g_commande form for each new order. In this form, I have a lookup field to get the supplier name from a list. In the Suppliers form, I have a subform with all the contacts of the suppliers. When I submit the order, it must get all the e-mail of the suppliers that have the checkbox checked. I am doing
The Lookup Field in Form is not there anymore
Hi, The Lookup Field in Form Builder is not there anymore, Can't create a join table... Thanks, Martin
Need help creating a quote form
I need to be able to look up a price based on the breed of dog and the service level(bath or groom). Ideally I would like to be able to select the breed from the dropdown, then select either bath or groom and the price would then populate. I have tried this several different ways. I created a table where the record name is "breed - service) and includes a price field. Created another table of just breeds and another of service levels. I then created a form that has a Breed lookup and a Service lookup,
Change language
Hello, I'm with C5. Before my creator GUI was in english. Now in C5, it is in french. I guess it has automatically detect my region and adjusted to it. I want to change to english.
Fields on CRM Integration
Hello, I'm trying to make a new form that integrates with my zoho crm (Potentials module) but i only get on creater a few fields from it, like potential name, stage, amount etc. How can i get all the fields? including the ones that i've created on my CRM? Thanks
Scatter chart rearranging
Hello, I have created a scatter chart with values on x-axis 70,80,90,100 which zoho creator automatically arranges in different order - 100, 70, 80, 90. Is there a way to rearrange it correctly and if not how should I adjust my data? I'm sure 99 instead of 100 would work for example but it is imperative that the last value reads "100". Thank you
ZC5 Functions Search
Hey Creator Team, The new search functionality in the functions view is really great only if it is working!
Form Data as Annual Calendar
I have a Multi_Select Field "Holidays" and I'm trying to find a way to present all the checked (true) items as a Year Calendar with the all the picked holidays probably as a filled cell on a grid. Any ideas how to accomplish this?
FreeFlow mode and change language with the new Creator 5 ?
Hi folks , first i've take a look to the new C5 but I would like to switch back what i've done but the problem now i got this message "Actions modified with the new builder cannot be edited here." btw i dind't any modifications. And did they have the freeflow mode in the new C5 because i'm a bit confuse how to use the new one and i have an app to finish soon.
How to get All field of user inputs of Zoho Creator App in Capital letters?
Hi All, I can get particular file input as capital using below script. (For example to get a Customer Name in Capital) mName=input.Customer_Name.toUpperCase(); if(mName != input.Customer_Name) { input.Customer_Name=mName; } I would like to know how to get all fields in Capital letters during user inputs & update ? Anybody tried common function that we can use in across all forms and pages of an Zoho creater app? Regards, Easwaran
Dates in panels in Creator 5
Panels don't allow fetching of date fields. Would like to show maximum and minimum dates.
Form Fields that dynamically change based on an input
I've a quality control form but depending on what product is selected the parameters to be entered change. e.g. If it's a screw it may be "Weight" and "Shiny Yes / No" but if its a bolt it may be "length" and "Number of imperfections". The parameters to be measured for each item are pre-known but may be of different types (number, select etc.) What's the best way to impliment this in Zoho Creator? I could just do many forms one for each item but that seems not elegant. Ideally I want one place
Is there a way to construct a file the user can download?
I have a fairly simple app I'd like to use with Zoho Creator if possible. Imagine you are putting names on the back of uniforms for a sports team. The names will all be in vinyl which is cut from a machine that can derive cut lines from a pretty simple SVG file. Creating a form to capture the list of names is easy and I know what the SVG syntax is to produce the file. What I can't figure out is 1) how do I create a file with a .SVG extension on it; and 2) how do I give the user an option to download
Report Criteria Uses Functions
Hello, It seems that filtering reports using a function in the filtering criteria returns back to work. I remember that this feature was discontinued but now, I see that it is again support. Are you intending to continue supporting this feature or shall we find other way to do the trick?
Printing / PDFing a Notes Field
Hi folks, I'm recreating a simple signed client agreement within our app. I was hoping to pull in the client details, use the notes field type for the agreement text, and then use a signature box. The client needs a copy of the signed agreement, so a PDF of that record in the report seemed the way to go. However - the notes field isn't stored in the report, so it doesn't display in the record summary. Has anyone done this before? There must be a way of templating this so that we can PDF a copy of
Attachments not added to scheduled reports
Hi - we have a number of reports that are sent automatically as attachments to emails using Workflow>Schedules. They have worked fine for a long time but now the emails go out without the report being attached. The reports are attached when we do an "execute now" command, but not under the scheduled system. Any thoughts on how to correct this? Thanks.
How to fetch data from other application?
How can i fetch data from other Zoho Creator's application(same account) ?
Image in report in C5
Hi, With the C5 update, I want to use the report type where there is an image for each record. The image is not displayed on the web app but it is displayed on the mobile app. Thanks
Share appilcation
1. If i share my application with a user who has not zoho creator account can he access the application? 2. By deafult can a user add/delete/modify application?
Formula field doesn't work anymore
When I change the expression in a Formula field, the value in Report doesn't update to the new value. Even if I delete the expression, it still shows an old value. Thanks, Martin
How to add commas to number
I want to know how to add commas to numbers. For example, when the number is “12345”, I am displayed as “12,345”.
Auto Select/Fill an Entry the Look-Up Field
I've been playing around with the CRM Template and I created a Stateless Template to allow customers to sign up online. I've run in to an issue of the forms being submitted and the lead owner field being empty. I want to have the Look Up Field auto Populate with the "WEB" Username Load, Validate or Click... pretty much at any part. (Screen Cap) Any help would be appreciated. SC
Sharing Solution Information
We have a need to email/share our solutions module (internal FAQs) externally. We want to build a simple creator app that allows us to choose our solution and input an email address to send all defined information within the Solution. I am VERY new to DELUGE. I am able to create my form and have it send me an email upon success with the solution name that the user chose (CRM variable in the form). I need a line of code to be able to put other date within the Solution record and not just the name.
Deluge Sequence
I just encountered something that baffles me trying to use Alerts to inspect the values of variables. The order of my Alerts appear exactly in reverse order. Does anyone know why this would be? To verify, I created a simple one-button stateless form and added this code to the button click: alert "this should happen first"; x = 1; for each myRec in Customers[ID > 0] { alert x; x = x + 1; } With 3 records in my Customers form, the first Alert said "3", the second Alert said "2", the third Alert said
Problem in Importing Data
Hi. When importing data from CSV sheet, after finishing the import I found my Date Time value is blank This is my application link - https://creator.zoho.com/appbuilder/zoho_dov16/a-kaioum/form/Seller_Cloud_VC
Create application to display description field for a CRM account record on lookup via a search box
I want to have a search box where my team and I can enter an account number and then if that account number exists, the app will display the description field contents for that particular account. Any ideas?
How to get logged user role in using deluge scripts.?
hi, i am creating application in zoho creator . In this i have created different roles(admin/manager/employee) and assigned to users . i want to logged used role (admin/manager/employee) using deluge script . to show logged user role on dashboard. waiting for your quick reply. Thanks Suresh Kareti
how to get values in multi select lookup field for each selected record?
row.Mat_Purchase_Req is the multi select lookup field, for each rec in row.Mat_Purchase_Req { if(row.Mat_Purchase_Req.size() = 1) { i = Material_Purchase_Requisition[ID == rec].Items_Required_for_Purchase1.ID; i0 = Mat_Pur_Req_item_lookup[ID == i].Request_Qty_for_P_O; } if(row.Mat_Purchase_Req.size() = 2) { i1 = Material_Purchase_Requisition[ID == rec ].Items_Required_for_Purchase1.ID; i11 = Mat_Pur_Req_item_lookup[ID == i1].Request_Qty_for_P_O; } if(row.Mat_Purchase_Req.size() = 3) { i2 = Material_Purchase_Requisition[ID
Getting Form Fields in HTML
Hi everyone, Any help with this would be much appreciated. For my new page, i decided not to embed an iframe with a report, but to use HTML to get a nicer look and feel. The issue that I am having its writing a script to generate these records and then splitting form fields. I have attached an image of my current iframe and then the HTML that I would like to have. Any help would be much appreciated. Cheers, David
Deluge multiple option if Field change
Need assistance. Need deluge when in a form, if field "A" is updated, on "success" change muliple field "B" from option "1" (by default) to field option "2" Thanks
Autocreate records in a form based on records entered in a different form
Hello, I currently have a form that captures attendance information based on user data entry. However, the data format for that record (record A) needs to be transformed for it to be used in a report, so I need to autocreate a series of records based on the information in record A. For example: 1. Record A has the following fields: - Date (3/25/18) - Event type (Event A) - # of Adults (50) - # of children (10) I need to make a separate record for each permutation of event
How to create an internal use CRM data lookup application
I am trying to create an application which I and my team can access, put in an account number into a field and it will (if the account number exists) display the description field contents of that account. It seemed straight forward when the idea came to me, but it's proving difficult for me to execute. Has anyone done anything similar or have ideas how I could?
Multi-Language Apps
Hello, How can I detect the current user selected language in deluge?
Getting error in function
Hi, When I am going to execute a function it shows me this error - Limit Error Number of statement execution limit exceed Line:(3) Why am I getting this? This is application link - https://app.zohocreator.com/zoho_dov16/a-kaioum/
How to count the number of times a name has been selected in a field ?
Hi, Hope someone can help me out in Zoho Creator. I have a simple Invitation_Form with a Name Field as drop down that refers to another Name Field in Names_Form. The question is : How can I generate a List with the total of times people came to my events. (The events are all generated into the same report...) Thank you for your help !! Arnaud
How can i add criteria in a report?
I got this line in the following documentation Link - "For example, you can make sure that certain reports can be accessed only by the admin user (application owner) by adding the following criteria to your report: show all rows from <form_name> [<email_field_name>l == zoho.adminuserid]" How can I add criteria in a report, by specifying who can see this report?
How getFieldValue() work?
I want to know how getFieldValue() work. I did not find any example in the documentation. Can someone please explain it to me?
Deluge Add Record Script Not Triggering Zapier
When I add a record to a form using the deluge add record script, I receive no trigger action in Zapier, even though the new record is successfully being added to the correct form. I know that form data can be emailed to a form, and from what I have read, this will cause Zapier to trigger, but I have been unable to setup automated emailing at this time. Is this a bug in Creator or a bug in Zapier? Are there any other workarounds available? Thanks for any input!!!!
Date Only on Formula Field
I have a form with a date field, not a date-time field, and a formula field that references that date field. The formula uses date_field.addDay(7) to add 7 days to it. That formula works, however it is formatted as a date-time filed in reports. I need the field to only show the date in reports, without the time. The 00:00:00 time stamp is not only unnecessary, but it takes up too much space on the report and is inconsistent with the rest of the date only fields in the report.
Publishing for an Intranet
Hi, I'm reviewing the use of Zoho Creator for my organisation. I only have the trial version so can't play with publishing at the moment but can anyone help answer the following .... Is it possible to publish a report in a way that it's available to our intranet site (Google Sites) but not fully public - ie outside the company. I don't want to create a user account in Zoho for every employee as the cost would be too high. Is there a google site add-on that I provide some credentials to login to Zoho.
Next Page