Filling out forms on iPad and iPhone
Forms used to work great on my iPhone until recently. I also just got an iPad to also fill forms created in Zoho Creator. After hitting the submit button, the "please wait' box pops up and the form gets submitted, but the browser never advances to the next page. It seems like a problem with the javascript, but I don't know. The form works correctly on my mac in safari, and other PCs that I have tried, so the problem must be with mobile safari. Any ideas?
Connecting data from one app to another
Hi all, Brief snapshot of what Im trying to do: My application is used as a job application. Candidates submit their info and resume via a form. An email alert is sent to the manager assigned to that location We have 100+ locations, each with different managers, each manager with their own email address. The problem that I encounter is that if a manager leaves the company, or is assigned another group or locations I have to edit my script to make those changes. Obviously this is an easy way to
Question in table form
Hi, Is there any way to format my questions into a table instead of a long list of repeated questions? For example, instead of Subject A: question 1, question 2, question 3 followed by Subject B: question 1, question 2, question 3...can I make a table with Subjects as the rows and the questions as the columns? Thanks!
Read-only privileges
Hi, is there any way to assign read-only privileges to few users without actually canceling editing privileges to other users? If so, what's the procedure? Thanks,
Sort dropdown alphabetically - how to sort by Last name and not First?
Is there a way to have a dropdown list sort by a customer's last name and not the first? The order for the dropdown list is: last name, first name, date-of-birth. Keeps sorting by First Name - which works, but doesn't work as well as sorting by last name. Thanks!
Make dropdown field default to most recently added entry
I have a lookup field w/ a dropdown (for Customer) within an invoice-like form. I would like the dropdown to default to the most recent entry so that the user doesn't have to search out the newest customer... I have option enabled to add new entries on the fly (check box for "Allow users to add new entries in XX"), and would like them to populate in the dropdown after being added. Thanks!
Suggestion on Report Builder.
Hi Zoho, The new filter in the report builder is nice! It would be nicer if after using it, filtered results can be printed via pdf as "what you see is what you get". For now printing only follows the original report template and ignore the new filters. Or I missed something? All the best, Edith
HTML Views
Hi! I have been using DabbleDB. There you could to make public your custom views. I am testing now HTML Views. I have embedded it in my site. I have made it public. It still requires login access. How can I have the public of a HTML View! Thanks!
Tip for quick record lookups.
Here's a little trick I'm using to speed up subsequent look ups of records on a form. 1. Problem.. You've dynamically pulled in a list of records into a radio box selection. You want to use the selected radio button's value to do a lookup on another record (The record you just pulled in). BUT the value in the radio button is something not very unique like a vanity date or a location or something of that nature. This will make getting that record more difficult. 2. Solution.. Embed the records
Filter dropdown based on previous records
I have 2 dropdowns in my form, when the user selects the first dropdown it filters the second one. What i would like to do is autofilter the second list based on previous records, if there is a previous record then the list will not display that option. I have tried many different code snippets from the fourms and the kbase and can not get it to work... Help please!!! Thanks, Damien.
Newbie - Sort HTML View Script - Examples?
I am new to Zoho and have just started building an HTML view showing a table of wines listing by rating. Can someone help me learn how to use script builder to sort the table by rating in descending order? I can't do this through the normal table view since I am going to use an HTML view to customize the table's appearance. The code I'm using now (minus the css) is below. It's rendering the table just fine, but it's not sorting, obviously. I have no idea how to add instructions to sort this table
Currency field is missing ending Zero.... ?
When values are entered into a Currency field and passed to HTML view, the ending zero is missing - i.e. entered 50 and it shows up as 50.0 I have 2 decimal points (default) entered under Appearance. Any ideas on how to get another zero in there?
Re-arranging left panel of forms/views seen in "access the application" mode
Hi, Is there any way to rearrange the left panel that contains the forms/views in the "access the application" mode? I'd like to group certain forms & views instead of having them in alphabetical order. Thanks for your help!
  showing up in exported data field
