Reverse lookup from child to parent
In my app I have a list of Parents, each of which is linked to one or more Children through a multi-select Lookup field in the Parent form. I can make views based on Parent, which can show values from the Child form as well. This is excellent. However I also need some views based on Child, which show each child in a separate row, with their Parent's name and other information. To work around this I put a single-select Lookup field in Child that links back to the Parent, but then when creating a new
displaying an image which you uploades with file upload?
Hi there. How can I display (on the view) an image I uploaded using the form i created? I'm trying to create a list of used cars and display pictures of them. Thanks.
Need help to make a view read only - please help
Hi. I want to make a view -- read only. (No adding or editing etc.) How can I achive this? I have tried: Actions -> Set Permissions -> add/edt/delete - <uncheck all boxes> ... but this still seems to leave the view editable. Please help. Thanks.
Database Creation
When I try to import data into the database, creating a new application, it asks me to Click FINISH when done, however there is no "Finish" box present to click. timholt
Can't import - Error message
Went to my form Selected more Actions Import Data Pasted my .xls data Pressed Upload and got this error: Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. salsababies
Creator - can't see my forms/view
When I logged to Creator, all I see is a black page. I can't see any of my forms(4) or views. Is this temporary? salsababies
String index error solved-ish
Hi, I asked why I was receiving these errors when submitting certain URLs. I know now that it has nothing to do with the URLs, it's the text used to link them. On each occasion the field contained the word 'target'. My best guess is that Zoho thinks I'm trying to enter HTML code and is getting confused. If you abbreviate the word or omit it altogether the problem goes away. dreamkatcha
Can't edit notes
Hello. I added a note in my application to explain to the user what to put in a field. When I tried to edit the text of the note I got this error message: "Error Occured. we are sorry for the inconvenience. Please try after some time or refresh the page and try again." I shut down, and try again later many times but it still gives me the error. Any ideas? Thanks!
Constant Creator Downtime
Any idea what's been going on the last couple of days? We are constantly having trouble accessing our Creator database. The last couple of days have had very intermittent connections to the server. All other websites work fine.
Great help to prints
Hi I think it would be a great idea to have a "print" tab in the "record summery" just beside the "edit" icon. This would be a good an easy way to print my information. Today I copy and paste into Word in order to have a proper look of my prints. BR Dennis
Trying to create a squash court booking system
Trying to create a squash court booking system - Are there any templates available for such a Booking System or a simple Resource Booking system. All my app has to do is to have a form for people to enter details, dates , times opponents and then check that no one else has booked the court on that day at that particular time - later on I want to add functionality to enable membership number checking so only members can book but at the moment all I need is something that checks court availability
Errors when trying to update
When I try to edit a row and I click on UPDATE i get the below error. [t_101075000000093076_PIDX] Exception occured while inserting rows Failed to Update Data. Sometimes it works and sometimes it doesn't. Lately it is mostly not working. Any ideas? cindychoi108
HOWTO: "LOOKUP FIELD A" limits picklist in "L
app: "http://creator.zoho.com/kwasserman/shared form: Job_Tracking (display name = NEW JOB) SITUATION: The first field in my form is a picklist field named "FIRM" that pulls the abbreviated name of a company from the "FIRMS" form. (FIRMS.ABBREVIATION). The second field is a picklist feild named "Master_Project_Number" that pulls values from the "MASTER_PROJECT" form. (MASTER_PROJECT.MASTER_PROJECT_NUMBER). What I have been trying to do, but can't seem to figure out is how to restrict the list of
How to wrap-around the description of the fields
I was instructed earlier to use " " (less than br greater than) to wrap around my description fields. It worked great until yesterday. Now my field description has the brackets and the br in it where I want the wrap around to take effect. Is this a system problem or something that I should be doing differently. salsababies
Form has crashed
My form and dataview have crashed! The error now says that no form can be found at all! I was in the middle of a survey when this crashed -- please help me recover the data! budcaddell
howto have unique ID Number for each record
Hi i have made a database input form using creator application form to maintain record of the course participants that i conduct. I want to give a Unique registration I.D. number to each applicant . eg. . I.D. # NAME 001-2008 John Sane 002-2008 Amber sirf 003-2008 Extril nom I want each to have a permanent ID number to track them. can anyone tell me how to increment those ID. #? any code where to put how to do it.. Thanks in advance..Please help
Copy an application that's shared to me
Hi there, I'd like to move an application to a different ZoHo user account. This is because when a confirmation mail is sent, I want the mail to have a different 'from' address than all the other applications in my own account. I've created the second account and given it the right adminuser email address. I've shared the application from my main account to this new account. Now I'd like to be able to copy the application that I shared to this new account, so that the new email address becomes the
authorizing users
We'd like to create a database of contacts where each contact can log in and edit their own entry - but only their own entry. So some sort of password system would be needed. Is this doable in either ZOHO Creator or ZOHO DB & Reports? Thanks, Ted
how to cut down a long survey created in ZC
Hi. I'm building a market survey on ZC. My survey seems to be too long. So, how can i break it down in 2 pages (or more) without the "submit" button on each page ? Thanks. armellaminsi
SSL Coming Soon
OK Charles answered my other post that SSL is coming very soon like in a week or 2 or 3 days or something so I thought I'd post this new topic subject in case people looking for SSL get discouraged by my other subject.
No SSL, going to buy Caspio Bridge
Ok I realized I can't wait for SSL because I need to do subscription renewals online next month, so I decided to ditch creator and go with Caspio Bridge www.caspio.com Caspio Bridge is pricey, $8 per data page per month, but it's worth the SSL and it's cheaper than my Verisign cert! HAHA!!! Caspio Bridge also has DB and reporting integrated so it's got all the essential business functions I need. Also you can use an MS SQL db so maybe we will to try to dump our QuickBooks db to an MS SQL db with
Desperately seeking SSL
I would like to add my voice to the people who need SSL. So my bad, I created 3 applications to register people for classes in which they input their credit card numbers. Even though the vast majority of the people are technically challenged, i.e., grandmothers, health care workers, HR workers, etc., much to my surprise, many of them will not register online because they can see it is not https and they see that it is not secure. I would be very happy to pay for SSL and to pay for a business version
Creator will not import data
Tried many times, in both Firefox and Safari. My tab-separated data seems to be properly digested, but there is no "Finish" button displayed. Therefore I cannot comply with the directions which say "Click 'Finish' when you are done." Therefore, the new database is created with only a name; no forms, no views, and no data. bobsc
remove the dite button from the view
Hi! I would like to remove the edit button from my form so that view cannot change the data.how this can be done?I simply want the viewer to read the view without getting any option to edit any data
problems with "set criteria"
Hello i am trying to set a criteria for my application "crew track records" criteria should be "TYPE" contains "C680" for the view "all C680" but it just says "Adding Criteria failed. Please try after some time or refresh the page and try again" any suggestions? another question. I have tab view but I would like to have like 3 main tabs and then many tabs under these tabs. Now I can only do a horizontal line of tabs. is this possible? efspilot
Can't save in spreadsheet view
Hi, After editing cells the save button remains greyed out and so it's impossible to save my changes. I'm using Firefox 3.0 beta 2. Any idea how to fix this? Regards, Rob dreamkatcha
"Import Data" button not working - Zoho Creator
Greetings, when clicking on the "Import Data" button nothing happens. I am unable to import external data into my private application "Best Climate". I have tried in Firefox2, IE6, IE7 to no avail. Steps Taken: - Go into my form - Select "More Actions" - Click on "Import Data" By the way, the other two options under the More Actions menu ("Embed in your website" and "Permalink") are working. Please help. Julio.
API support for comparing financial products in India
I want to create an application where the readers of my site are able to compare financial products in India. I am a 40 year old newbie to coding and I love the easy interface of Zoho Creator. But I was apprehensive of whether I'll be able to do it on my own. Till I saw the API support. What I want to do is this: 1. Create a database of financial products in various categories like Insurance, Mutual Funds, Stocks, ETFs, etc. 2. Create a form for readers to search for products under various categories
Data from 2 different views deleted at the same time
Hi, I wanted to create 2 separate views on my Social Network Application, and have different field on each. But when I deleted some contacts in one view (Fitness Social Networking) it also deleted them from the other one (Social Networking), and I didn't want that data to get lost from the other view. The fields where social and bookmarking. Can you please help me to get that data back!? I will really appreciate it. fitnet
"Update Records" in Script Builder Hangs
Regardless of what form I am working in, when I add "update record" to a script and go to edit the script it dims the screen gray as if it is about to load the dialog box and then just sits there and does nothing. I am forced to closed out my browser and log back into my database, but it still does not work after that.
Zoho Creator Maintenance - Jan 10,2008 (8:30 PM-8:50 PM PST)
Zoho Creator will not be available for a short duration on Thursday, January 10, 2008 from 8:30 PM to 8:50 PM PST due to maintenance work. We regret the inconveniences caused. Thanks, Suganya.
Subforms?
Zoho Creator is very cool! While attempting to do a quick demo, it occured to me it would be very useful to be able to do forms with one-many relationships - example would be a meeting tracker with an attendance list. You would want to enter data about the meeting (time, date, subject, etc.) then have a sub-form or embeded form that allows to enter attendees. This would represent a one-to-many relationship in the backend datastore. It there anyway to do the above now? My attempt has two forms where
Creatung a record on input, then checking it on submit.
So I'm not sure how to do this, wondered if somebody could give me a hand. Essentially I'm trying to create a signup sheet that will be used daily. Somebody picks what they want to sign up for, from a list, then when they submit the form it assigns them to that item. If somebody else tries to sign up for it, it will tell them that it's not available... or if it's possible, not show up as a choice? Also, if this could be related to date, so say, person A has item 1 on March 1st, then person B has
Sorting anomaly
I've got a column that won't sort as expected. If you look here: http://creator.zoho.com/ffg/who-shot-the-sheriff-/view/15/ the Character A column, when you click on its head to try and sort it, instead it actually sorts by the Character B value instead. (I've allowed edit access to support.) best wishes, Mo ffg
Date fields + Formulas
I have a date field st_Contact_Date which a user enters a date into. I need a formula to add 30 days to that date and to populate it into the field Expiry_Date I have followed the instructions in the deluge help guide to a tee however I keep getting the following error: Encountered "type" at line 3, column 1. Was expecting one of: "this" ... "input" ... "TRUE" ... "FALSE" ... "groupCount" ... ... ... ... "count" ... "empty" ... "null" ... "exists" ... ... ... ... ... ... ... ... ... "(" ... ")" ...
You are not authorised to access this form in Zoho Creator.
hi I have a dozen user but only two receive this message the e-mail address is correct - so, what can I do ? for all other features no problems just the creator thanks john
the upload field problems
It seems that the uploaded file (a simple .txt file) didn't save in recipient table of the form. Please help me! Best whishes! dansimaster
Editing label names has no effect
Hello, I created a form. Then looked at the application view and it looked fine. However, if I decide to make some edits and change the label name (on the Form tab) I noticed that the Application View does not reflect the change on SOME of the changed fields. Also, when I go into the "Access this Application" I notice that the changes are also not reflected. Anyone else experience this?
Wonderful service
This Rocks superhudson
Zoho Creator Import prob w/ cvs file
When I try to create a new database by importing a .cvs file, it tells me to press "Finish" to finalize the database...but there is no "Finish" button on the page. Am I missing something? jeffyboy22
Next Page