Possible to submit partial data if form is closed?
Hi all, Does anyone know if you can 'force submit' the data entered into a form if the user closes the url part way through filling in the form instead of clicking the submit button. This partial data that they've entered (and the point at which they dropped out) is really important for me to know about for my project. Thanks! Lindsay
Count number of of comma separate values
Hi all, I'm wondering if there's a way of counting the number of comma separated values in a field? My report looks like this. I would like to count the number of 'participation dates' for each person and keep a running total in the 'Number of attendances field'. The 'participation date' is a bidirectional lookup field whereby when a person is selected from a lookup in the 'participation form', the date that they participated is shown here. So Bill Smith = 0 John Day = 4 etc. Is this possible?
Hiding Fields depending on the input of a lookup field
I am trying to hide or show two fields in a form called PPE _Distribution. I have hidden the two fields on load and that works but then I want theform to show Select_Employee field when the Select_Location field is "Employee" and to show Select_Job_Number when the "Select_Location" field is Job Numbers. The Location field is a lookup field (drop down) from the form Location and that field is called Stock_Location. I am pretty new to coding and deluge script. I have tried several examples from
Using a Barcode in a order form
Hi I have a form where customers can select which product they want to buy. There are 4 different products and for each a dropdown where can select 0 to 20 as quantity. I want to be able to generate an unique barcode for each product. For example: item1barcode1 item1barcode2 item2barcode1 item2barcode2 .... So each time a customer buys products the barcode should be unique (sort of increment) Is this possibe and how? Kind regards
Popup Area Calculator
Hi All, my first post here, relatively new to Creator. I would like to create a popup calculator to help calculate the area of a given space. Ideally, the popup will have inputs for width and length, and then will return the area back to the form in the required field. I have played a little with this, and my questions is what is the best way to do this, or is there already a widget like this floating around? I have tried creating another form, with width and length fields, and a calculation field,
Import records from CSV with lookup fields
Hi, I want to import a list of Customers from CSV file. The problem is, Customer has a lookup field to Salesperson. Therefore, before the import, I manually modified the CSV file to include a column to reference the Zoho ID of the specific Salesperson I want each Customer to be associated with. I map the Sales column property during the import process but the import failed. See screenshot. So, what's the proper way to import records with lookup fields to other forms?
Creator 5 - Error Reports and Many Bug, unfinished product
Have you guys never heard of Beta stages? There are so many things lacking in the new creator and it is so buggy it is unbelievable. Don't get me wrong, I am really looking forward to the final product but trust me guys, you're not there yet. Trust me, If I was just starting a trial of your product I would have walked away by now to try something else. Here some of what I have noticed so far: First, Support Live Chat is not working at all, I presumed you've just turned it off as there must be many
Zoho Creator Image API Access
Hi all, how can i access images from Zoho Creator with an API Login? Do i need to setup a proxy that login and get some cookies until i can grab the Image or do i miss something? best, Daniel
error message in Zoho creator from a link to form on our google site
The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. The link to the form is on a google site. The error happens from time to time and is inconsistent in the circumstances. I will get one or two calls and then nothing and then a couple of months will go by and it will happen again. It is usually accessing using a phone (android and iphone). Can't pinpoint the issue.
Create a field to track time
Hey, Seems like this should be easy but can't get my mind wrapped around it. I want to create a field that tracks how long my workout took (actually, its how long until I couldn't go anymore, the Max Out Time if any of you are familiar with Insanity Max 30). I want a time field so that I can eventually do some reporting to see how much I've improved, time-wise, in my workouts. Yet, I can't seem to figure out how to properly build a field that can track time... or if it's just a number or single
Reading subforms values related to specific record from another form
Hi all, I have the form A which has a key field "K" and also there's a subform "A.1" In a different form "B" I need: 1. Select the field K 2. Based on the selected record by the field K, allows me to select in a subform, records from "A.1" subform from A. This applied should be. Job candidates are entered on Candidates Form "A" when they register into a job search process. They have an unique name (K key field) and also there's a subform for Job references (A.1) In form "Reference validation" "B"
Embedded form doesn't work in internet explorer
Embedded form doesn't work in internet explorer 11. It just keeps loading. Here is my site https://www.mello.com.na/request-a-quote Thanks in advance.
Form Design and number of columns
I need to have 4 fields horizontally across the page. It seems Creator will only handle 3. Is there any workaround for this? I also noticed that when using the Integration field that there is alot of extra space after that field. I have attached 2 images. One is the Form Builder and the other is the live app page. Any tricks would be helpful to correct this issue.
Reports stopped exporting in landscape
Hi - My scheduled reports recently started exporting in .pdf portrait instead of landscape. Is there a setting I need to adjust to get them to export in landscape again? Thanks.
custom look and feel?
On the Zoho Creator website. They have a section that shows someone using Zoho creator to customize how the fields are displayed on the Zoho creator mobile App?? Is this actually possible, I can't find it. Also for the website, can you only select themes? nothing else?
Incomplete expression Else If
I'm stumbled. Please help ! Why "Error at line number: 12 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" (Line 12 is at the Else If) { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Confirmed" message:"Your message" content type:HTML ] else if(input.Assessment_Status="Not Successful") { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Not Successful" message:"Your message" content type:HTML ]
TLS v1.2 upgrade
Hello everyone, We(Zoho Creator) want to let you know that we are upgrading our TLS standards to the latest version 1.2 which is more secure and meets the updated PCI standards. We will be retiring the support for TLS versions 1.0 and 1.1 on 31 August 2018. After this date, all our users will be required to update their processing solutions to TLS v1.2 for the secure transfer of data with us. What is TLS? Transport Layer Security (TLS), formerly Secure Sockets Layer (SSL), is the old security
Number field + stepper
Hi, any chance to have a Number field with stepper? Example: Number field, default is 100 and I would need to add or remove step 1 by using (+) or (-) "buttons". Ja
Stateless form
Hi, how to create stateless forms and how to customize the button in creator5.
SubForm field updating form field record and Auto Number
In the below Workflow, identifying re update the filed is not working well for each row in SubForm info "Add Stock in Inventory" + row.Part_Name; rec = Add_Item[ID == row.Part_Name]; rec.Stocks_in_Inventory=rec.Stocks_in_Inventory + row.Number_of_Items; } I want to use Auto numewber to fill the Form Field but it is getting generated only on submission. I want to add Text + Auto number for some filed. What is the option
Zoho Creator - Dynamic Lookups
HI There, I have read multiple threads around using sub forms and looking up certain data in the sub form but I'm struggling to get anything to work. My problem is as follows: I have a main form called Service_Request and in this form I have a filed called "Account1" and a sub form called "Service_Address". The "Service_Address" subform pulls through several fields from the "Service_Address form including the fields, Site, Building_Name/Number, Address_Line2, County, Post_code. I also have a field
portal do cliente
pessoal, tenho uma aplicação no zoho creator, construída antes do creator 5. ontem instalei uma nova aplicação, sendo que utilizei um modelo. na primeira aplicação (antes do creator 5) não aparece uma tela relacionada ao portal de cliente, inclusive ela remete para a versão anterior. na segunda aplicação (após o creator 5) aparece uma tela relacionada ao portal do cliente. Isso tem prejudicado meu pojeto, porque não consigo vincular ao meu domínio.
Detail View of Report on Zoho Creator 5 not showing 3rd level subform data
Hi all, So I want to show on a detail view of a report data of a subform which belongs to a form that's a subform on the form in which de report is based on. Form 1 (Report based on this one) Form 2 (Subform on Form 1) Form 3 (Subform on Form 2, this one has the fields I want to show on the Detail View of the report) The thing is that I select the 3 fields of the subform that I want to show, delimited by a space, but when I go to the report, the fields that I selected are ignored and it shows me
Zoho Creator - Salesperson Login
Would Zoho Creator allow each salesperson to login through a portal and enter their own sales order and not be able to view other salesperson orders? Thanks
Events in mobile's own calendar
Hello, Is there a way to send events to my customer portal users to their cellphone calendars? For example, when you have a flight to take, you recieve an email with the date and time and then it automatically appears in the cellphone's own calendar, (not Zoho calendar) I would like to send events and post them in the user's cellphone calendar, (not Zoho calendar), through my app which runs under the customer portal
Point of sale
Hello, I have tried to put this point of sale for one of my clients, integrating the entire zoho one suite, but the point of sale fails and fails and fails again, we have made it from scratch three times, and in the end it fails, I can recommend a point of sale that is from another brand, but that is integrated with Zoho inventory, because we can no longer waste time with this app my case is 1093529
POST request to attach file
Calling on ZOHO Creator gurus! Can anyone tell me if it's possible to post file attachment using Deluge? I'm developing app that works with ZOHO Books sales orders module. When client 'accepts' quote, application generates PDF file and attaches it back to a Sales Order record in ZOHO Books using API: https://www.zoho.com/books/api/v3/#Sales-Order_Add_attachment_to_a_sales_order
customer portal - different permissions for different users
hi in customer portal there is same permission level for all users how can i make different permissions for different users? oк make to see different sets of views and forms for different group of users? group1 - set1 (view 1,2,3, form 1,2,3) group2 - set2 (view 4,5,6, form 4,5,6) "You can share select components of an application (forms or views) or the entire application with the members of your portal. All your users will have the same level of access privilege. Access privileges can be revoked
Ask the Experts 3: Live Q&A: Find out all about sharing your Zoho Creator application with other users.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be shared with other users — be it people within your organization or even outside. As an admin of the app, you can share the entire application or specific components of the application with your users. You can add users and permit them to access, edit, and modify relevant data and app components. In this month's Ask the Experts session, we would like to address all your questions related to sharing your
Calculation errors in formula to compute age
I'm using the suggested formula to compute Age from DOB, but random errors are occurring in a View. Manual update of DOB fixes individual Age fields. Given that a formula should be updated when a dependent field value changes, Using 'zoho.currentdate ' - since it changes daily - would be thought to cause recalculation. Do I need to perform some process to force all records to recalulate (for instance, sort on Age)
Report-Pivot-Chart - View underlying data
HI, when the "View underlying data" is flagged a view related to the specific graph element is opened. This is a very cool function. Is there a way to select what columns let to show and what column hide? tks, Pippo
Zoho creator with payments integration
Dear all, We need to create a form with payment option which payment option is best for us. Can you please help me to integrate based on that payment gateway we didn't have any account like paypal account etc..
Access control issue with links on lookup fields
Hi Everyone, If you follow few basic steps below you will find security issue I am really concerned about. 1. Create Form1 2. Create Form2 3. Link Form2 in Form1 with lookup field 4. In Detail View > Layout for the Form1 Report enable lookup field to link to Form2 data with URL 3. Restrict User1 with permissions set to access Form1 (do not allow to access or see Form2 at all, untick all boxes for this form in permissions set) 4. Login with User1 and click on link in Form1 which links to lookup record
Expression Error
Hi, I have a Form by name Document_Library which has following fields. 1. Document Type 2. Document Reference Number 3. Cargo Arrival Date Field 1 and 2 is updated much before the Cargo Arrival date. To update Cargo Arrival date, the user has to search by Document Reference Number. For this I have created a stateless form which has got Document Reference number as a lookup field. x = Document_Library[ID == input.Document_Library]; openUrl("#Form:Document_Library?ID=" + x.ID,"same window"); On clicking
Import lookup field
Hello Is it possible to import data with a lookup field ? If yes, what do I have to import (id of field, unique value of field) ? Thanks for your help Regards
PHOTO ATTACHMENT FORCES ZOHO LOGIN REDIRECT
Hello I am still using Zoho C4. When a user submits a form-mobile with photo attached it forces the zoho login page. Not sure what is happening. This was always a problem in the past, but now it is starting to occur for a large set of my users. Before we thought it was the image sizes being too big, but we had our limit increased and it stopped happening.
How to Change Report Options
So I have two questions that I am unable to locate answers too in the help area. 1) In a report, the search drop-down shows fields I do not want people to be able to search by. How do I change what fields can and can not be searched by in the report? for example, I have some image fields and I do not want people to be able to search by those fields in the report. 2) Along those same lines there is the more options function in my report that i would like to get rid of completly, unfortunity the only
Use data from ZOHO CRM
Hi all, is it possible to use (read only) datas from the CRM in the ZOHO Creator? We need customer informations like address and ordered products. Thx for help!
Print multiple sub form items in Record Summary - Separate Rows
I need help with printing multiple rows of orders that are submitted into a subform in the main form report record summary. At present, the record summary will combine multiple row items into a single cell. How do I get multiple rows to print? The items are separated by a comma, but I cannot figure out how to get to print on multiple rows individually. Please help!
output window is not displayed in learn deluge
when i try to execute the script .i cannot find a console to show the output
Next Page