When creating a new form pressing DONE twice fast creates two identical forms
The problem is not that two forms are created. They are identical all the way down to the name. Editing one creates identical editing in the other one. They can't even be renamed separately. When the 2nd form is deleted, the first form is not deleted and appears empty (witout the fields that were supposedly added to the 2nd form but were visible in the 1st also).
URL which opens a view with criteria
How can I can add a criteria in my URL to open a view showing some records depending of the the criteria? Thank you!
On Success script broken
I have an 'on success' script on my 'add customer' form which opens a new sale form preloaded with the customer data: openUrl("#form: enter_sale?Customer=" + input.Full_Name,"same window" ); This script has always worked in the past but recently has become broken. After adding the customer, I get the following error: "There is no such component in ZohoCreator." Has something changed, or is there an error in my script? Thanks, David
3 and more level deep queries
Lets say I have 3 level relationship hirarchy (each come from a separate table/form): Company (account) Emploee (client) Order How can I get a table (view) that would dispaly Order number - Emploee ID - Company ID All three IDs in the same row. As I see now only 2 level deep relationship is shown when building a new view. Thus I can get Emploee ID and Order number togehter, but not the company ID. And views are based on froms so I can't build a view that queries Company and Emploee first and then
Problem with a number iteration
I already did did this kind of operation with your help. I create an iterate number like that : yyyymmdd00001.... I would like to do a new one for another number field. I write exactly the same script of the other one and it dosn't work. When I submit, a message appears and tell that "invalid entries was found". I don't undesand the problems, that's now few days that i'm blocked with that. Can you help me please? You can access my application. Thank you!
Null date values in HTML Print View
I have an HTML view for a form that is used to print the data in the form. This form contains date fields which may or may not yet have values populated. On the view I would just like to show a blank value ("") rather than a null for the date. is this possible. I have tried to use variables and conditional statements in the HTML view without much success.
Firefox Freezes on Public Form with Vaildate on Form Submit
I have a public form (no login) that has validation on form submission (to check for valid data), when there is an error in form validation the the page freezes in Firefox. This does not occur in Internet Explorer. Is this a bug?
Text input format
Hello ! I'm moving my very first steps in Zoho Creator. I'm a little bit confused, but still going on... My question is this: I'm building up a simple application to manage rally stages time for a game. At this moment i'm going pretty good on Excel but I would like to go better... I'm using in excel a text format for record stages in this format mm:ss.ms0 (minutes 2 digits, seconds, 2 digits, milliseconds 3 digits) and converting them in milliseconds for calculation. I'm seekin' in Zoho a way to
Application Disabled
Application Design and I thought work great, but now public users are getting Application Disabled??? How do I fix?
How to access values of Checkbox, Radio and Multiselect fields through scripting?
As I understand Checkbox field values, for example, are stored in a different way. How can I access them through scripting? Is there a detailed description of this somewhere in the documentation? If I have Checkbox field 1 with: - Option 1 - Option 2 - Option 3 What is the code to read if for a particular record Option 1 is on or off?
How to pass a parameter to an HTML view
I have a Form 1 where I have a custom action button for each row. This action button calls a function with an openURL procedure. Then I have an HTML view that takes Parameter 1. I want to open HTML view and pass a parameter from Form 1. I got Form 1 working and HTML view working. But somehow I can't get openURL to pass the parameter to the Parameter 1.
Please Reply ----Can't duplicate application
I want to duplicate one of my application but can't . I've allowed edit to support. Please help me duplicate this application. Thanks
Export to quickbooks?
Is there a way for zoho creator to export certain fields to quick books? Is there an easy way so i dont need to do this on a very regular basis? Is it always going to be a manual export from creator import into quick books thing?
A PostURL, then OpenURL sequence and using the Post Method (ie XML-laden Map Variables) to pass data to a Zoho form
Hi, Canvassing views on this... I would like to be able to carry out a PostURL-OpenURL sequence...so that I can pre-populate some of the fields in the new page being opened (i.e. a Creator form) with the posted data. I get the impression this is not possible, and that people to date have being adding a record to a form using PostURL (and the post method) and then retrieving it later (via some unique key which is generated on the fly) to prepopulate the form fields. In essence I am trying to emulate
NEED SOFTWARE APPLICATION CREATED IF IT DOES NOT ALREADY EXIST
Scenario:1.) previously registered customer comes to our website or 2.) receives email with link from us that takes them to a web page with 50 bits or information that represents 50 of our clients. the customer picks 6 things they want. the 6 things each have a code. the customers username and the codes associated with those 6 items are LINKED/MATCHED with the correct clients and sent to only those clients through encoded/anonymous/temporary email. the client receives and is able to view the customers
Verify a URL
Does anyone know how to verify a URL? I've tried using GetURL function, but no matter what URL I send, I get the -1 and internal error response. I guess I'm really looking for specific codes such as 403 or 404 and to prevent redirects. Thank you, Joe
Report/view for one form based on filter from different (linked by lookup) form
Hi, I have an app with two forms, Address, and Zip Code Info. The Address contains typical contact mailing address info, and the Zip Code Info form contains demographic information for each Zip Code. The zip code field is an Import Data field linked to the Zip Code Info form. I'd like to export addresses based on a filter from the Zip Code Info form, say, for example, the Avg_Household_Income field. I can't see in the Script editor for Views or Reports on how to link the two. I'm a beginner scripter,
Embedded the form on website. can I disable the login feature for Guest users to submit the forms?
Hello, I've successfully created the form using Zoho Cretor. I've also embedded the code on the website. Can I disable the login for guest users so that they can input the details without logging in? Thanks.
Batch import Zoho Creator
I am having trouble batch importing Excel spreadsheets. Date formated as "8/7/2010 5:03:11 AM" does not get imported..... I don't know how I should format the dates so Zoho Creator will take it?
Cannot edit any records and views have stopped working
Today i made a change to a field type from number, to text. It was a field that only had a couple entries in it. I read the typical delete your reports message which was fine since there were no reports based on it. I then tried to edit the field that i just turned into a text field. I was unable to save the changes when i clicked on edit and made changes. I then went to grid view and was able to make changes and save it. Now this field that was changed to text does indeed have numbers and words
Embedding a Creator Form into a secure site (SSL)
I have created a form in Creator, which I embed in an iFrame on a web page that has an SSL certificate. On certain IE browsers I get an error loading the page stating that some elements may not be secure. The only element on this page that isn't secure is the iFrame. My hosting service had me check all the HTML that we could find, looking for links in the iframe that referred to the unsecure (http:) site address instead of the secure one (https:), but we couldn't find any. Is there a way to
Creator.zoho.com link timing out for last 10 minutes
Huston, do we have a problem? Im in Wellington NZ I can access other apps, calendar & projects Richard
Numeric Picklist?
I am trying to create a picklist with a range of numbers (1-9), but it seems to save the selections as stings rather than numbers. Is it possible to have a numeric picklist?
form disappeared
Jeez. Form disappeared. Can't access it. Spreadsheet still there. Help!
How to Populate Dropdown with Selected Values from Multiselect field
I am trying to use the selected values in a multiselect field in one form to populate the dropdown values in another form when the records match. 3 forms in all are linked. For example, if I have a multiselect field called "MM" in a form called "FormA" and a dropdown field (called "DD") in a form called "FormC". FormB contains a link field called SubID. FormA has fields: ID MS FormB has fields: ID SubID FormC has fields: SubID DD So if I select a SubID in FormC I find the record in FormB where
Moving an application
How do you move an application created in your personal workspace to another workspace?
Zoho Form and Trac Wiki
Is it possible to embed a zoho form within the trac wiki system? Joss
How to have a field (with number entered in it, e.g. 12), produce a corresponding number of fields for entry.
I am working on building an educational assessment tool for teachers to share data. I can't seem to figure out a simple way to do what I want, so I thought I would ask. If the user enters "12" when prompted for the number of students in his class, I want an action that generates 12 blank fields for student names. I hope someone can help
Specific Email Check Validation
I only need to accept form entries from certain email addresses. For example only people who have "@usc.edu" in their email address needs to be able to submit my form. If they do not have "@usc.edu" in their email address they need to see an invalid email address message. Does anyone know how to do this? Thank you in advance for your help.
Deluge help: adding to a list in another form
I'm trying to write a Deluge script that will add a name entered in one form (interview form) to the relevant address records in another form. Since the address records may have more than one name associated with them, I need to be able to add a new name to that field without compromising the old ones. In addition, I need to be able to remove the name from the address record just by removing it in the interview form. So far I have gotten the addition and removal to work when the addresses associated
Allowing new members to add themselves to the database?
I want to allow people to add themselves to my database from a web page. I realize I need to make the application public. However I don't want anyone to be able to read the database, and I don't want them to have to fill out all the fields. How do I restrict reading and limit the fields offered (through a view?). -- Kristy Dyer
[ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
I tried to view the form via "form definition" to look at the code. But I got this: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' It's in my app movies*******
URL Link to change the value of a decision box in a specific record
Hello my Zoho-ites, I've been reading the user guide section, but cannot solve the issue I'm trying to make. I would like to provide a link to a decision box to change the value from false to true by clicking on it. Does anyone know how? I don't want the user to view the record. Thanks for any help! Joe
Saving Lookup field data into new lists.
Hello everybody, I had a question. I have placed a lookup field in my form that has a list of 2000+ players, I wanted to be able to select a couple players from the lookup field then save them to a team record. For example... I select 7 players from the lookup field, save them into a list, name the list, then save it. I would also like to make another form that looks up the list of new teams i made from the prior form, a user be able to select a team, then edit the data accordingly. Like adding a
Related records
I wanted to create a view, with the related records of a record showing on the same page.... Which is to say, in a one-to-many relationship, I want the main records and all the related foreign table records showing on the same page.... is this available now?
"For Each", "Sum" and then "Insert into" issues.
Hello All, Form A = Form with Data that I want to retrieve from. //Form A will have multiple records that are indexed by "Po_No" Form B = Form that I want to pull data into. //Form B will required the muliple records in Form A to be summed with the result being inserted into a record in Form B. I am trying to use "for each r" to pull record specific data from Form A, sum specific fields, and take the total sum data and insert into a field within a new record. I will need to repeat the "for
Forms and URL validation
Does anyone know how to validate the URL entered in a field on a form? I guess really to check for 404 errors? Thanks, Me
Multiselect lookup.
I would like to create a record for each item of the multiselect (lookup field) list which are selected by the user. Because when we select few items in the multiselect lookup field, those item are registered in one record. How can I do that??
postUrl needs to support XML REST Services
I have an urgent need to interface an application in ZOHO Creator to an online bookkeeping system which supports REST based web services. I was a little surprised to see that the postUrl function only supports maps (key->value) pairs and not the ability to specify an XML body in the POST request. When is this going to be changed? Is there any chance that we can have a special key "data" that simply uses the value in the body. This would allow for backward compatibility in the function call and at
Form layouts
How can we modify the form layout, color and such? Currently, all my forms have two columns. What if I want a compact single column? I've been searching the User's Guide, but haven't found anything. Thanks, Joe
Next Page