Do I need a new view or a new app?
I have a database with each record being a family Parent 1 Name Parent 1 Date of Birth Parent 2 Name Parent 2 Date of Birth Child 1 Name Child 1 Date of Birth Child 2... Child 3... Child 4... (there a maximum of 4 children at present). + Address details, phone numbers etc. I export this to an XLS and then use Merge in Word to create a nice PDF of a family address book for everyone, in alphabetical order. Now imagine I also want a second view/exported XLS which just has a big list of Parent and Child
Custom Application for Creator
I need help creating a custom application for Creator. I would like to hire anyone proficiant and need the project completed immediatley. Please contact me emmett@padremortgage.com. I will send over a file that describes the job. Please respond with any questions and a bid for this work. I have included an attachment of the supporting documentation of the job. Thanks, Emmett
Login for Outside Accessing
I am wondering if there is a way to password protect my database when I make it public so my students can access my database and be able to submit their entries :!:
OpenURL to show limited results for entire day.
I want to see the days schedule so I am building the below url. The time >= and <= is nor working for me. It is returning all days. I just want the one day. I could switch to a just day field probably but it seems like I should be able to do this with out the extra work. http://creator.zoho.com/xxxxxx/rooms/html/Reserve_a_Room_View/Room=102 - East Conference Room&Start_Time>=02-21-2009 00:00:01&Start_Time<=02-21-2009 23:59:59 Any suggestions, should this work in zoho?
View link
Is there a way to change what "view" pops up when clicking on it in the list view. I'm making a contact database and would like Sector and Company to be on the main list view. I then have an individuals contact information for each company which I would like to pop-up when clicking on "view" rather than it just popping up with sector and company. Any help would be greatly appreciated. On another note, I'm not too experienced with Zoho creator and any help may need to be in a step-by-step form. I've
Error adding issue in Issue Manager
I am unable to add new issues in Issue Manager. The operation gives me feedback that it has succeeded but if I click on the "Show Log" link I read the following: Error occurred while executing on success script Unable to send mail Invalid Email address found
Display distinct / unique values in lookup field
Hi, I have the following in Form1 Author Book title Sometimes, i have more than 2 books submitted by the same author ie -- Au_ABC --> Book_abc Au_123 --> Book 123 Au_ABC --> Book_a1bc In form 2 i want to use a lookup field to pull the author name from form 1 Nomal lookup displays Au_ABC Au_123 Au_ABC.. where as I want the list to show Au_ABC Au_123 I am not sure what to give in the criteria filed. Please advice Thank you, regards Deepa
Spreadsheet vs. Grid view
The UI in the designer uses the word "spreadsheet". I have a view set as spreadsheet, but it is rendering as a list. Why is this? What are the limitation of the spreadsheet view. I'm assuming that I have a field included in the view that is forcing it to switch from the selected spreadsheet view to a list view. But, when I search help for spreadsheet view I get no hits. Frustrated. Only after spending too much time search did I learn that the help files use the term "Grid" view. This is very frustrating
Grid View not saving data when edited
I'm the administrator and have the "allow edit" checkboxes checked...I have edit fields in my grid view, but when I make a change it doesn't "stick". I assume I don't need to hit "save", right?
Problem with apostrohe in lookup fields
First: thank you so much for Zoho Creator!! Than: when I choose data with an apostrohe in a dropdown list, the record will not update. Apostrophes are used very often in italian language, even in city names... grazie Lucia zoholucia
Creator Export
I still can't export my view to excel using the Creator export function. I was told previously that because I use VISTA this functionality was not resolved yet. Can you please give me a time frame in which this issue will be resolved? Thx. S.
Re-organising data into new records in Dynamic View
Imagine a family database with this sort of data. Record 1 Parent A's name Parent A's Date of Birth Parent B's name Parent B's Date of Birth Child A's name Child A's Date of Birth Child B's name (etc.) These records also have addresses and telephone numbers etc. This is great for the first part of my needs - I export to an XLS and then merge it into a Family Address Book Word doc, which I export as a PDF. However, I would also like to create a Birthday list, sorted by date. I guess
PayPal Hack 26 January 2009!!! UPDATED
i have tryed using this program several time and ben unsucessfull please help
Please help. I Can't understand how to make formula work!
I keep getting error messages that either variable form is not declared or something or other is not declared. All I want is a field that would count the number of times a name is listed in another field. Can someone tell me how to do that? It's simple to query in access but I am finding Zoho creator too hard. I don't know scripts. My son insists that I should stick with access. I would except I need the database online. Please help. I've spent too much time already trying to figure this out.
((((((((((P)a)r)e)n)t)h)e)s)i)s)
Zoho Creator team. Please stop abusing parenthesis. We developers understand if you need to group things. But do you have to modify our code when it is saved with more parenthesis than needed. Check out my nice little criteria for a view i'm working on. I would really like to change this. But where do I start? I spend more time counting your parenthesis and matching them than I do writing my own code. ((((((Completed is null) && Task_Type != 1) && DealStatusTEMP != "Seller withdrawn") && DealStatusTEMP
CustomAction: how-to update a value of a field when executed.
Hi, sorry if I ask a simple question but the manual/help, about that feature, seems not completed. I want to launch from a view a custom action. I need to send an email to the contacts of the selected list (simply to do), but I want also to *add* to the note field contents a detail, x all row, of the datestamp of executed command. e.g expected result: Name_Field===|====NOTES_FIELD=================| Mr. Cannewson | Address checked; confirm email: sent on 5/5/2009; -----------------------------------------------------------------------
Currency appearance
I have a currency field in my database, and the values appear with only one decimal place. The appearance option is set to 2 decimal places. How can I correct this?
Create Buttons in Forms and Views
I can not seem to be able to create a button to advance to the next record, or go to the previous record. I would also like to have a button to switch between forms and views.
Exporting Data to Excel/PDF
Hello, Whenever data is exported to Excel/PDF all the blank numerical value show up as 0/.0/.00. This problem only started showing up after the Zoho update. Please Advice. Application Name: NorthShore Web-Enabled Water Management (Shared to Support) Thanks
Unable to add user even after upgrading!!!!!
I upgraded from free to $15/mth in order to enable 3 users. However although the settings agree that I am now on a 3 user plan when I try and add a user the system just tells me to upgrade!!!! Seems that in this part of Zoho the "right hand does not know what the left hand is doing"!
Custom action: attribute a ticket to someone else?
Hi, I have the following form: HD_INPUT_FORM with the following field: USER As an admin I can edit a ticket and change the User to any of my colleagues. But as a user they cannot./ What form should be the custom action? int? bool? void? Let's say I have 4 users, do I need: Custom_action_A = Attribute_to_User_1 Custom_action_B = Attribute_to_User_2 Custom_action_C = Attribute_to_User_3 Custom_action_D = Attribute_to_User_4 Many thanks
Is Barcode possible
Hi I wondered if ZC somehow supports barcodes? BR Dennis
Error in View
Hi Support, Please advise why I received an error every time I set the criteria on these two fields on view: Contributor_Type == "Prospect" && Status != "Deleted" Error Msg: We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com. The application is named Northampton Miracle League. The views are Prospect List & Individual Contributor List in Leads & Contributors tab. I've shared the application w/ Support. Please advise.
Error Importing Data
Hi Support, There is something really wrong with importing data; it's all the fields are empty after importing or there's error & cannot import. Please advise. Thanks
Cannot Open Event Form
Hi Support, Please advise why I can't open the Event form in field edit view? The application is Northampton Miracle League. Thanks,
Speed
I have used it for my small business. My users are very interested in knowing whether the system will slow down when more and more data are loaded. Thanks,
HTML View code gone
Hi, I'm working on an HTML view, and when I went back to edit the code, there's nothing there. It seems like the view itself is still there, because when I refresh the page to see the result I'm getting the same error message I had before. If I click on the "Free Flow Script" tab, the error is: Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. This is also true for the other HTML view I started yesterday and was able to edit this morning.
ZohoCreator Maintenance - Feb 22,2009 (10:30 PM-11:30 PM PST)
Dear Users, ZohoCreator service will not be available for one hour on Sunday, February 22, 2009 from 10:30 PM PST to 11:30 PM PST due to maintenance work. We regret for the inconvenience this may cause. Regards, Karuppuchamy
Slider and Spinner UI widgets for Numeric fields
Good afternoon... I just had the thought that it would be cool to be able to specify the type of UI widget for Numeric fields (number, decimal, percent, currency) to be one of: *  single-line edit (this is what it is today) *  slider, i.e.: grab the handle and slide it left or right to adjust between a min and max value *  spinner, i.e.: use up and down arrows to adjust the value (not necessarily, but possibly, a min and max) I just think that would be kind of cool. Thanks,
After upgrade from free, still not allowed to add user!
I had a free user account to investigate the system and I had two users shared. We decided the system was going to do what we needed so I created a new account (mainly so that notification emails would come from a more appropriate address). However I was caught out by the change to the number of permitted users which I only found out about in retrospect by reading the forum. So I upgraded to the $15 / month option and the settings on my account info changed to show that 2 more users were allowed
Slow Server Connection crippling my use of Zoho Creator
Hi, Am I the only one who suffers from an extremely slow connection when accessing Zoho Creator? Its odd because it only affects me when I try to access Zoho Creator from Work. Its not only creator that is affected but it is also the forum and as such I am writing this post at home because the connection is to unreliable in work. I can't work it out. I access the internet through a corporate network connection. I did a speednet test this morning (9 am GMT) to check the speeed of the connection
Backup Failing..
I'm getting this error.. com.adventnet.persistence.DataAccessException Can anyone help? Thanks!
Backup failed : DataAccessException
Hi, I can't succed to backup my data, I get the message "com.adventnet.persistence.DataAccessException" I had a problem with a Form a few days ago, every information on it "disapear" and now I can't delete it. I create another form and view, and dont need anymore that form. Is there any relation between these two events ? Thanks for help. Philippe
Zoho Creator Maintenance - Feb 20,2009 (9:30 PM-10:30 PM PST)
Dear Users, Zoho Creator will not be available for one hour on Friday, February 20, 2009 from 9:30 PM PST to 10:30 PM PST due to maintenance work. We regret for the inconvenience this may cause. Thanks & Regards, Balasankar.
Formula with <IF>
Hi, I cannot define a formula with a simple structure as this: I need that field contains "Dog" if another field is "Yes" or "Cat" if is "Not" FieldWFormula ( type = formula private = true if OtherField == "yes" { value = "Dog"; } else { value = "Cat"; } ) But it not works. I think to use a
Create Mail Link in View
I like the function buttons on each item in the Views and would like them to allow a person to automatically send an email that includes the ID of the record to report an error with it (missing or inaccurate information). How would I go about doing this?
Clear Checkbox list on Edit
Hi All, Me again: How do I clear the checkbox list that I have on Edit? Thanks, Jason
Invalid entries found. Please correct and submit again
I am receiving this message when I try to update a record from a Summary view: "Invalid entries found. Please correct and submit again" The following error message appears in red at the bottom: [t_294375000000011009_PIDX] Exception occured while inserting rows Failed to update data. This occurs when using "Summary Form". I have had some success updating a text field on its own, but the problem occurs when I try to update multiple fields (have not thoroughly gone through all of the possible combinations/options)
Problems with Embedded views permission in IE
Can you help me with this one. I have created views within creator that limits the user to just adding records. I do not want to to delete, bulk delete or edit. I set the permissions to this extent in creator; I add the iframe to my webpage and then test in both firefox and IE. The views show correctly within firefox but incorrectly in IE. The user in IE can Edit, Bulk edit, and/or delete which is not good. Th permisssions do not seem to work in IE. Is there a work around to this problem?
Problems with embedding views within a webpage viewed in Internet explorer
Can you help me with this one. I have created views within creator that limits the user to just adding records. I do not want to to delete, bulk delete or edit. I set the permissions to this extent in creator; I add the iframe to my webpage and then test in both firefox and IE. The views show correctly within firefox but incorrectly in IE. The user in IE can Edit, Bulk edit, and/or delete which is not good. Th permisssions do not seem to work in IE. Is there a work around to this problem?
Next Page