I have a test string field that is a person's name. When I export to excel or PDF it now has   in between the first and last name instead of the space. It just started doind it this week. Any ideas why?
Lookup fields and null question help
So I have application Test I have a lookup field Lookup_11 With fields for customer email, phone number ect how do I make this code allow reservations even when some of the fields are not filled out or have a different email or ect that is not in the Registrations table? I keep getting null error messages when I submit the form. rec = Registrations [First_Last_Name == input.Lookup_11]; Email=rec.Email_1; input.First_Name = rec.First_Name; input.Last_Name = rec.Last_Name; input.Phone_number = rec.Phone_Number;
Application will not duplicate
http://creator.zoho.com/rrsaddleclub/test will not duplicate I tried this with another app and it duplicated just fine. What's the fix?
Border color gone in Firefox
In my html views I include table, where I control the border color as follows: #inhalt { border-collapse: collapse; border: 1px solid red; font: 12px arial; } This works fine in Chrome and until recently also in Firebox. But in the newest version of Firefox the setting only controls the outer border of tables. Is this a Zoho bug? See attached picture. Support has edit access to my app (bmpm). Regards, Filip
How to have customer lookup thier purchase? Another criteria view question
Customer view purchase view question, does anyone have example to point me to? so that customers can enter name and type of fruit to lookup their purchase? I would have Two forms and a Customer View Edit Record Fields Enter type of fruit string: type_fruit Enter Your First Name string: first_name Customer Purchase Form Fields Type of Fruit Purchased string: type_fruit First Name Last Name Qty purchased ect Based on the input at Edit Record ( Fields Enter type
Access Form from a different application
Hi, I have a question, is there a way to access a form from other application? I have seek this on the forum and I haven't found anything about this. Please advise if this possible. Best Regards
Changing permisssions of a creator form
Hi we had a staff member leave who had created a form for all of us to use. We still have permissions but is there any way to transfer ownership of the form?
Global Changes
Any way to SEARCH, find a group of records, and then make global changes to that found list, instead of making individual changes to each record ?
how can I add that "+" option allowing user to custom input data for a field?
as topic, when I'm checking some templates I find that it's possible to allow users to enter custom data for a dropdown field, but can't figure out where this option can be found, any idea? thanks in advance :) in case I'm not explaining clearly, I've attached a screenshot for reference.
[bug] updating impossible
Hi everyone ! In the "View" part of my form, when I want to update a result, an answer to my form, I clic on Edit, then Update and it's written "Please wait" during hours so I cannot update. Sometimes it works sometimes it doesn't, especially on IE and sometimes with Chrome. No problem with FF. Does anybody know this bug and can help me ? Thanks !
Time Zone Converter
Hi All, Recently I found a request for Time Zone Converter. But couldn't locate it, just after creating it. Hence posting it as a separate topic. This application 'Time Zone Converter' converts CET time to EST,PST and CET. A Form 'Convert Time' will have the following fields : Name (SingleLine) Date (Date Field) Time (SingleLine) : Can fill it with 24 hour format like 23:45 or 05:00 etc TimeZone (Dropdown having values 'EST,PST,CET') CET(SingleLine) : The converted time will be updated here. It is
Zoho reports
Hi, How can I insert data on Zoho reports and at the same time query that from some application created from zoho creator, Please let me know. Best Regards
Let customers and volunteers create repeating events
HI John, thanks for the date time help! Worked great =) Hi zoho, Do you have any advice on being able to set up events so that volunteers can repeat events for up to two months, weekly, daily or monthly? Or maybe just port the events to zoho cal.. and have them do repeat event from there? https://creator.zoho.com/rrsaddleclub/test/form-perma/Volunteer_Chores_Scheduler/K6fw0pk5bdZ3ZgDJNGgs07u4KpPQx8kbz8RNvqRG1nyzmQaaNjWOzuREXhvaMuCFZmOz1KP2BjZhd4YBrbdqO0wN2xknXqDsD3jA/ ex. on Submit, add records
Hey zoho team! how to add multiple records using script?
Have volunteers that would like to be able to add record per quantity chosen.. I have some ideas below, would this work? is there a workaround? Wonder if there could be if (date of records are between this date and this date), add records from Start date time to end date time.... // check to see if start date is more than end date if input.startdate <input.enddate // calculate the number of weeks, or days ect in this case lets say 7 weeks input.totalweek=enddate-startdate add record 1 input. start_date
Centering Columns and Password Permissions
Is there a way to center the columns? Is it possible to control a user password?
Any ideas on how to get around the restrictive record pricing?
I need to build a couple simple applications for a handful of users. Unfortunately the pricing for additional records makes this project a nonstarter.
disabled Text_Area
hi can u help me i want disabled Text_Area2 or enabled Text_Area2 if i write in Text_Area1
HOW TO GET CONDITONAL VALUE FOR A FIELD
Dear All, I have one Form in which fields are as Name, State, Mobile No. etc... I have done successfully 50 records. Now I have second form As Message in which fields are State, Message, MobileNo First I have select State as Maharashtra, After that I want MobileNo (Text fields) as 9876543210,900000000,800000000 etc. How to get in the value of field MobileNo. for State = Maharashtra in the New form Message All Mobile = 987654321,9000000000,8000000000,7000000000,6000000000,5000000000,4000000000,3000000000
Dates and Days
im trying to write a script where if a persons joining date is 2/18/2011, six months later they start accuring 1 vacation day each month. So far this is what i got: dateDiff = input.Date_of_Joing - zoho.currentdate; If (dateDiff < 180 (refering to days) Number_of_Days_Available = 0 else Number_of_Days_Available = I dont know what to put after that
More decimal places
Hi, How do I change the settings to enter/get more than 2 decimal places in calculations? Thanks!
Accrue Days - PTO
Is there an calculation i can use to accrue days such as vacation days. For example, after 6 months of employment and employee can get 1 vacation day per month.
One field Form1 - Many fields Form2: View a list?
Hi all! That's my brief doubt: I'm creating a database for my phd research. I need to record the title and name author, the important quotes existing in the text and a "keyword". Example: The Lord of the rings, Tolkien, " And then Sauron....", Middle Earth enemies. I designed it like this: Form 1 -- Fields like Title, Author, Edition, Number of pages ... (Bibliographical data) Form 2 -- Field Keyword Then in Form 1 I put 10 Rich text Quotation spaces (Quotation 1, Quotation 2,...) and the correspondent
Set grouping "by exact value"
Hi ZC I'd like to group data from multi-select fields. When we set a group, the data are grouped according to the checked values, separated by coma : exemple on checkbox field with colors : --- blue, white, red (where data displayed are those tree colors) record blue record white record red --- blue record blue --- blue, red record blue record red Is it possible to set a "group by exact value" to have this : --- blue record blue 1 record blue 2 --- white record white 1 --- red
Date Picker - On User Input
I am using two date fields to update the number of nights between the two dates using the On User Input command. Check In: Date Input Check Out: Date Input Nights: Calculated; Disabled input I have error messages and defaults based on upon the user input (e.g check out <> before check in, check in !<= current date). My problem is that when the user selects the date using the date picker. As they scroll through the date and try to select a date the application is triggering these messages before
Help with Date Time Function
Just subscribed to zoho paid subscription. Thanks! I found this post in the forum, is there an example application that uses this function? This would be really useful for my customers. What are some good resources on how to use functions? Trying to get it so that customers can schedule with dd mmm yyy AM/PM and have that converted to date:time that deluge understands, then be able to add one hour week ect for the end time based on their choice for calendering purposes. Is it possible that separate
Lookup list not sorted
I'm using a lookup field to a table with 355 records. Even though Show choices in alphabetical order is checked the items are not listed in order. Approximately the first 200 show correctly the rest are random. I did add another display field under Advanced display options but then took it out. Is this a known bug? Herb Wexler
Firefox 4 support
Firefox 4 was launched, but unfortunately the most advertized Zoho Creator part - fields drag and drop - does not work on this much improved version of Firefox. So I would be very happy if this aspect will be solved soon, even if maybe the full official support for Firefox 4 is a long term task. Is there a chance that at least the fields drag and drop in Firefox 4 to be supported very soon? Regards, George
Next Page