error while updating a form in Zoho creator
I have set up a new application by uploading the info from a spreadsheet and entering more fields in form view. Somehow when i update the data it gives me an error message. I have set the new and old fields to accomodate the original settings of the fields given (number / drop down etc java.lang.String cannot be cast to java.lang.Long
Need Help with ZOHO Creator API ...
Hi: I am trying to test the use of the ZOHO Creator API facilities ... using an HTML document resident on my local disk. I have obtained my API Key and Ticket (both of which are replaced in the content below for security reasons) When I try to make a XML RPC View Record request ... as documented here ... http://api.wiki.zoho.com/XML-RPC---View-Record.html ... I get this reponse ... <?xml version="1.0" encoding="UTF-8" ?> - <response> - <errorlist> - <error> <code>2830</code> <message>Content
How does one use scripting to insert html into rich text fields?
I'd like to build html code using scripting, then set a rich text field to accept it (RichTextFieldExample = "<html code>";). However, simply submitting it as above doesn't work. There must be some initial and trailing codes that are expected. What are these? Thanks, - David
Duplication of large, unique and randomly generated number - ideas
In a form I have two types of records: initial and follow-up. I would like to use ID field for records identification and that is perfect for initial records: they are large, unique and randomly generated numbers. My problem ist this: a follow-up record must have the same identification number like the initial record. How can I solve this kind of problem? Maybe I can use ID field and than import the number in another kind of field (formula, etc), using a combination between MaxValueHolder and an
Report based on a View in Zoho Creator doesn't get updated
I wrote a Report based on a View in Zoho Creator. The report doesn't get updated after I delete all records from the zoho form.
How to use a custom function in deluge criteria in lookup field?
The examples provided only demonstrate comparing the lookup field values to a static value (as in "year == 2011"), or a zoho variable (zoho.adminuser...) . How can I use a custom function or variable? I tried: year == get_setting("current_season") Where get_setting is a custom function I wrote, obviously. This gets accepted by zoho as a valid criteria, but when its saved and I reopen the criteria, it's gone?! Any help would be appreaciated.
record view in HTML
I would like to create an html view of a record which I can print as well. I am not efficient with coding and scripting. In the view, I'd like to see records from multiple forms. [student form] Student ID# Student Picture Student Name, Student Emergency contact ... etc [housing form] housing name housing location housing info .. etc [school form] school name school location school info ... etc
How to delete data from dropdown list once the value is entered ????
Hi zoho people, First of all I Thank all you guys to making such a wonderful software helping guys like me to develop online applications that make our job much more easier .Now my question is that I develop two forms . one form is having all the data that is entered by my employee . then in another form i had used lookup value field from first form and data is entered related that field in form . Now I want that once the data is entered related to that lookup field value in second form .
Refresh Button on a view
I want to create a refresh button on a view, but cannot use the reload action on a user defined function. What is the best way to create the refresh button on the view?
Alphabetize With Deluge
I am currently using a deluge work around to add the fields to a lookup list and keep from having the same entry twice. The problem I have from doing this is that they do not get put in the field in alphabetical order. So my question is, is there a way to alphabetize a list in deluge?
Query
Hi I want to use creator as a question and answer service based on keywords. I have a database that maps books with keywords seperated by commas Here's how it works, user sends an email to a form e.g. Body: Keywords: English, history, WW2 I want to create a script that will reply to the email with a filter of all of the records containing any of the above keywords. Do you know how I can do this?
Are <form> HTML tags allowed in fields?
I can input links and images via HTML tags into fields, but if I try to do <form></form> tags, it looks like Zoho strips it all out. Is there any way of including <form> tags in a field to render the HTML form in a view? Thanks.
Adding Mulltiple contacts without displaying all fields in one go
Hi All A Novice and very stuck I want to create a form where my employees can enter mass data. I have numorus fields that need to be created, but have encountered one main problem. Some of the data have 15 contacts and some only have 1, i would like to have a function that the employee can select how many contacts they have to input from a dropdown list, and then the form will display that number of fields to enter the data. At the momennt i am contemplating entering over 200 visable fields
calendar won't include 2011
I am using Zoho for my computer lab sign-up at a middle school. While it will accept calendar reservations rolling into the new year, it will not display items for 2011 in my room reservations view (where I access the attachments teachers have included). What do I need to tweak? Please help!! Jennifer
Multi Select Field
How can I easily add multiple items to a Multi Select Field. I have a lot of options and am trying not to add one at a time. Thanks. Lisa
french corrector
Hello ! Right now, Zoho has a corrector for english, german and spanish. Correct ? Any chance to have french corrector as well ? Thanks in advance for your answer
Help with hiding fields please
Hi All A Novice and very stuck I want to create a form where my employees can enter mass data. I have numorus fields that need to be created, but have encountered one main problem. Some of the data have 15 contacts and some only have 1, i would like to have a function that the employee can select how many contacts they have to input from a dropdown list, and then the form will display that number of fields to enter the data. At the momennt i am contemplating entering over 200 visable fields
Allow users to add new entries causes screen problem
When using the new feature to add entries the screen sometimes duplicates sections. Here are before and after images. Before After
For "Add an <Item>" option in lookup fields, include functionality to bring over values from several fields
The feature to enable "Allow users to add new entries in <Another Form>" is great; however, it is limited by not being able to bring key information over to the second form from the parent form. For example, in my application, clicking on "Add a Project" from a form with issues should bring over the latter form's information on organization, responsible party and IT system involved. Forcing the user to fill out all this information on the project form, when he/she has already done so on the previous
Emailing data to forms creates duplicate records
I am email data to a creator form using the email functionality, but all of a sudden I am getting multiple records for each record I email. Intially, I thought this was an issue with my code, but I tried it with a different form in my application (with only two fields and no actions on add/edit/load) and I am getting the same results. Did something change or is there a bug in this functionality? http://creator.zoho.com/carlgifford/test form: Seasons This application is shared to support
Relate CRM Contacts to Creator app
I may be missing the point of ZoHo creator - below is what I thought I could do, maybe it's not possible: 1. Create a Creator app that looks up Contacts from CRM (not last name, not first name, the entire contact name) 2. "Relates" records in Creator with Contact records in CRM. e.g. if I'm keeping track of license numbers for software, under each contact would be their "creator" records Basically, like invoices, or products, or any other "related list view". Is this not what Creator was meant
Autopopulate Field - Unique identifier for concurrent users?
Hi there, I want to autopopulate a unique field per record load. I got the script and instructions for this from suppport, see below: Add a new form with name MaxValueHolder form to your application. Add a number field named "highestval" to this form, to store the value. Add a record to the MaxValueHolder form with a starting value that needs to be incremented sequentially, ie, enter 18000 In the AOE PEST CONTROL Form, add the following code in the on add -> on load block of the script tab,
How to update Value from other FORM into existing Field in another FORM ?
here's a situation. Form A field quantity Form B field quantity How do I make that each time I entered a value in Form B ,It will update those value in the existing field in Form A such that the existing value in FORM A is 1 then I added value 1 in FORM B and it will update the value in FORM A into 2. Really Appreciate it if any1 can help me..
My File Upload field keeps adding a '1' to the assigned Field Name for Script value string.
Hi, I am designing a form that has 10 File Upload fields. 1- 9 is fine, but for the 10th upload field, the system keeps adding a number '1' to the Field Name for Script box under Options. Is this a bug? Why is that?
Online form that autopopulates database
Is it possible to have visitors sign up on our website using a form and have the data automatically populate a database in Zoho? many thanks, Justin
Como criar um botão no formulário , para que quando o usuário clicar sobre ele era redirecionado para uma url qualquer um ?
Como criar um botão no formulário , para que quando o usuário clicar sobre ele era redirecionadopara uma url qualquer um ?
How to create a button on the form so that when the User clicked on it was redirected to a url anyone?
How to create a button on the form so that when the User clicked on it was redirectedto a url anyone?
How to create a button?
Can you create a button on a form? If so, what is the code?
Report limited to 4000 records?
I have a form with over 8000 records. Every record has a field "Type" which is required (always filled). I created a report to show the counts per "Type". These counts add up to 4000 (I expected the total to be the same as the number of records in the form, over 8000). Is there a limitation in reports that a report doesn't process more than 4000 records? please advise Henk
Where is my Data?
I have created numerous forms but I cant get any of them to work, if I use the 'Contact' template for example the form lets me submit data but then I can't find in in the database view. Where is it? Thanks
Form Missing
My main form is missing, or it is no longer visible during edit. Please help
New record based on retrieved record problem !!
Hello Can someone point me in the right direction form 1 = Work template from 2 = Multi work steps associated with 1 work template from 3 = Project initiation by selecting a work template in form 3 I want to be able to create new work steps (from 2) associated with the new projet I managed to create the new records in form 2 but I can't seem to find the way tranfert the information from the inital steps to the new steps See attach image Thank you Pierre
Creator Form Layout
Hi, when I originally created my Form I did so with one column, however I would now like to change it to two columns. When I drag and drop fields from the right column to the left column the changes don't save. How do I save the changes? Tony
Can I host my Zoho creation on my own website?
Is it possible for me to create a database here on Zoho and then host it on my own website?
Email from sendmail command taking too long to receive ...
One of my clients told me that ... for one of the forms that normally sends out mail to one or two recipients (depending on conditions) ... only one mail (the first one in the To List) was being received. After doing several independent tests that confirmed this ... I was then advised by this client that ... I have just received the two emails from my previous test 2. They are timestamped 02-Dec-2010 11:27:08 but I didn’t get them until 12:31. Perhaps just a Zoho backlog? ... so I did some more
Copying numbers from a "Number" field to a "Single Line" field?
Hello, I have values listed in a "Number" field and would like to copy them in a new "Single Line" field. I have tried first to simply change the type of the original field from Number to Single Line, but I am receiving the following error message when attempting to enter any type of entries (number and/or string): "View Error Details java.lang.Long cannot be cast to java.lang.String" Therefore I have created a new field (Single Line) and I am now looking for the specific function to copy-paste
Open Url questions in creator
I have been using Zoho creator for about a year and am extremely pleased with the value your deliver and the unique niche you serve. I am able to inexpensively collect data online without breaking the bank on web design and construction. I would like someone to help me figure out how to fix the scripting for my form. In my application: 1st Quarter Review, I am trying to embed a survey-form into an iframe on a site: (DWMUpdate.com) I tried scripting in the editor to send an email with the form
error code when trying to edit forms
Hi, I am getting this error message: ServletException in:/jsp/edit/form/formedit.jsp] null' when I try to edit my form in Zoho Creator. Does anyone know how to fix it? Thanks in advance.
Intigration with Zoho Invoice
Hi, We have two separate Zoho Invoice accounts to manage different parts of our business. Its easy to integrate creator with the account with the same user details using invResp = zoho.invoice.createcustomer({.... What do i use to connect my creator app with the 2nd Invoice account? Any help or a point in the right direction would be helpful...... Kind Regards Jon
Stateless Fields and push buttons in a Database Form
Many times you want to use a field to store temporary values that do not need to be stored in a database or to have some push button functions that can perform tasks that will help in filling out fields. I know this can be done in a stateless form but it seems more economical to allow this kind of functionality in a form rather than to have all fields saved in a database.
Next Page