Firewall blocking Submit button to Zoho Creator form
Hi, I created a simple form to collect survey. At one of our vendors, the user cannot submit the form due to firewall. I have told their IT dept to drop the firewall for the form: https://creator.zoho.com/andryharyanto/ctp-control-group/# However, whenever they click the "Submit" button, the "Please wait" message box will appear and freeze. Do you know if there's any additional URL that I should drop in the firewall? Is there a specific URL for the "Submit" button? Thank you!
List of Country/Regions
I have a Country /Region field on my form. Does anyone know where I can get this list and how to import it into the field as a drop down?
One to Many Relationship (Parent with several Children)
I am creating a registration form, in the form I have created a decision field asking the user if they have children. If the user places a check in the box (Yes they have children), I would like to have a prompt for the child's name (First, MI, Last), birth date and drop down menu to select age range to be displayed. If they have more than one child, I would like the user to click on an Add button to add more names, birth dates, and age range selection. I would assume another table would have to
Limit Selection on Checkboxes
I have a check box on my form. How do I limit users to select only one? e.g. Preferred Communication: _ eMail _ Phone -- Snail Maile _ Other
Cycle 2: Custom Authentication Methods
Suggestion: Custom Authentication Methods Purpose: Allow admin to create a custom authentication mechanism not tied to the Zoho user ID system Motivation: Custom applications that are purchased by corporate entities and organizations may take issue at having to use Zoho accounts. There is nothing intrinsically wrong with Zoho accounts, it just that there may be policies requiring certain auth methods OR member contact data may be viewed as propriety information and cannot be released outside the
Missing columns in my VIEW even if checked them in "Column Properties"
Hello, When I go to my application in my "VIEW" I am missing columns, even if I checked them in "EDIT APPLICATION/COLUMN PROPERTIES". Thank you for you help. MP.
zoho creator business model.....and some questions.
I am a little bit confused as to what exactly is the best business model for using creator. I understand that ultimately, its up to us to find the best ways to make money with it BUT, I find there are some general bottlenecks in my mind. I might be confused, but that is exactly why I came here asking: 1-Every pricing package, comes with a certain amount of "records" that your applications can have. This is the # 1 confusing factor for me. Can you explain to me what exactly is a record ? What I understand
Is anyone finding their application is slow today?
Ours has been very slow moving from page to page, opening and closing records for the last few hours...
Set email notification not working
Hi! I cant configure the email notification anymore. When I click at it, just a black banner appears, and I can't change anything. Just a refresh take me out of there. Is that something wrong I did? Thanks. Regards, Leandro A. Boscariol
Count Function- look at multiple fields
I want to put a limit on the number of campers that can sign up for one session. Campers can sign up for up to three session. Let's call one of those camps "Open Age #1". Open Age #1 could be selected in lookup one (Camp_Session_1), two (Camp_Session_2), or three (Camp_Session_3). I've got my current code below that should check for records and alert if the limit is reached. It does not seem to work correctly. Can anyone spot my error? Thanks! max_people = 0;
if ((((input.Camp_Session_1 == "Open
How to Auto-Increment a Numeric Field for Multiple Submissions within Same Browser Session?
I've got a form that asks users to supply a set of data. They may submit one or more datasets per browser session. One field is a date field. Another field is a numeric field that should be "1" for the first dataset submitted for a specific date, "2" for the second dataset with the same date, "3" for the third dataset with the same date, etc. They can also enter a different date, for which the numeric field should reset to "1" and increment by 1 for each subsequent dataset submission for the
translation of commands
in the views we have word-actions like "More actions" "Print" "Import Data" "Export Data" how can i translate them into another language ? also can we have opportunity to have in 2 languages our applications like websites?
Column Sorting Problems / Questions
I'm a newbie to Zoho Creator, so I apologize if these are stupid questions, but I can't find answer in the forums or in google. I've got a form with many columns. When I sort by one column (let's call it "A"), it works, but there's no visual indication that column is the one sorted on. When I then sort by another column (let's call it "B"), it also appears to work, but it seems to be sorting "B" *within* the already sorted "A". I'd like to find out how to do a few things: 1) Visually show my end
Manage users
Account Settings -> Manage Users -> Add New User Can you specify/restrict which applications the User can view? I embedded a zoho form to a site (application set to private) and I added a user, to my account settings. But the user cant login when he goes to this form only the admin can view it. How can I fix this?
search using boolean expression
hi, i like to create a html view similiar to this - if(a.contains.input.a) && (b.contains.input.b) - records containing a + b are fetched. Can someone please help me? Thanks
How to fetch a record where column condition value is in between the values of two records
Hi, Example Table Pricebook: Weight Price 0.5 100 1.0 200 1.5 250 I have another form where the user enters the item required and the weight as 0.8. How do I search through the records to obtain the record with the higher weight than the user input value. i.e. in above case it is the record with weight as 1.0 A solution to this will be greatly appreciated. Thanks!!!
How to DYNAMICALLY redirect a form page?
I want to add a dropdown list on my form. Depending on the choice from the dropdown, the form redirects the user to a unique page. Is this possible in Zoho? Thanks,
Want to be able to FREEZE column header row in Creator list view
Users in my organization are frequently annoyed by the inability to see the column header names when they scroll down and across the many records in a list view in Creator. Reducing the number of records per page is NOT the answer we want. When you have many records to review it's preferable to load up to 200 per page, but the inability to see the column headers is a sorely missing feature. Could Zoho add the ability to freeze the column header row in Creator list view? Many thanks. Greg Malone
All public view/form permas URLs just refreshed!
Client calls me and tells me that his public facing application is asking for sign in! ALL of the public views and form URL's had refreshed there public URL string! All of them! What is that all about? This is not supposed to happen is it? Note: I am aware that child forms/views do not inherit the public parent perma views share status.. ALL of my embeds where set to public and ALL of them where changed NOT in my code but in the form/views "settings".
Help Request Form
I have a form that keeps record of submitted requests. I also have a sign-off by administrator field that has a "work in progress" "pending" "completed" that is filled out once an administrator see the form and attempts to take an action on the request. Anyway I want to be able to filter through requests that have been submitted that has no sign-off status because when requests are added we need a way of searching the filters for those that have been added but not signed-off. There is no option for
Order Form
Hello, Please can you help me to create an order form like this 1st item 4$ ENTER QUANTITY1 2nd item 6$ ENTER QUANTITY2 Total = QUANTITY1*4 + QUANTITY2*6 Please can you help me to get a visible and live updated total field Thanks a lot Olivier
Remove Header from the Entire App
Greetings and thanks again for a great app... I want to use the actual zoho screens and website for my app rather than embedding in another website. So... 1) Is it possible to remove the header at the top of the app so that the Go To and Feedback and Log Out options are not there? 2) I have read some of the info about embedding my own logo...if I do that will that replace the zoho logo at the top left of the app? 3) If I can't accomplish these tasks, is it possible to embed the entire app in an iframe
redirect webpage when finished with form
Can anyone tell me if there is a way to specify a url that the zoho form would go to when the users are finished filling in the form. We people are done filling in the form and click submit, we want them to be redirected to our homepage. Thanks!
Grouping with a multi-select field is currently useless
In most cases when grouping records in a view depending on the contents of a mulit-select field, the user requirements will probably be similar to the following scenario: A diving school has three types of diving courses (A, B and C). Each diving course can have multiple instructors. Now the user wants to create a view that shows, which courses an instructor is assigned to. Zoho Creator would display data as follows: Mary, Paul Course A, 01.01.2010 Course B, 01.01.2010 Paul, Peter Course B, 02.01.2010
to know status of field (hidden or shown)
i have 10 fields which are hidden at the LOAD of form, and depending to the select of user can be shown. i need to know status of fields at the submit action. it's like if ( field1.status("hidden") ) { do something; } else if ( field1.status("show") ) { do anotherthing; } how can i do it. which command is it?
Is it possible to double-sort records in a For-each loop?
I have numerous records that define certain workshops. Each workshop has a "category" field. In an HTML View I am using a For-each loop to list the workshops. In the For-each loop I am using "sort by Category", and it works. However, I *also* want to sort the records inside each category alphabetically. Currently the records being displayed are grouped by category (which is correct), but inside each category the records are in a non-alphabetical order, which is distracting and difficult to
Why does count not work if value is "null"
Hi, I have a count function saying as below: What can be wrong? Br Skouboe
Load form with requested data
Dear all, I am totally new to this application and programming in general, and need an answer to this basic question. I am looking for the easiest way for the user to edit data. I would like the user to click a button next to the school's name where upon he will be taken to a form where the data has already been inserted and where he is able to edit the information and click "save". It is that simple. But how do I do it? J
Using a Multiselect Checkbox Look Up Field
I am having fun with the new openURL command targeting an iframe in an HTML view. I'm trying to develop a simple voting application where users can add their own questions dynamically (I've got that figured out in an html view an it updates the choices nicely). Then I would like them to pick their favorite three questions from the list. Below is a sample picture: My questions: How can a limit the users to just three checks? How can I divide out the check box text to count each entry separately?
Realtional Database
I am new to database work. I need two simple forms 1. Apartment Form - with a "tenant apartment number" and a "tenant phone" feild only. 2. Repair Form - with an input feild "tenant apartment nunber", a "repair needed" feild and a "repair telephone" feild After all tenents are entered in the Apartment Form database, I would that on the Repair Form I could just enter an apartment number (not a dropdown, but enter it via keyboard) and the tenants telephone shows automatically in the "repair
Search in Creator
I would really like to know how to create search boxes for a database. I am creating a database where people will create a username and password to access. They will then select from a drop down menu with three choices: if choice 1 is picked then only certain fields are shown, if choice 2 is picked, then a different set of input boxes are shown, etc. I would like to create a search page where users can enter their search terms and search the entire database. Optimally, I would like to have multiple
Multi-select response triggers action on single-item field
Not sure if that title best describes what I'm trying to do but I hope that someone can help me with the coding for this problem. I'll be asking about a series of questions for which data may not be available, e.g. height, weight, shoe size We like to have a response for every question, i.e. no blank values. For dropdown fields, we'll include an "unknown" value, but to handle single-item fields, I am thinking of including a field (multi-select or checkbox) that allows people indicate that data for
September 2nd. Did anyone get notified the fixes were delay again. I didn't.
Proactive - Reactive @Charles, did you miss the promised date of September 2nd for many fixes and features discussed in this forum? It is September 2nd. I do NOT find that the features and fixes are implemented. Not the end of the world. But where on earth is your communication to the developer community. We promise features to our users based on your commitment to us. So the sh*t truly does roll down hill. I think I speak for all of us that we need better communication. (Take note from the amazing
Restore problems
Today, August the 27th, I went to my Restore in progres menu and I saw that: app-coin Started 2009-07-23 02:18:21.0 It's started one month ago!!!!! I Make a new restore and I realize that it doesnt works. I cannot import my script .ds either from my computer,because the import progress never ends. Any Ideas? Thank you.
how to create 4 mutualy dependent lines
Hello, similarly to a country/state dependent lines where accoridng to the country you choose, the seocnd line "state" would adjust to the choice of the country, i need to create 4 linges that each depends on the previous line choice. First line for examp,e would be maths, french, english if you choose french, a subset would appear , for example french litterature, french history and french arts. Then on the 3rd line, if you choosse french history, appears a subset of choices "french literature
Check if email field is blank before send mail
Hi everyone, in order to promote my blog I created a simple form so that visitors can tell there friends to come.It looks like this: Visitor's have to write down at least one email of there friends. How could I check if optional email fields (2,3,4) are not blank so the sendmail script does not bug? ("To:" field doesn't accept blanks...) Many thanks!! Sébastien
viewing uploades picture in view section
I made a database that I want from users to input specific information like : name , last name , and uploading a picture ... and I used upload tool in database for uploading their picture ... but in view section I want view that picture but I dont know how get the relation between that picture uploaded in form sction and viewing that picture in view section ...
Multi-Select Field: Sorted in Edit mode, but unsorted in View
I have a Multi-Select Field which displays all values (selected and not selected) sorted in Edit mode. But when I save the record, the selected values appear unsorted in the List View. They also appear unsorted when I read the values with an html View. Further info: The field's property to sort the values is selected (field properties) I modify the field with Deluge script in the On Load event and use the built-in sort functionalityThanks for any help. Filip
Re solutiong for how let customers to easy place order
Hi I hope got bloow interface for place order by customer,how do that? I tried ued "for each list value" to read a Multiple List (it's a product list) , but do not know how to let about customers to input the number of urgent,hope you give me some recommendations and your solutions, thanks! Stanley Guo
VERY VERY simple application
I am having toruble creating a very basic application where: Users enters 6 fields including 1 link to a picture and the application creates a new html code. (i already have the html code and know where the 6 fields should go) please help PS the input part is already created i am having trouble creating the view
Next Page