Multiple Select field very slow/not responsive
I have a form that has 2 multiple select fields, one for COUNTRY and the other for POSTCODE/STATE. The POSTCODE/STATE is dependant on the COUNTRY field. When I select the COUNTRY option that contains a lot of data, the POSTCODE/STATE field takes too long to populate. I end up closing it after waiting for several minutes with no response. Can you please resolve? One workaround I have found was to fill in the form with an incorrect COUNTRY and POSTCODE/STATE before selecting the correct COUNTRY and
How to create a Single Line Field with only one acceptable answer (as alternate to picture verification code)?
Greetings, We have had some of our customers complain about how it is very difficult to read the verification code from Zoho, and that it doesn't work on Apple Safari web-browser (both Windows and Mac versions). As an alternative to the verification code, I would like to implement a Single Line Field that is presented in the form of a question with only one acceptable answer; for example, "What is the ZIP code of Company Co.?" with an answer of "123456", or "What phone number should you dial for
Multiple select removing values not displayed correctly
Hi, I have a form with a multiple select list. When I view the form, I can easily add and remove values. See below. However, the customer cannot see the red "X" when they view the form. See below We are both using Chrome. Do you know why there are inconsistencies with the way it is displayed?
Forms - import forms from an old account
I started a few weeks ago in Zoho and I originally set up a number of forms. Our business looks to be changing name as so I need to get the form onto the new account, as I cannot use the user name. This is because when we link the forms, they have our old business name, and for legal reasons it looks like I need to change this. So I have registered a new account, but I need to import somehow the forms from the old account. I also need to transfer the plan. Can anyone help me??? Thank you
'If..else if' conditions
I'm stuck on the 'if...else if' condition. Let's say that i have a list of sectors and different lists of subsectors, each one exclusively reffered to one of the sectors from the first list. Let's say that i have a table of all the clients that i'm working for. I'd like, for each client, to specify the sector they belong to: here it's easy with the dropdown menu for example. Then, i'd like that, once i choose one sector, in the subsector column only the proper subsectors list will appear.
Has anyone used Filepicker.io to enable image upload with Creator on an iPad ?
The filepicker.io code (see the filepicker.io website) seems to enable iPad and iPhone users to upload images, but I am not technical enough to make it work with Zoho Creator. Has anybody else managed to use this successfully ?
Research and Development Survey
Hi everyone, Just started on Zoho... we are about to do a market survey for a client and noticed Zoho does "surveys". I can see we could build the form but is it possible for this more complex survey (40 questions 4-5 response options) how and where would it store the data and how would we get to it to do the analysis. Has anyone done this, does anyone know. Any experience know how gratefully recieved. BR Simon
Problem displaying images on html view
Dears, I want to display images and text on a created html view. All is OK with text fields but with image fields the picture is not displayed. Looking into the code I found the url for the image is https://creator.zoho.com/sharedBy/appLinkName/viewLinkName/fieldName/image/1364058128807_Montoro.jpg What's wrong? Thank you very much in advance.
filter function for reports
Hi, I am having trouble with the "filter function". In one form, I had a check box function titled "Type" and there were two options to check either "regular" or "away". I want to filter and only show the "regular" type but when I put the type in the filter box to generate the report it says it is unknown. How do I use the filter to filter from a checkbox or drop down menu with text in it? Thanks, Rebecca
Form performing slowly
Hi, Users are complaining that when they hit the "Submit" button, they can see the icon that the page is doing something but it never gets saved. One user has complained about waiting hours. Can you please investigate the poor performance?
.replaceAll("\n","<br/>") does not work
To add line breaks or carriage returns to an HTML view of a multi-line field, I tried this solution:<td><%=record.item2_1.replaceAll("\n","<br/>")%></td> but got this error message Error details:Error in executing full_view view script.Error.Error in executing For Each Record task.Error in executing Html Content task.Error evaluating STRING expression :Error evaluating STRING expression :Error evaluating STRING expression :Error evaluating STRING expression : Would really appreciate your help. Many
Insert two or more times the same view embed in a Html view
Hello. I'm making an html view with some views embedded. I want to use the same view with two different filters. For example: <div elName='zc-component' viewLinkName='myView' params='zc_Header=true&zc_SecHeader=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Search=false&zc_Paging=false&zc_RecLimit=false&zc_SumRow=false&zc_ColMenu=false&zc_Summary=false&zc_RecSelect=false&zc_SaveRec=false&Repair=NO'>Loading
Form/Record Duplicate
Hi, Is it possible to duplicate a record in form view upon submit, with all fields the same except one, which can then be modified and saved?
Using the calendar view to show durations
Hello, I'm a new customer of Zoho and I must say - I like it a lot!!! Very powerful application platform. I have a question: I'm developing an app to help me share some tasks with my team. I have records that has the fields: "Task", "Start_Date", "End_Date". Is there a simple way to show a calendar view that will put the "Task" field across all the days between the "Start_Date" until the "End_Date"? For example: If a task called "Test Zoho site" starts on Monday and ends on Thursday, I want it to
Viewing form entries as forms after saving?
I'm having trouble figuring out how to view the data saved in the spreadsheet in the same form structure it was created in? I was hoping there would be a way to switch the view back to the form after saving for printing, emailing or converting to a pdf? I'm also wondering if there is a way to have the form embedded on my website and when filled out a copy of the form is emailed to me? Thanks Phil
Migration Tool Error
I'm trying to upload an MS Access Database to Zoho Creator, and I get the following error: " at line 52, column 28. Was expecting one of: "-" ... <NUMERIC> ... <DECIMAL_LITERAL> ... I've searched the forums for similar issues and the errors that come the closest to this one are related to an ID field that must be manually removed. If that's the problem, how can I find the field that should be deleted? I'm working with a template and I don't know where everything is placed. Thanks!
link to crm
I am new to Zoho does creator have the ability to link with the crm data?
Importing Data and on success scripts
I have a form to submit payments from my clients. When submitting the data , a on success script updates some fields in another form. While importing data from an .xls file, will the above mentioned script work for all the records Will be imported?
Now I have One Column instead of two.
I built my form, the made it a "Stateless" form. Now it is all out of whack and in "One' column. What happened?
How can I prepopulate one form with data that has been previously entered in another form, in another application?
I have seen this https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form from the help center. But apparently it is only used for the same application. Please help thanks.
I would like to create a report that pulls data from two tabs
Hello, I would like to create a report that pulls data from two tabs. Is that possible? More specifically: I have two tabs: Tab 1: Where information on each round of investment in a company is entered Tab 2: Where general information on the type of company is entered I want to be able to sum the data from tab 1 (amounts, etc) but using data from Tab 2 as well. Is it possible to create reports while sorting data from 2 tabs? Thanks!
Edit display of formula results
I have a formula that uses a conditional expression to determine how to divide the numbers in another field. I want the results to display as a percent. How can I control the display of a formula results (e.g. control the decimal places, convert to percentage etc.)?
Download attachments
I've created a form in which appliacnts have to upload some documents - is there a way of downloading all the documents in one go? The export option gives me atable of their details, but not the documents they have uploaded. I can access each document by clicking on the link in the form, but I'd rather download the whole batch.
% of total in report column showing value when data is zero
I have a report in which I am showing a whole lot of specific activity across a large number of items, and I want to show the % of the total for each item based on the total activity for that item as a share of the total for all items. Sometimes this seems to work, but in many cases the specific % is irregular. For instance, if there is no activity value in a particular item (0). It lists this item as .39% of the total. Other times, there is wide disparities in the amount and the % value. For example,
Convert dropdown values into decimal number
Hi I have a dropdown menu with this values: 1 1,5 2 2,5 But I cant work with this values as number I tried with toLong() but it does not work with decimal numbers. Thanks in advance
Auto-compile date-time field when other field's been modified
I have a field where to manually input a number. I need a date/time field to be automatically filled up with current date/time when the above field has been modified. Thank you, Gianluca
System restore has not restored data
Hello, I have done a backup of my application 'KiwiOz Childcare.' I have then completed a Restore and renamed the application kiwioz_restore. However, in the restored application kiwioz_restore, none of the data has restored. I have also backed up and restored my other application (Cafe Nanny). This restore worked and the data was restored. Please advise, thank you (I have allowed edit access to support for both of these applications).
Issue with deluge script executing in a sub-form
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in when editing the
Refresh Fields Within A Form Without Reloading or Submitting the Form
Is there a way to refresh fields within a form without reloading the form? Problem #1: I have a Jobs form. And I have a Contacts form that is linked to a contacts database. Within the Jobs form, there are two places to look-up contacts and add them into the Jobs form. But one of the places also allows adding a new contact. When I add a new contact at this place it does not appear in the look-up list for the other place. I need a field.refresh() option to refresh the look-up so I can see the
allow shared users to have edit or add permission to records
Hello, How do you give edit/add permission to shared users on your application. I would like to be able to allow users to add or edit records on certain form or view. I did not see any functions that allows me to do so. Please advise. Thank you
zCreator Emails are treated as junk by Microsoft Smartscreen Filter
Dear zCreator Team, I would like to bring to your kind attention that zCreator emails are being treated as junk by Microsoft smart screen filters. ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
For Each Records that was update in the last month..
Hey all im trying to run a for each into a HTML table, and although I can get the records based on a field values I also want to query the date modified, how can I ensure that i only get the records that were modified in the last month? Thanks in advance Adrian
First and Last day of the month
Hello, I have a form, where there are two date fields: 1st field) From Date 2nd field) To Date I would like On Loading the form the current values of these fields to be: From Date = The 1st day of the current month To Date = The last day of the current month How I could write this script??
Search Records script
So, I would like to create a simple Search tool on one form, upon user input of a name, records containing that name will be fetched. Problem is, I don't know script. I've tried the fetch on user input etc. but it's just not working out. If it is possible, I would also like those records to be updated automatically (multiple users inputting information- in real time update on all computers) Is any of that possible? and if so, how?
converting a complicated excel formula
Hi I have the following formula in excel which I can't seem to translate to deluge: =IF(AND(B3>2,C3>2),"MANAGE",IF(AND(B3>2,C3<3),"INFORM",IF(AND(B3<3,C3>2),"SATISFY",IF(AND(B3<3,C3<3),"MONITOR")))) I understand the AND needs to be translated to &&, but the multiple 'IF's and comments are the problem. e.g. where B3 is a user input ranked 1 to 5 (drop down list) and C3 is a user input ranked 1 to 5 (drop down list), should this be a comment script or a formula script? thx :)
Make View Filter Searchable
I have several views with an Auto filter. The pick list on the filter is quite large and it is making very cumbersome for the users to scroll down to find the item to filter by. Is there a way to make an auto filter searchable?? Thanks in advance.
Related Tables
In general my question is the following: I am developing a Housing application. I have rooms, occupants, and occupancies. These are the 3 core tables of the application. These tables are related in database terms - in that there are 'foreign keys' in each of the tables. Can this be accomplished using Zoho creator. Thanks Tom Hirsch thirsch
How can I create a hierarchical multi-select or checkbox field?
How can we produce / display a hierachical multi-select field? E.g., "Cars" might look like: Acura - MDX - TL - TSX BMW - 330 - 335 - M3
Problem with a disabled lookup field
Hi All, I have a Form (Master) with 3 fields: Type , Color and Thickness. This Master Form has a SubForm with 2 lookup fields (SubColor and SubThickness) referencing "Products" and another lookup field Sr_Num referencing "SerialNumberHolder". On selecting of 'Type' 1. Filtering the 'Color' Values 2. Filtering the 'Thickness' on user input of 'Color'
Wow, I really need a 12 hour time format!!
Doing an on-line schedule of events with Creator and it works great except that time can only be displayed/chosen in 24 hour format. Which most people don't understand. So I opted for a dropdown list where they could choose the time in "text" (1 am, 2 am, etc.) But that won't sort properly! When you try to sort by time, it lines up all the 1 am events followed by all the 1 pm events, then the 2am events and the 2pm events! Oh no!! Can we please have the time in 12 hour version too? dustylinden
Next Page