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
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
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.
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 .
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?
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
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
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
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?
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?
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
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?
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
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.
How to apply lookup
Any one help me how to apply lookup like according to the STATE will be display CITY name in the form.
Is there a way I can set up a group email list using the records from my Creator database?
Hi, I am wondering if I can send a group email using the contacts in my Creator database. My email provider only lets me add each contact individually, so I can set up and email address group@mydomain.com.au but I would need to add each forwarder individually which would take me a year to set up. So I'm wondering of there is some other way I can email all my database at once, rather than copying the email addresses from my database and putting these into an email manually each time I want to email
Workflow integration with Zoho Creator
I need to build an application that combines an on-line database with workflow, so that workflow can control the timing and sequencing of information that is entered into the database. I also need to be able to generate emails in my workflow app which extracts information from Zoho and sends the results (in other words, I cannot generate the email from Zoho based on the "events" that are available to me). I have been working with RunMyProcess, and although that appears to do what I need from a
Share view/form but don't show it in menu
I would like to share a view or form without showing this view or form in the menu. Is that possible? I want the user to work from a view, and give only access to forms by using Custom Actions. Can this be done? thanks Henk
I DON'T WANT TO DELETE THE COMPLETE DATA FROM RECORD BUT JUST THE VALUE FROM LOOKUP FIELD
But doing this not helping me sole my problem .... actually i don't want to delete the data from second form database but from the lookup field i want to remove that value . for e.g . One form is there with name service challan anED THAT other is job status . In Ist form many fields are there where i enter all the details of the product n, type etc . one field is job no. whose value i have incremented automatically . now this job no. is used AS LOOKUP FIELD IN SECOND FORM . AND DATA RELATED
Unable to save new colums
I just created a duplicate database to use for editing purposes. I have tried to add several new fields to it. However, they are not showing up in the application and under Views>Column properties, they are there and I check them but I am unable to save them. As soon as I check the boxes and click done, they uncheck themselves again and the page refreshes. Anyone have insight on how to fix this?
Need to bulk edit a checkboxes field without clearing current choices
Hello all, I would like to bulk edit a checkboxes field (4 choices) that already contain information (1 or more choices already selected) by checking an additional choice, without clearing the field. The following post (and solution) seems to be very close to what I need: http://help.zoho.com/portal/en/community/topic/suggestions-for-bulk-edit-of-multiselect-field?-6-12-2009 This is for a multiselect field. Could it be adapted for a checkboxes field? Thanks in advance, Patrice
Column width in summary view
hello, how can we set the column width in a summary view ? The help files refer to a "set column width" option in the configuration menu, but this option is not available for a summury (only for views). When I try to embed the summury in a web page, the view is too large and i wish to adjust the label size as well as the input field size. How can we do that ? Thanks for your help,
Custom filter
I wanted to create and save a filter with "added time" within last 30 days. How can I express this in a custom filter? Thanks.
When I open a record in an HTML view it displays all records instead of a single record
I have tried to follow the various tutirials on this forum, but i am stuck. I have created a function that put a button on the list view of one of my form's data, that should open a single record, but when i click it it Opens all the records in the HTML view , instead of a single record... I have posted my code below, can someone PLEASE HELP. Thank you in advanced. htmlpage Compost_HTML_View(ID) displayname = "Compost HTML View" print = true content <%{%> <%for each x in Compost_Tracker {%> <div
relational database
I see that there are notes on the forum about adding relational database capability to Zoho database going as far back as 2007/2008. I am looking for this functionality but cannot find out how to access it. Has this functionality been added yet? If so, how can I use this functionality to validate a field value against a lookup table as soon as the value has been entered? Thanks!
Will Publishing application change name of application (and break URL links)?
I have an application that I have been developing for some time. I have shared this application to the users, but now want to publish to them (the client) so that I continue development. Will publishing change the application name? Will it break any of the URL links in the application. For example, I hyperlink to different views and forms using the application URLS.
Error message when editing a record from Form View
Hi -- I keep getting the following error when trying to edit data from a form view: [t_431470000000028161_PIDX] Exception occured while inserting rows Failed to update data. Thanks in advance!
Insert Record hanging in Stateless form
mQuotation = Vehicle_Quotation [Quotation_ID == input.Quotation]; mFields = getFieldNames(); mID = zoho.currenttime.toString(); mData = map(); for each mKey in mFields { mData.put(mKey, getFieldValue(mKey)); } mQuotation.Status = "Reissued"; insert into Vehicle_Quotation [ Added_User = zoho.adminuser Bank = mData.get("Bank") Book_Days = (utilities.configuration.Setting("Default_Booked_Days").toLong() + (mData.get("Book_Days")).toLong() - 3) Color = mData.get("Color")
Find Last Record in Form - MAX Function?
I have a form where the users inputs a sequence number (integer). I would like to autopopulate this with a user input script (when the previous field is updated). Is there a way to find the last record number? I was look for a MAX function or something similar. Thanks,
action to copy field contents
Hi, I have two fields in a form, "site address" and "billing address". I have a radio button, "same as site address", with one option, "yes" I want to add an action on user input to this radio button so that if the option is selected then the text from the "site address" field is copied into the "billing address" field. I'm sure this is simple but I can't seem to work it out. Can anyone help? Thanks Jeff
Opening Single Records in HTML View
Hello, I have created an HTML view for one of my forms, and I need to know how to execute a function that will place a button in a column in a list view, that when clicked, it will open a new window displaying the specific record in the HTML view i created... How do i do this? thank you in advanced
Simple Question please help
I have a very large form, so to make it easyer for the user i made a drop down menu that shows only the section of the form that is selected. The problem is the script is so damn big, which causes crazy lag, Can anyone suggest a more effect way to do this... the current script located below http://creator.zoho.com/jpiajr/form/492/scriptbuilder/ under the "on user input" for "select a section to view" field
Deleting Copy of View
I created a Copy of a FormView which contained numerous records. The Copy was renamed CopyView and then the records residing within the CopyView were deleted. When I deleted the records within the CopyView, the original FormView lost all it's data records as well. Is there a way to delete a Copy of a View without impacting the original View?
Ordering of records in a For Each Record script
I am iterating through records in a form, but I need the order to be based upon a field in the form not the ID of the record. Is this possible? If so, how?
Formula
I want to create a formula that will allow me to add a certain number of fields, then multiply by a different field. What is the best way to do this? I want it to look like below. Thank you for your attention to this Expression (A+B+C+D)*E Regards,
Next Page