Syntax highlighting bug - parentheses
Until a few weeks ago the syntax highlighting feature was working for each set of opening and closing parentheses. I.e. "( ... )", "{ ... }" or "[ ... ]" for closed parentheses and "{" for an opening parenthesis that has not been closed. However, a platform update broke this feature. Can you please reinstate it ASAP as it makes it hard to spot where missing parentheses should be added.
How to disable the export and print features in a VIEW based on the user right ?
Please advise. Thx, Jason
unable to save script in edit view / free-flow script mode
The "updating script" message is displayed but the script is never saved. This applies even if no changes are made to the script. The same applies to all views in my app.
URGENT ... CANT ADD NEW DATA *PLEASE HELP*
Hello, When i start any form and fill it and click on submit this message comes up. "Invalid entries found. Please correct and submit again." and when i go to Error Details i find nothing. Please help. View Error Details Error details: Error occured while on Success script. We are working on giving more meaningful error messages on script failures
Displaying Data on a Form
I have data imported from a spreadsheet that I would like to display at the top of a form. It is to be referenced prior to the person filling out the form. Is there a way for me to import data into the form and then have them add the content and save the form with the data being added to that record??? Example: We are doing a round of phone calls. I would like the caller to be able to reference the person's name and information before making the call. Then when they make the call they will be able
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
Thumbnail without changing proportions
Hi, is there a way to create a thumbnail from an uploaded image in a way that proportions are allways kept as the original picture? following the help topics there is a way to create thumbnails but in these instructions one defines the dimensions of the thumbnail where the original image proportions can be distorted. Rgds Luis
How to direct to a specific page after completing a form.
We are using this as a form to fill out on our site. The form is here: http://fcpresearch.com/JoinOurNationalDatabase.php We would like to redirect to this page when someone submits the form but I cannot find where to make that the setting. http://fcpresearch.com/thank-you.php I changed the URL on the links and images page, but it didn't do what I need. Any help would be soooo appreciated!
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?
Fetching exchange rates on the fly
Hi, Is it possible to get the latest currency exchange rates using Paypal Currency Conversion API from Zoho creator to keep the Exchange rates up to date? Best regards, Nitin
Update a multi-select field via function
Hey, I'm trying to have a value selected in a multiselect lookup field via a function - I'm stuck on getting the 'fetched record' updated because The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Anyone have any idea how to get around this? The help documentation and other forum posts related to this error message are pretty opaque. FYI - All of the values available in the first form's dropdown field are the same as the mulitselect
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 ?
How do I create a change log of the data entered?
I would like to create a log of the changes to the data entered in my application and who made the change. Either I want to show the old and new value or, I want to record the old value when I input a new value. The problem is, that when a record is created, if I try to use the On User Input function, the ID for the record is not known until the form is submitted so the log can not record the initial value along with the ID when the record is created. When I try to use the On Update function, the
Uploaded document link in view mode - want to view, not download
I am experimenting with how Zoho handles uploaded files. In the view mode, the file link is such that the file is sent for download. Example: https://creatorexport.zoho.com/DownloadFile.do?filepath=/1364178129140_100-873-Deed.PDF&sharedBy=bumcgi&appLinkName=document-upload&viewLinkName=sheet_data How can I create a link that will allow my browser to open the document. Specifically, opening in a new tab would be my preference. I have tried different browsers and right-mouse clicks and it always
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
deluge script not working in "on add/success" but working fine in "on add/on load"
Hi, I have a simple record-counter script that works in "on add/on load" but it doesnt work in "on add/on success" this is the script: Variables_de_Sistema = Variables_de_Sistema [ID != 0]; input.Numero = (Variables_de_Sistema.Ordenes_Ultimo + 1); Variables_de_Sistema.Ordenes_Ultimo = (Variables_de_Sistema.Ordenes_Ultimo + 1); the script updates fine the input.Numero field in both cases, no problem there. The problem is that in "on add/on success" the variable "Variables_de_Sistema.Ordenes_Ultimo"
Telephone number error
I have made a simple Contact Us form and no matter how I enter the telephone number it comes up with an error message - Enter a valid number for Telephone Number. Have tried every way I know including putting country code in front of it but still get the message. Suggestions? - jb
Dates and Aggregate Records
A simple task: find the latest entry in a database based on an input date. I have a stateless form with a date field. After entering a date, the aggregate record task would find the latest entry for that date. The issue is that the database uses date-time fields so this fails to work: max_date = Date_Time[Date_Time_1 == input.Date_1].maximum(Date_Time_1); Nor can we do this: max_date = Date_Time[Date_Time_1.toDate() == input.Date_1].maximum(Date_Time_1); Error in statement at line number 1 Either
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?
1)bCRM Free for 3 Users - Right ? 2) Is Creator Data Base free for 3 users as well?
Is Zoho Creator on line data base free for 3-users? We just signed up for we thought was a free account for 3 users for Zoho apps - but now we are wondering if it was only for CRM... Excluding the free trial offers - what is included in the Free Zoho offer? Thanks for any help?
.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
getURL & postURL cannot pass "Authorization" key in header map.
This exception has been thoroughly tested. Problem : The header map variable (passed to getURL & postURL functions) will not permit the inclusion of an "Authorization" key/value pair. DS function to HTTP resource : map test.passingHeader() { url = "http://webpdi.com/info.php"; header = { "Authorization" : "Basic dXNlcm5hbWU6cGFzc3dvcmQ=", "header1" : "passed header1!", "header2" : "passed header2!", "_Authorization" : "So I can
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?
Can I embed a report to Add Notes field?
Hi I don't want to jump to open a html view for display a report, like embed in a picture to Add Notes field , embedded in a report to Add Notes field, I tried the following code, but it can't work： plain ="<iframe height='500px' width='900px' name='zoho-report' frameborder='0' scrolling='auto' src='http://creator.baihui.com/stanleyguo/theone/report-embed/report/'></iframe>" Hope get your help.. by the way the Add Notes field extremely useful. Thanks Stanley Guo
total row data in reports
i cant view the total of rows in zoho creator report. all i can view is the total for the each column. how about the rows? Thanks
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
Slow replies from Zoho support?
Hi, I am getting a bit frustrated with the slow replies from Zoho. I have sent about 20-30 emails to support@zohocreator.com over the last few months. None of them were answered within 7 days and many of them were never answered at all, leaving me to fend for myself. What is Zoho's service SLA? Does anyone else find this or is it just me? Any tips on how to get a swift reply? Usually what I do is create a forum topic (so that other people with the same problem can find the solution) and use the 'email
Form On User Input Not Evaluating
One of my forms stopped working. When adding a new record, everything worked great. But when I edit a record, things stopped working. For example, I've deleted my entire On_Edit->On_Load script but many fields do not appear when the record first loads. Furthermore, when I edit a field, the On_User_Input does nothing while editing a record but it works fine when I'm adding a record. How do I fix this very strange error?
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?
Send an email containing data from three forms
I need help to create an email comprised of data that exists on three different forms, all of which have relationships between them. Specifics: The email address the email is to be sent to is on the DONOR form. The email is triggered to send via a checkbox on the DONOR form. The email needs to include data located on the WISH LIST form. The email needs to include data located on the FAMILY form. Relationships: The DONOR form has a lookup field to associate donors (DONOR form) to families (FAMILY
Are multiple Forms for the same table somehow allowed?
I need to have several different forms available to enter data into the same zoho 'form' or table. The reason is that I want a simple form with only essential fields in one case and a full form in another case with all fields and some for in between. This is for different users of the system. I can hide or show fields conditionally in the 'on load' script based on the zoho.loginuser Just wondering if there is another way such as creating alternate forms for the same table and then changing the
Next Page