Get input.ID on Stateless Form Submission
Concerning stateless forms: One thing that bugs me is that an ID number is generated after form data is submitted. This is an issue in my mind. Here's an example: A user submits a stateless form proposing some idea to a team. The team is then notified by email of this action along with a url linked to the idea. We cannot use a url link that has https://creator.zoho.com/admin/myapp/form-perma/newidea/&ID=212085000003178069 form because the ID is created after the fact. Rather, we are forced to create
Adding scores and returning an average...
I want to create a form that will allow any number of clients to rate a service and display the average score in realtime on the same form. Any ideas?
Is there any other way to show the formula field
Im trying to display the price (Rate*Quantity) to users in my form. I have read that the formula cannot be shown. Is there any other way to display ?
Getting the selected value from multi-select list
I have a multi-select list. How can I figure out (with code of course) which values are selected and which are not?
one sigle record
Hi, Please, How can I get just one record for may website? Exaple: I have a table with a cell with produc name: "Suarez" and I want in the next cell the value of "Suarez: that is in the db. Thanks in advance, Ricardo
How do I fetch data from a field in FormA to FormB with the criteria in both Forms?
-- I have Form A (names and other info of SHOWS) -- I have Form B (names and other info of PROJECTS) -- In Form B I have a field "name of show" -- I want to have in Form A a list of all the projects that match the "name of show" Can someone help? Thanks, Illetsac
Creating an alert when a duplicate is detected
I have a field called input.Client_PO i would like to create an alert when the user inputs a location that's already in the DB. so fas i have Client_PO -> On user input If (input.Client_PO == ***duplocate formula****); ( show alert_label; } of course the part i need help with is the formula for finding duplicates, once that happens the alert label will be unhidden. thank you.
Remove records to another database
I have a database, that inadvertently ended up with nearly 2,000 records that do not belong there. Although they are not for this database, I think they might be valuable to someone else. I can only see how to totally delete them, and at that, no more than 200 at a time (200 in the view). Is there a way to MOVE the particular records, found in a search, to another location, preferably on my hard drive ?
Getting an Error that I cant Figure out!!! HELP
I have a set of Stateless forms that feed into a master form, to produce a single view of all the data collected from the various stateless forms. I have 100+ fields in the master form, but when i try and add additional fields it gives me the below error... please help Ive put way to much time into this for it not to work. Error modifying the page Syntax error or access violation, message from server: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Maximum code in a form?
Hi, I was wondering what is the recommended amount of code to place in one form. If you don't have an exact limit, how many lines of code would you recommend out of experience? I've been getting some strange errors and want to make sure I haven't overloaded the form. Thanks!
== operator not valid for boolean variables?
I have the following line in a script: frn = Furnishing_Options [Furnished_Value == Furnished]; Guess what? It throws an error: Error in statement at line number 1 The Left expression is of type BOOLEAN and the right expression is of type BOOLEAN And the operator == is not valid here So I can't compare 2 boolean variables? This seems to me a serious limitation. Regards, George
Update a random record?
I'm playing around with some game mechanics in one of my creations, and would like to be able to update a random record. Any suggestions? Thank you so much.
My hyperlinks are suddenly not working!
Hi I have a HTML page that works as a main page for my views and form. I have icon that has links to other forms and views, but they suddenly do not work. Think it happend wednesday! What can be wrong! Dennis
Formula Help: Count items checked
I'd like to create a formula that counts the number of items checked in a check box field. The number of entries checked would then give a rating based on the number. Is this possible to do with a formula field or does something more complicated need to be done? Thanks
Email - dynamically changing "to:" field
I have a database (form and view) for human resources that has contact names, phone, and email. I also have a form that keeps track of the stats of certain projects. I want to be able to send out an email notification to the project lead if the status gets changed to "problem" for example. What I cant figure out is how to dynamically change the "to:" field. Its almost like I need to do a lookup. So it needs to look in the status form for the field of "owner" and then correspond that owner in the
Create a Purchase Order DB
I want to create a Purchase Order database whereby I can create a unique Purchase Order number and add a quantity of product lines to the order and have it total at the bottom. Is this possible in Creator? Thanks, Martyn
Data base maximum records
Hi, I created a data base in Zoho and imported all my contacts which is an Excel file of 6,00MB. I saw that maximum is 5MB but, however, i have 17850 records in my PC and, in Zoho, I only have 4355 records. Is this possible?? What can I do to have all my records in Zoho? Thank you very much.
How to fill a picklist with multiple fields from another form (and save just ID as picklist value)
Hi, I have two forms: "Parents" with fields like first name, last name, gender etc. "Children" with fields like first name, last name etc. as well as two lookup fields (picklist type) named Father and Mother, that are linked to the "Parents" form. Is there a way how to have the full name of the parent (at least first name and last name, possibly more data) displayed in the corresponding picklist, while saving just ID as the picklist value in the database? Currently, the user only sees the ID (values
OnSuccess - Multiple If Statements - OpenURL
I have created a questionnaire that asks a series of questions. Upon submission, I want a specific URL (there are only 2 possible URL's) to open depending on the answers to the specific questions. For each question the user can only select "Yes" or "No" as each input field is a radio. Once one answer satisfies the condition to open URL2 and the user submits the form, I want URL2 to open. If no answer satisfies the condition to open URL2, then URL1 will open. Right now, it appears the code below
How do I email only data fields that have been populated?
I have a rather long form and want to only see those fields that are relevant.
Is it possible to count the elements in a picklist?
Hi, I'm trying to do count(input.Picklist_field) but zoho is rejecting it. Isn't it possible to do this?
Linking forms
Is there any way to link the information in two forms without using look-up fields?
Look-up fields - not in drop-down form?
Hi, When linking two forms with look-up fields, is there a way for the user to enter an answer in the look-up field in Form 2, rather than selecting from a drop-down which was populated from answers from Form 1? After a while the drop-down list gets very long and messy looking. Thanks, Elizabeth
to move app to another user; to change app as shared app
I have two questions: - is it possible to move an application to another user: I made an app, I share the app, the user I shared with keeps the app and I delete it ?!? - if a app is shared as developer, is it possible to make changes? (show as grid, change something and save it)
help
ive put my profile in twice how do i delete one of them???
Batch update lines
AFter a bulk-edit of a few lines, the "on edit success" email is not set. Can I enable this?
Designer PDF Forms for Zoho on you own server
DESIGNER PDF FORMS FOR ZOHO I thought I would share this because it took so much of my time to figure everything out. I wanted forms that looked sexy and professional. The export pdf function of Zoho was very limited as are most pdf export options of many programs. Only high end expensive programs have options to really make fancy forms. I liked the simplicity of Zoho in building forms but I wasn't happy with the output. My programming object of the PDF form was simple. 1. Take Form data using
Problem inserting new record
When I tried to insert new record I suddenly encountered this problem. As you can see I got 3 FORM in this apps. Stock In & Stock Out Form contain 3 lookup taken from StockList Form named "Category/Code/Description". I dont know how to identify this problem. Please HELP me asap..
PreparedStatement Error in Data-Dictionary.
1 . [t_621460000000013065] Exception occured while setting value in PreparedStatement for the Column [Appointmen_621460000000116141] Check whether the datatype for this column is given as specified in the data-dictionary .[t_621460000000013065] Exception occured while setting value in PreparedStatement for the Column [Appointmen_621460000000116141] Check whether the datatype for this column is given as specified in the data-dictionary This is what displays when I try to add an appointment in my
Can't fetch record
Hi, I have an html view that generate a print page (in pdf). I can't fetch records, I think that I do a bad use of fetch command, but I can't find the error! Any help? Mic Here my application
i18n and l10n via export-import of app as script
Zoho Creator does not provide any kind of i18n or l10n facilities. However, the applications can be fairly easily made translatable. mark all visible labels in the app with a prefix to mark them as message ids export the app as script extract the message ids translate them (re)generate a new translated app using the app script file and the translations (re)import the app script back to Zoho Creator Thoughts? Is this proposed or described already somewhere?
Code to add multiple file upload fields?
Hello, is there a feature in the creator where I can make a file upload field with an option to add more files? I am trying to do something similar to Gmail when sending an email you have the ability to continuously attach files. I only need it done for about 5 files at most but for the sake of organization and cosmetics, id like to only show one at a time.
Input Field Behavior
Would it be possible to have the ability to correct a field input within the field input without the problem of reiteration. This would work well for range problems. The only work around is to have additional fields that have call functions to fill in values or to try to do this in Validation which does not allow the user to necessary see the corrected values.
Forwarding contact responses to my email
I'm having trouble finding where I type in my email on my contact form so when someone fills out the form, the responses go to my email address.
How to show forms in iframes in "Rich Text" fields? Works for views, not for forms
I set up a rich text field and inserted as html the iframe snippet for a view, and it works well. However, fields do not show when the same is done for forms. The header shows, as does the sliders; however field names and the fields themselves do not. I tried customizing field sizes and colors, but it makes no difference. Also not shown if done as a form-perma, though again the view equivalent works fine. Would make it neat to insert affiliated forms into other forms and even into views, were
How to put the print option on my form or view?
How to put the print option on my form or view?
Fomatting Fields
1) Can you add some formatting functionality to the field descriptions so we can avoid using functions. String {Title,Upper,Lower,Sentence,Alfa Numeric} [Format ###,###.00] The best way would be to have a descriptor field. Also for report VIEW output it would be nice to have proper numerically formatted fields.
Public Access Pending
Hello, I need public access to my form as soon as possible. It has been a couple days already. The form is for a NFL playoff pool, which needs to get started right away! Thanks for your help!
Public Access Pending (Needed ASAP)
Hello, I need public access to my form as soon as possible. It has been a couple days already. The form is for a NFL playoff pool, which needs to get started right away! Thanks for your help!
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
Next Page