Scripting help please
Hi, Probably a mistake on my part but I am having trouble with a specific scenario. 2 of my applications forms interact very simply. Form#1 (Bookings) stores details concerning future events. Each record has a unique reference (REF = an incremental ID number), some basic labels and most importantly a START and FINISH time (fields are date+time). Essentially this form stores room booking information. Form#2 allows a user to select some details from lookup fields that hook into Form#1 and return basic
HTML Permalink Without Login error
Hi The permalink on HTML views without login is not working, it asks for login no matter the code was created using the no login option
URL to pass search criteria other than exact match ...
Hi: I am trying to navigate (via script) from the Click section of a Stateless Form to a List View ... and specify a Criteria based on data entered in the Form ... I know that I can do something like ... openUrl("#View:Staff_Records_View?StaffName=input.StaffNameEntered", "same window"); ... and it works ... i.e. it displays the View for the records where the StaffName field contents is exactly what the user entered in the StaffNameEntered field of the Stateless Form. My question is ... is there
Create multiple forms updating data in a single table
On this page "creating dummy forms" I found that it is possible to create multiple forms updating data in a single table http://creator.zoho.com/help/deluge/dummyforms.html but there is no real explanation on HOW to do it, or are my eyes bad already? Flo flozombie
Covert strings to numbers, then add total
OK, I'm a moron. I've just spent 4 hours trying to figure out how to convert several strings to corresponding integers, then add them up for a total. Sigh. I'm sure it's painfully simple, but I just don't get this scripting stuff. Pretend I have Judge1 and Judge2, and each goes to an already existing data record to vote on the proposal contained within. Each has a field with their name on it, and a set of radio buttons with 3 choices-- "Bad", "OK" and "Great". When Judge 1 selects "Great" I need
Looking Up a Field from Another Table
Hello, I have two tables, Table #1 and Table #2. I am essentially using Table #1 to add a person to the system... and Table #2 to add notes linked to each record in Table #1. So "Bob Jones" may have 30 different notes about him in Table #2. "Sally Fakeface" may have 7 notes about her. Now sometimes, when Bob or Sally are acting up, a note may need to be made on them that also contains a "Status Change" flag. This would be so that we are able to track a history of the person fluctuating from the status
can't load my form
I just created a form, but when I tried to change the name of it, it ceased to be able to show it to me! I can see the form layout, and the data it has collected, but I cannot access the form itself to see what it looks like or add more data
Picture file in linked form produces error not download
I have a view that pulls in a upload/download field from a related form. When I click on the uploaded file I get the "You are not authorised to access this in Zoho Creator. Go to Home <http://creator.zoho.com/>;" page. Is this a bug? Is there a workaround? I am the owner of this application so I should be authorised to access it. When I go to the view that has the field in it, the download happens without a problem.
Questions and Thoughts on Usage Limits
Hi: Are the usage limits displayed under Account Settings >>> Usage Limit the same for all accounts ... no matter what plan the account is subscribed to ... or does it vary according to plan ? It does not seem logical for an account subscribing to the 100 User pack to get the same resources (e.g. xxx Emails per day) as one subscribing to the 5 User pack ... assuming that the usage is tailored to a plan ... a) can we all see what usage limits are available with each Plan ? b) does it make sense to
Insert Data Into Form From NetGet
Hi Support, Is there any way to insert data into zoho creator form such as below using NetGet and POST type in other private application: http://creator.zoho.com/egressmedia/crm/#Form:Test?Added_Time=timestamp&Account_ID=12123&Phone=2222223333&Service=Marketing Please advise a solution to the issue. Thanks egressmedia
How do I set a Primary Key
I would like to create a Number field with a Primary key and have it auto populate with a number (of course - no duplicates). How can this be done?
Set Criteria which select entries based on another view
Hello A need to create a view which display only data which has the same match field that exists in different view. Form A: Vendor_number User_email_address (where I enter the email address for people I'll share the app with). Examples: 10, smith@domain.com 20, charles@domain.com 10, book@domain.com (note that vendor 10 appears twice since I share the app with two different users) Form B: Vendor_number Product Price I would like to create a VIEW in form B which select all entries which have vendor
Business Free Version 'chucked out' since when?
Hi Wizohoes, Apparently I have not visited the price plan page for a long time, and I'm unaware of the date when 'Business Free Version' has been removed. I only found information on the sticky dated June 2008 about the Business version coming out and SSL being paid for, including rebranding etc. When did the business free version stop. (because if I got it right, SSL will continue to work for 3 months since that date) As I have been trying out SSL on some of my apps. How much time do I have.. Thank
Filter dropdown list
I have a list of about 150 names. On a transaction form the user uses a dropdown to select the appropriate name for the transaction. With this many names it is cumbersome to find the correct name. If a few letters can be entered in the field before clicking on the down arrow then only names containing those letters would show on the list. If an exact match is found then the dropdown list will not show and the focus will go to the next field. If this is not possible are there other suggestions for
Calculate date excluding weekends
How would I go about adding or subtracting a certain number of business days from a date (excluding weekends)? hesadanza
Creator Mobile - Record in Views NOT displayed
Hello, It is impossible to view the records of a table in Zoho Creator MOBILE !! (cf. attachment) So how can we say that Zoho Creator has a mobile version ?? the main point of a database is to display the record, no? What am I doing wrong ?
Unable to send email
http://creator.zoho.com/kriswasserman/copy-of-everest/view-perma/JOB_LIST/ "Error occured while executing on success script." "Unable to send email" "Error on table null" I've created a form (Job ticket) that is supposed to send an email with the form data via email. However I keep getting the "Error on table null" message. This started happening recently, so I suspect it is due to something that I did as opposed to a ZOHO malfunction. What am I doing wrong? kriswasserman
Payment Options
Hi All, Just wondering if anyone has used a ZOHO creator form and once someone submits to your website is it possible to add a payment gateway in the thank you page so that they can then make payment.. Would appreciate the help..
Form Layout ...
Hi: Don't know if this was ever suggested before but ... a) Would it be possible to enable developers to specify an alternate layout for Form entries ... instead of ... First Name: .................John Last Name: .................Smith Age: ...........................102 ... how about ... .................First Name: John .................Last Name: Smith ...........................Age: 102 ... or even better ... First Name: John Last Name: Smith Age: 102 ... where the dots represent spaces ...
Records showing several times
Hi I ahave a view showing only cust ID/name/telephone/email of customers, trouble is, I get as many times the same cust ID listed as the number of times we opened a ticket for him. ie I have a view like this: Cust A - Name A - Tel A - Email A Cust A - Name A - Tel A - Email A Cust A - Name A - Tel A - Email A Cust A - Name A - Tel A - Email A Cust B - Name B - Tel B - Email B Cust B - Name B - Tel B - Email B Cust B - Name B - Tel B - Email B Cust B - Name B - Tel B - Email B and so on.... How can
Creating a Search/Filter Form
Hi All, I have been trying to use the search and filtering methods in a view which typically has the entire list of all records. Now I have quite a few records and intend to keep on growing the amount of records in the database. I am looking for an easy way to search for a group of records or a specific record and thought this may be possible by creating a form that can almost replicate my Form 1 which is adding details, but instead of adding I want the form to search. Is this possible? Thanks, Brandon
Not show hidden data in send mail script
Hi, I have a few Public fields and few hiddden fileds Name - Phone - email - are shown in the form AdminComments - is hidden and i update it via View Edit. At form--Add--sucess , I use the "send mail" and use input.formdata to sent all the info. .. kind of datadump. The final data that is sent also contains the Hidden field ( albeit empty) Is there any way to "not include the hidden filed" in the mail. (the above is a sample appliction. the actual application has about 15 feilds. So cant really add
Excel Download
On the main view of my database, when I click More Actions>Export Data>Spreadsheet then click Download, I get the error "Internet Explorer cannot download MY_VIEW/ from creator.zhoho.com. Internet Explorer was not able to open this Internet site. the requests site is either unavailable or cannot be found. pleas try again later." My view is private, but I have clicked on the option to not prompt for a login. sigroup
Continious refresh at permalink
Hi, I have a form with about 15 - 20 fields and the users are provided "permalink" to the form When the data is added via permalink & submit there is a continous "page reload". Could this be due to the large number of fields. if so, how can i fix this. its really tough to remove some of them. Please advice Thank you, Regards Deepa
This view won't let me use the Chart option
I have a view that for some reason I can't select the Chart option. I don't know if I'm missing something or if this a bug. Here's the link: http://creator.zoho.com/edsilva7/pagos-personales/view-perma/Deuda_Total_Mensual_View/GxWC2FkRO6qNwXH42eP2OnBum7RnYE5eC97u9KtqTn6UsRpetK3ChFKb5uEYNKm8XMmAC0QC1aqM9aRzTEUOPD5FGC6uCB9A7DpX Regards, Ed Silva. www.ChristianMembership.com www.ContenidoCristiano.com www.Top40GPS.com edsilva7
UPLOADING PICTURES
I am unable to upload pictures. Why? They are well below the maximum size limitations. Don mail
When will we get a rich text fieldin creator?
How long will it take to get a rich text filed as type in the field list of zoho creator? (WYSIWYG Editor Field) expert.ict
Everything is blocked
Hi I cannot add forms, or create applications. I guess this happened after some corrupted data. What can I do?? HELP PLEASE coralio
Cannot duplicate
Hi!! I cannot duplicate my app. At some point, the data in one of my tables (Events) was corrupted and I am not able to duplicate it. Is there anything that I can do? Thanks so much coralio
data not adding
some people are not getting the "data added successfully" message when the hit submit, and their info is not added to the data base. Others have no trouble at all. How can I make this work for everyone? russrosen
Problems with subform links in a html view
I have a new html view in my app that list a few contacts. Each contact have his/her projects. To see the contact's projects you can click on the field Tareas that in fact is a subform link (it's a formula field), like this: ((("<u='#' onclick=\"window.open('http://creator.zoho.com/" + zoho.adminuser) + "/app-coin/view/EProyectos/criteria/Cliente=") + Nombre) + "/','popup','width=900,height=400,location=no')\">Ver Proyectos" The problem is that this link doesn't works in my html view. The field name
Using Zoho Creator -- Cannot figure out how to export the da
I am using Zoho Creator to create a database to use with a research project. Previously, I have been able to export the database file to my hard drive in a variety of formats. Now for some reason, there is NO OPTION at the top of my Zoho Creator screens that allows me to download (export) the database to my hard drive. Surely, I am doing something incorrectly. Please remind me of the steps needed to download my database to my hard drive. I want to keep my files backed up outside of Zoho Creator.
We are unable to fetch this data, sorry!
Hello, I am using a new application, and when I want to view the data I am getting this message: We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com. Can you help me? floxoip
RSS Feed for individual Forum Topics
it would be great to have the ability to track a particular Forum topic in Google Reader or what ever RSS reader one happens to be using.
Dynamic view based on login
I have data that I want to share to certain people but is filtered through their login. For example, all these people would see the same fields (i.e. Name, Address, Telephone Number) but the records that they see would be dependent on who is logged in (i.e. Bob can only see the above fields for the people who were born in 1989, Jack can only see records of people born in 1990). Is it possible to create a dynamic view for each person based on their login? I know that I can create a view for each person
HELP! The Contact Form is stuck in Loading Stage
Hi Support, Can you please reset the application Sales Management System? The contact form is stuck in the loading stage. I've shared the application w/ support already. Thanks, egressmedia
New forum member Max
Hi guys, just want to introduce myself on forums.zoho.com, hope "Creator Feedback" is the right category for that purpose. Greez, Max
Search not working
Hi, If you look at my application http://creator.zoho.com/leejordan/test/#View:Election_View and try to Search for something on the 'Elected Region' or 'Elected Hub' fields then you get an error "We are unable to fetch this data, sorry! Please note that your data is SAFE." The same happens if you search on the 'Electing Region' or 'Electing Hub' fields. In the Election View these fields are referenced from the relevant Operator record. I have shared this application with Support. It would be great
zoh creator is slow
Hi I find that since zoho got a new look a number of weeks back that is has slowed a lot.it takes a lot longer to add records.is there a reason for this and is there any way to make it faster,by selecting a different theme or something?
Email with Multiple Records
I am making an addition to the IT Asset Manager. I am trying to add an email feature that will email employees a reminder when their hardware is overdue. It currently sends them the email with multiple records seperated by a comma. Is there anyway to get it to put a return between each record? For example, this is what the email looks like as of now. The following items are overdue. Please stop by at your earliest convenience to have them checked and reissued. RECORD1, RECORD2 Sincerely, Justin Bledsoe
Next Page