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
Bug when importing a Deluge script file
Hi, I've found what appears to be a bug where a particular part of a form is lost when exported and then re-imported. Here's the issue: When using a lookup field, and checking the "Show a link to add new entries" box, the exported .ds file will contain this: allow new entries = true [ displayname = "Add Example Data" ] But when re-importing this file, those four lines are missing. This means that there will not be a link to add new entries in the lookup. Is this a known bug with Deluge script import?
Updating script. . . never ends
What does this mean when trying to update a script? Specifically, I am updating a form script on edit / on success. When I try and navigate away from the screen it warns that I will lose changes and indeed they are lost. I am trying to isolate the offending line, but it is difficult because of dependencies between different lines re. referenced variables. Regards . . .
Font color is wrong.
When I try to set red color by editor to the text in rich text field - I see dark green :) second (red) line was added by inserting HTML. If we look inside we will see: <font color="rgb(255, 0, 0)"><b>should be red</b></font> - by editor<br> <b><font color="#ff0000">should be red</font></b> - by inserting HTML Could you please repair it?
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!
RegEx trouble
I copy&paste texts into ArticleText field (rich text) from word documents. Due to text is always long, I create for a ArticleText View - ArticlePreview formula field, which should keep first 100 symbols of ArticleText field. Formula calls function getPreviewText(ArticleText, 100) Due to value of ArticleText is not a clean text, but html formated text, so I need to clean it from tags by string getPreviewText(string srcText, int len) { str = "<(.|\n)*?>"; input.srcText = (input.srcText).replaceAll(str,"");
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.)?
Best Way to Invite Many Users to an App?
A related topic https://help.zoho.com/portal/en/community/topic/register-without-email is under review (account provisioning). However, I'd like to know what others have done to get a large number of people signed-up with Zoho Accounts. Cheers, John Whitney
Send e-mail based on StartDate Field
Hi, I would like to send an e-mail notification containing Form data related to Startdate. For example, I would like to send e-mail listing all records that have a startdate of 3/18/2013. All records occurring based on the StartDate filed.. -----Email------ StartDate Unit Assinged 3/18/2013 231 Megatron 3/18/2013 605 Optimus Thank you very much
Strange Error Message
Attempting to identify what code would be impacted by changing a field-type, I got this. Cheers, John Whitney
Unable to Fetch data from form
any idea? We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
Creating a Form which can call data from another form
Hi, I have created a database which is essentially, like an excel spreadsheet, with columns defining variables, and rows of data. I was wondering if it were possible to create a stateless form, which when a user selects a certain record e.g. title, the form then calls data from that record for certain fields. To explain further, incase I am not doing it well. I want a user to be able to go onto the form, select a title, from a dropdown box (the titles are stored on the database), and then when they
Is there a way to add a custom action to the predefined all contacts view???
Hello, I need to synchronize data selected by the user (single or multiple) in the contacts view to my database using a web service. So i need to add a custom action or a button if possible.Is it possible to add a custom action to a predefined view(e.g. Contacts view) ??? If not please suggest me some workaround for it... Thanks
Next Page