using html in Set Email Notification creates blank email
When trying to create a new email notification, normally i just copy an old one and paste it into the new email notification. today i can't even open an old email notification to copy it, and i've tried from three different browsers. also today, as an alternative i copied an old html formatted email from my inbox and customized it. when i saved it, all the information disappeared and the email is blank the next time i open it. if i create an email notification with unformatted text, it seems to work
Cannot add a new section
When I click the "Add a new section" button, it lets me name a new section but after clicking the "Add" button, the new section never appears. Tried on multiple browsers: IE8, Firefox 3.6, Google Chrome 5.0.375.125
Formula fields not shown on form and cant be deleted in script
I have added some formula fields but only the two first show up in the form. (Formula_1 and Formula_2) When i try to delete the rest of the formulas which does not show up in the form, by deleting them in the script i get the following error. Error modifying the page Unable to delete field 'Formula_11' of form 'Account' This form contains data. It is not possible to delete such forms and fields by just deleting the part of code You need to delete such components using the delete keyword. Syntax
unique field property not maintained
I'm trying to add a unique property to a field but when i do it is not maintained after i access the application and return to the edit the application mode. When i try to add the unique identifyer in the script must have unique Account_Name ( displayname = "Account Name" type = text width = 200px ) i get the following error: Error modifying the page Maximum size of a column cannot be reduced, when the table is not empty --
Need Tech Support: Unable to clear "No Duplicate Entries" setting
I originally set a field in a form to "No Duplicate Entries", but now I don't want that condition. When I uncheck the "No Duplicate Entries" checkbox and click Done, it does not take effect. Re-opening the dialog shows it still checked. Then, to try it another way, when I go into Script mode and attempt to remove the "Unique" flag from that field's definition, I get this error message when I try to save the modified script: Error modifying the page Columns participating in the Primary Key Definition
2 lookup fields messing in a view
Hi I've go a "User" database with Name, Last Name, .... + a field "Position"={Underwriter OR Assistant} I've got a "Submission" database where I assign an UnderWriter and an Assistant (I'm using criteria in the lookup field to get only underwriter in the first one and Assistant in the second.) It work great but when I'm in the "submission view, the assistant field mess with my underwitter field: when I search in the assistant field, it search in the Underwriter field when I add a criteria to the
emailing attachments
Love the product, and would like to know if when the system sends out form data, can it also include a file that has been loaded as an email attachment, instead of the link? Thanks dp ideaadministrator
Cannot modify one of my criteria fields
Hello, I have encountered this issue 2nd time already. First time, support was able to solve for me, but it happened again. Wonder if you have the same issue? I have an application with a number of views set up. When I change to edit mode and go to "Set Criteria" under "Records" heading, I find that I can not update the value of the criteria I set up previously. Is this a system bug or did I do something not right?
getting error "java.lang.Long cannot be cast to java.lang.String"
when i try to update a contact record i get this error no matter what i do. please help!
Inventory Management template available?
I am trying to set up a fairly basic inventory management system for a small organization in multiple locations. Are there any existing applications or generic templates that I can use as a starting point? If not, I need to understand how to do receiving and shipping functions that automatically update the warehouse levels.
Question regarding First & Last name formula
I am learning Zoho Creator, In creating a form, I have separate fields for First and Last name. I set up a formula to combine them in a view. It works...almost. In the view, my field that contains the formula displays the first and last name combined but there is no space separating the first and last name. Any help on how to have a space between them? So, instead of the result being "FirstName" it would read "First Name".
Where can I get a user guide for Creator?
Where can I get a user guide for Creator?
Emailing Data is Nonfunctional
user: niskypto app: email-test share: public and support I was going to test the new Email Alias ID feature mentioned here https://help.zoho.com/portal/en/community/topic/how-may-set-the-form-email-address-for-adding-form-data-by-email ... but found that any emails sent to the form are not appearing in the view. I have removed the alias and tried again, still no emails are arriving. Any ideas? John M. Whitney Recommend
Plugins required?
Hello Does anyone know what plugins need to be installed/enabled on browsers such as ie7+/Chrome/Safari? The reason for this is when looking at a Pivot report there is know hyperlink for the underlying data on some machines. Any help would be appreciated Rick
Fields with the same Label Name
I'm having a little problem parsing e-mail data in zoho creator. I receive leads by e-mail in a standard format and am trying to get them through creator into CRM. The format of the e-mail received as well as the form I have created looks something like Name: Phone: E-mail: ---- Pickup --- Address: Postal Code City --- Drop-off --- Address: City: Postal Code. Although the label names are the same, the field names are different: address_p, city,_p, postal code_p, address_u..etc. When an e-mail comes
Dynamic Cell Reference
I have an Excel application that I'm trying to emulate in Creator. A simplification of use-case is described below: The Excel application iterates down a column and examines the values of each cell. Depending on the value, it adds to adjacent cells in the columns before and after the current column. Take note of the yellow cell and the code below. Since the cell's value is 5, it adds the two adjacent cells highlighted in green. Since Creator does not have cell references, I do not see a simple way
What is Dynamic Sharing?
Somewhere on the website I read that Creator has Dynamic Sharing, with no explanation of what it means? Can anyone point me at the explanation or tell me what it means?
Field selection lost on saving the record
In On Add/On Load I add the option "[none]" to a lookup picklist with the following code: clear Introducing_Player; Introducing_Player:ui.add("[none]"); colIP = frmPlayers_List [(Name != "Dummy" && !Name.contains(":"))] sort by Name ; Introducing_Player:ui.add(colIP.Name.getall()); Introducing_Player.select("[none]"); This works fine. But when I save the record, the field Introducing_Player reverts back to "-Select-". Saving other selections in the same field works. There is no code that could
How do I disable users from seeing the Database View?
Hi, I'm trying to build an alumni database for my student organization. I would like users to be able to submit, revise, and deleter their own entries but not see the whole database (in order to keep the privacy of others who enter their data). I only want the developers to be able to see the whole database. Please advise! Thank you, Marissa
Drag and Drop
I am new to Creator and started a new application from scratch. On my form I am using drag and drop but nothing is happening. The red dotted line appears with the word undefined in it when I drag. Why doesn't a box appear to give it a label name?
Cannot create new forms : ERROR MESSAGE THERE IS NO SUCH FORM IN ZOHOCREATOR
i'm unable to create new forms - that is, when i create the new form, and then click ACCESS THIS APPLICATION i get the error message : THERE IS NO SUCH FORM IN ZOHOCREATOR. i have enabled edit access. application : rainbarrel
How do I make a Date picker that shows all the time?
The default Date control shows a text control plus a button to show the date picker. I want it to show JUST the date picker, all the time, i.e. not on a button. How, please?
How may I add an OK box to the forum Submit success message?
Else replace that message pop-up with a true dialog box having an OK box? I need this to solve the problem that the current pop-up disappears automatically after a couple of seconds and this is too short a time for some of my users. I do not want to use a second form since I need access to the input.XXX properties. Thanks.
Free Flow Script
Hi, today, on alls my forms is impossible to save script in Free Flow mode but only in Script Builder mode. It's all ok on Zoho? Thanks Mic
BUG - Cannot Pass Boolean Parameters Via URL
The ability to pass boolean parameters via the #hash format URL has suddenly stopped working properly E.g. openUrl("#Form:Task_Update?ID=1234&Return=true&ShowDetail=true&Comment=test ..." The ID & Comment pass correctly, BUT the 'Return' boolean parameter either does not work at all, or, if the 'Return' boolean works, the 'ShowDetail' boolean does not! Furthermore, it depends if the URL is being opened in the 'same window' or a 'popup window' as to which boolean variable will pass and which wont!!
How can i create a VIEW according to my Requirement?
hello zoho I am create an application in which i am use some formula fields based on calculation, now i want to that when USER submit data then USER redirect to the View of that form and the form contain only Formula fields, means USER sees only the formula fields not the input that it is filled. and another Requirement is that USERS sees only its own record in the View means it can't see the previous results which is enter by the another USER. And my last requirement is that the View Formula fields
Missing records -- delete log for my database
Hello Zoho, We have a situation where we have had several records "disappear" out of a database that we use to completely track and manage a project. Understandably, this has alarmed our project manager. I have looked at the data itself to search for the records without using criteria-based views, just in case a data field got changed accidentally. I have also not given users delete permissions on the views that they use, to try to limit this sort of thing. Would it be possible to see a delete log
Date not showing correctly
I've generated a report using tables from my local database (which I imported to zoho in step1) Following is the image for chart. Dates are always appearing like (15 jan 1970) I've stored my dates as php time string in database. Why is this happening?
Download all attachments as docs
Hello, Is it possible to download all of the attachments in our database in a single action, rather than having to manually right click on each link? We need backups of these files on-site, and am wondering if we can download them in a batch as a zip or equivalent? Thanks, Kim
WON'T LET ME CREATE ANY RECORDS - Error "1 . [t_704788000000012742] Exception occured while..."
Hi, I must admit I'm a little frustrated. I just spent two days setting up this database for my company and then I go to add my first legit record and.......FAIL. When I fill everything in and submit, I get: 1 . [t_704788000000012742] Exception occured while setting value in PreparedStatement for the Column [Notes_704788000000021173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_704788000000012742] Exception occured while setting value in PreparedStatement
ERROR: Exception occured while setting value in PreparedStatement for the Column...
Why does this error come up on the form embedded in my website located at: http://buybaltimoreproperties.com/buy-property/buyers Error Message when the form is submitted... 1 . [t_507764000001876118] Exception occured while setting value in PreparedStatement for the Column [Buyers_Add_507764000001876146] Check whether the datatype for this column is given as specified in the data-dictionary .[t_507764000001876118] Exception occured while setting value in PreparedStatement for the Column [Buyers_Add_507764000001876146]
Error - Exception occured while setting value in PreparedStatement
When submit form "Novo Imóvel" (form Potencial) message occurs: "Invalid entries found. Please correct and submit again." appears at the bottom of the form: 1 . [t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155] Check whether the datatype for this column is given as specified in the data-dictionary .[t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155]
[t_483991000000105825] Exception occured while setting value in PreparedStatement
Another one of these errors... (I get these a lot!!) This is related to the Leads form in my Admin Application... 1 . [t_483991000000105825] Exception occured while setting value in PreparedStatement for the Column [Company_Ph_483991000004832805] Check whether the datatype for this column is given as specified in the data-dictionary .[t_483991000000105825] Exception occured while setting value in PreparedStatement for the Column [Company_Ph_483991000004832805] Check whether the datatype for this
Exception occured while setting value in PreparedStatement for the Column
I receive the following error when attempting to add records to the Account_Products Form in my Admin Application.... The application is shared to support. 1 . [t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Free_Inclu_483991000003220870] Check whether the datatype for this column is given as specified in the data-dictionary .[t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Free_Inclu_483991000003220870]
How may set the form email address for adding form data by email?
Currently the form's email address is chrisjj2-116@forms.zohocreator.com but I'd like to set it to something more friendly. I'd guess the mechanism is Properties, Form Alias Email ID: except it appears to have no effect on the form address shown by More Actions, Email Data and I can find no mention of it in Help. Thanks.
Large Size Creator Apps can not be duplicated!
Hello All, I am having a major problem. I have several large apps that can not be duplicated. Support has looked at the issue and kicked it to developers to review. Is anyone else having duplication issues of their apps? Any help on this issue would be greatly appreciated............... Thanks, Bartley
CANNOT LOGIN VIA GOOGLE APPS
HELLO, MY USERS CANNOT LOGIN USING OUR GOOGLE APPS ACCOUNT, HAS THE OPEN ID GONE DOWN AGAIN? THANKS RICK
Help with Script
I need help in script. I want a client to be able to select one of these States and be able to complete the form. If they choose any other State, then they get the url stating we are not able to help them. The following script works with one State however, I need to allow the form to be completed if they choose any of the follwoing States AL,FL,GA,IN,LA,MD,NC,OH,OK,PA,SC,TN,TX,VA. Otherwise, they get the URL Any help is appreciated if ( (input.State != "AL") ) { hide State; disable
Library log
I'm attempting to develop a database for a tool library for our little non-profit following the closure of Dabble. I've tried the library manager application but wish for a somewhat different structure. We have a PEOPLE form (borrowers) and a TOOLS form, each of which track vital information. I would like a LIBRARY_LOG form, where each entry is a borrowing event and easy to fill out by our librarians when they are busy. The log should be related to PEOPLE1 by a one-to-one, but to TOOLS by a one-to-many
Issue while Inserting Currency Field
I am trying to insert one currency field in my existing form (Financial Transaction) in Penta CRM 10 Application but it doesn't appear after which I tried to add Number field which successfully added after which I tried to convert it in currency again it disappear from my form. I have already given read write access to the support team. Thanks.
Next Page