___How to "set Email Notification" in VIEW when in EDIT form
Hello, When editing a FORM there is under "More Actions" the "set email notification" when data is submitted and an email is sent out automatically. Can that be done in a VIEW when click on Edit and form pops up for data input... when that data is saved can an email automatically be sent out just as is in the "set email notification"? I noticed the Views Configuration has "More Actions" but doesn't show "set email notification". However, on the left panel under "Actions" / "Custom Actions" can
Preview Email
Is there a way to preview an email before it is sent? We would like to see if everything is included and formated properly before it is sent. Any plans to add a table to an email? This would help keep everything nicely aligned. Herb Wexler www.PreventingMediocrity.com
Move Save Script button to Left on Form Edit
Sometimes the Save Script button is off the screen. Having it always on the left would be useful. Herb Wexler www.PreventingMediocrity.com
api ticket field is blank message?
On submitting my form i got the following message in my log. What is all this talk about ticket field being blank? I assume it has to do with my api settings but everything seems to have been sent properly from creator to zoho invoice and i dont see any problems. This is happening in my submitted grant application. I tested the app a few times with no problems then all of a sudden had this message, not sure what if anything changed. On success - log messages: Record(s) added successfully1879870000000700012010-09-23
Calendar Form
In Creator you have a template for a contact form. A calendar form might be a good idea too.
Settings not saving
Hello, I have started on a new revision to one of my applications. "Tool Tracking v2" In form "RFC 5x5" there are two fields that I can not get my desired settings to save. First field: Description: Unable to save the Initial Value, or the Hide this field to others option. Second field: Part Number:Unable to save the Initial Value, or the Hide this field to others option. This feature is working in other forms with no problems. Edit access is already granted. Please Advise. Jason Rapp
Creator email notification
I created a form on my website for contacts and calendar requests. In the email notification, can i create a script that would add the new contacts to my contact list and add a new calendar request to my calendar?
view mutiple related fields?
I have one form, Called "Contract form" with one mutiple lookup called "delivery n°" the "delivery n°" form have some info like, quantidy, delivery date etc. In the "contract view" with related fields turned on, i cant see all quantidy and delivery date, just the info from one of the many delivery n°. what can i do to see the contract n° and all of the multiple delivery n°& related info? thanks.
delete project
how to delete project ? thx
Data Dictionary Again
3 or 4 times I have encountered these data dictionary errors while working on various apps. Once they occur you can't continue. They seem to clear themselves up after some time. I have asked about what causes them and have never received an explanation. It would be nice to understand if it is something I am doing so I can avoid it, and if there is anything I can do about it. Nothing I do seems to get past it once they occur. 1 . [t_591877000000035043] Exception occured while setting value in PreparedStatement
Easy Edit of fields from Search View?
I have been using and Excel spreadsheet with only 4 colums. Thought it would be easier to switch to a database program. However... When I search records... and get the results... I would like to be able to change a field "directly from the search results"... instead of having to press "edit"... THEN change a field. Is this possible? -Brett
need a sample formula in which sqrt works
Can somebody post a easy sample formula in which sqrt works? My formula sqrt(feldname) does unfortunately not work... SY Georg
Optimizing Creator Forms for Mobile Browsers
Is there a way to optimize forms for mobile browsers? I'm just starting out with Creator and it seems like a brilliant product. I've got a few basic forms that I would like to start using to capture data in the field. I can open them up and use them on my iphone but I have to do a lot of zooming and scrolling. Is there a way to make my forms "recognize" if I am mobile or on a PC and format the manner in which it displays accordingly? Hope this questions makes sense. Thanks! JG
Need help in creating a registration form
I want to create a registration form such that the form opens up on my website. The data has to be stored on my website and I want to send thank you mails to the registered people.
How to made condition on drop box listing
We can use java script or not in zoho. One more problem facing on that, I create one drop box in listing cricket team (india, Pakistan, Australia) and another drop box Player name. if I choose India team, I want to show all player name of India another drop box (player name). please help out me. It’s very urgent. Please do reply ASAP. Regards Narendra Singh
Lookup based on previous selection
I want to create a field that is a Lookup from a different table, but I want to set the criteria dynamically based on a previous selection of the user: Example: Table Clients has String Company_name, String Address Table Contacts has String Full_name, Company:=Lookup from Clients.Company_name I want to create a third form that will contain a Lookup from Clients and a lookup for Contacts After selecting a Client and going to selecting a Contact, only contact from the same company as the client will
Look Up not working with drop down (single select)
I am trying to create a relationship using the instructions given here: https://help.creator.zoho.com/Creating-relationship.html I am trying to import a field that contains a list of locations. When I add a LookUp field to the form none of the fields in my other form are displayed (they are all drop down single select). Just to check, I tried using LookUp to create a relationship with another form, the only fields that displayed as an option to import were the single line fields. Why aren't the drop-down
Need help with registration form
Complete noob here. I am trying to make a registration form for a 2 hour school event, that will consist of students choosing 2 separate one hour sessions from 40 choices. Each session has a different number of students they can handle, so I need to limit the number of registrants for certain choices or remove/cap it at a certain number. How do I do this? What would be the code? Thanks in advance.
How to make the url fields black?
Hi, I have a list of links, but they are always blue. Is there a way to render url fields in a different color through css or some way? Thanks Vera
New Currency Types added
Dear Users, We have updated http://precreator.zoho.com with the below mentioned new features : New option to show/hide "Sign up for Free" link from the login box in application live mode. This enhancement is provided(for paid users) under the Application Settings screen. The following currency types are added: ANG - Netherlands Antilles Guilder GHS - Ghanaian Cedi (new) HNL - Honduran Lempira MMK - Myanmar (Burma) Kyat PAB - Panamanian Balboa XPF - CFP Franc (Pacific Financial Community)
Search interface HTML view does not work when embedded in external site
Hi, I recently created a search interface for my view following Latha's article here (https://kbase.creator.zoho.com/forms/search-interface) and this allowed me to create multiple search criteria/filters which is great. However, when I embed this HTML view in an external site, the search interface does not work. I am embedding this view in an external site to allow me to create a really custom header for the application. My questions are: Is it possible to get the search interface to work when embedded
Exception occured while setting value in PreparedStatement for the Column !...
I am getting the following erro and cannot submit my form in Submitted Grant Applications 1 . [t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified in the data-dictionary .[t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified
How to pad a string with spaces
Hi Everyone, I have an application that will export records to MYOB accounting, and am trying to set up one field properly. The field will be a concatenation of four other fields. The entire length of the feild must be 255 characters long and have the following attributes: strPO + varCellPadding + cboClient + cboMethod + cboLanguage The trick is that varCellPadding is a variable: varCellPadding = 255 - (strPO + cboClient + cboMethod + cboLanguage) Getting this value is easy, but how do I actually
On user input for a drop down only processes once?
Hi, I have a form with a drop down list. What I wanted to do is each time the user selects a different value from the drop down list to update another field. That works to update a text-field (So when I select sometging from the drop down I place the contents of the selected value in the text-field.) But I also try to update a Note (containing some information about the choice) And that only is updated the first time a user selects an item from the drop down list. Each time the user selects another
Unable to delete a field
Hello, In my SDI tool Parameter Tracking application there is a field named "Delete Me" in the Data Entry form that I can NOT delete. I keep receiving and error telling me the operation failed and to try later or refresh adn try again i have done this with no success. Please help fix this issue. Access has already been granted to support for this application. Jason Rapp
Was this defect not corrected last year ???
Last year I reported the problem with the on User Input sections NOT being triggered BEFORE the on Click (or on Success) sections for Date fields when the user ... a) changed the values via keyboard (instead of using the Calendar Widget) b) followed it up with a click of the Form Button As I recall ... after a number of interim measures, this issues was reported as fixed. I also recall verifying it at the time. Today, one of my clients reported a problem ... which after considerable investigation
How to show only the filled columns in the view mode?
Hello, I have a table in which there is more information in the view mode (the button near delete) than there are column that can be seen in the form actually. I want my users to use the view button to get the extra information. However I do not want the fields that are empty to be seen on the view list. Is there a way to shoe only the field with data entered in this view list? Thanks, Vera
Seperate views based on submitted drop down box
I have a work order app that has a drop down box named submitted by, this box contains different names of people who can submit work orders. Is there a way to have a view based on who submitted the work order? As of right now, the work order view shows all work orders submitted.. Thanks in advance Ken
Stateless Form--------- Looking for Script to find highest value from a different form.
Hello all, What is a script that will allow me to find the following? 1. If a record does not exist in a form, I need to assign the value of "1" to a field in my stateless form. 2. If a record does exist in a form, I need to increment the MAX value found in the record by 1. What is the easiest and simplest scripts to accomplish this task? Thanks, Bartley.
Zoho Migrator generates error & doesn't convert MS Access database
I am using MS Access 2007 on a Windows Vista machine. My databases import very nicely into Zoho Migrator. But, when I try to upload to Zoho Creator I always get the same error: "Problem encountered while creating the application IAMError:Z101:INVALID_TICKET". I have verified that version 2.0 of .Net Framework is installed. Help!
Email notification from field value change?
I have a hidden picklist on my form named “status” that has three options {"Pending", "Approved", "Denied"} and I would like to have different email notification going out to the person who submitted the form when this status is changed. Is this possible? And where can I find some sample code for this? Currently the from generates an email on form submit and the status field is set to pending (hidden field),but I would like it to generate emails when the status changes to approve or denied with
Rich Text Editor - Limited functionality
I had been looking forward to The Rich Text Editor functionality and it will make my Zoho Creator experience that much more satisfying. But the functionality seems limited, at least, for now. As Niskypto has mentioned here, 'on user input' commands do not work for the RTE fields. But the problem seems to be wider than that. I couldn't update an RTE field through an "on-load" command; and the RTE field cannot be updated on input of other fields either. So I get the impression the current version of
PDF generation broken again!
ZC Team, there are still problems with generating pdfs from html views, it takes a lot of time to generate them, and these are blank. I thought that the problem was solved, I understood that there is a problem with pdf server, because it is not new. Please, solve it as fast as possible, I am one of the ones who really need this feature these days (at least until I'll develop an alternative solution). Regards, George
How do I set another individual company as a creator on Help Desk - I cannot pass my privileges or swap it.
How do I set another individual company as a creator on Help Desk - I cannot pass my privileges or swap it.
Re: Problems
Dear Sirs I have urgent problems need your help: 1,The ZC system running so slowly like it SYSTEM CRUSH on today from China's user ,what's happen? 2,I try many time to SAVE SCRIPT in my account,but it's donn't work,always got nothing in the screen,the url address is: https://creator.zoho.com/exportScript.do?appid=142568000000203003&fileType=.ds&sharedBy=(my account) hope get your help. Thanks and look forward reply asap Stanley Guo
about design view
is there any design view (as opposed to table view) option in zoho creator like in ms access? if there is, how can i go to design view? is it possible to view creator application online without logging in like in google docs or in scribd?
How to find No of Fields or Columns available in a Form and refer in views
Do you have any working examples on getFieldNames formdata function
Tabs
I have a database that requires a Billing tab, an Operations Tab, Notes Tab, Emergency Info tab, etc. I don't know how to set up these tabs. Can anyone please point me in the right direction? Thanks.
Function & Pdf
Hi, I have a function that allow to export data of a row of searchable dbase in pdf. I do it with html view called Print. I also tray to put zc parameter to export a pdf with name based on determinate field. But it's so different the language of function compared with openurl. Any suggestion? Thanks Mic void print(int id) { openUrl((((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Print_page/id=") + input.id, "same window"); }
Function PDF - landscape orientation
Hi, I have a function script as { openUrl((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/pdf/Print1/recId=") + input.id + , "same window" ); } I can't add ZC parameter as &zc_PdfOrientation=landscape Any help? Thanks Mic
Next Page