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.
Script Help
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
How may I protect my app from being copied?
I hope disabling "Copy application" and "Save as script" commands is sufficient, but how to do this? Embedding is of course insufficient, since from the code anyone can find the main app URL, and from that page run either copy command. Thanks.
SendMaiI Message formdata gives malformed result in Content type Plain Text
Specifically, SendMail Message <%=formdata%> with Content type Plain Text yields all items concatenated without separators, rather than each item on a separate line as it does for Content type HTML. Is a fix planned?
How to refill a form from previously submitted data?
I want the user to be able to use a form to edit a record he previously Submitted by that form. How do I make the form Load fill the form with a given record's data? Thanks.
Exporting Question
I am new to databases. The database I want to build may not get bigger than 1000 records, so I may be able to use the free service as long as it is offered with its current parameters. I have been playing with setting up a form and find it very user-friendly. My concern is that if my database does, over time, grow to more than 1000 records, then it will not be a good idea for me to pay monthly to accommodate it. It is part of my hobby for which I can't incur monthly bills for the many years I hope
Cannot delete field from form
I am trying to delete a field from a form and keep getting a pop-up error message "Delete operation faild. Please try after some time or refresh the page and try again." I've been trying since yesterday. It seems from similar posts in this forum that this issue occurs from time to time and only the Zoho Support team can resolve it, so already granted Edit Access. The form is called Survey and the field to be deleted is called State (the single-line text field, not the Lookup drop-down). Thanks in
Delete "Date" field
I tried to make a date field automatically put the days date in but it is not working so I want to delete it. When I try to do so, an error message comes up stating that the "field is referred in . . . Schedules." and to remove them. I can find no way to remove from schedules to then be able to remove the present "date" field and start all over. - jb
Calendar popup on date field
Is it possible to configure the pop up calendar in a date field to restrict certain days? I am trying to have it block out Sundays. I would rather it just not be available for the user to choose that day. Thanks!
Zoho as a Database API
Hi I want to use Zoho as a database for a Desktop application. 1-How much would using Zoho API for this purpose cost? 2-How could user security be administrated? 3-Do you have Any c#.net examples? Thanks.
Help needed for license ordering application
I am working on a public-facing license ordering application but I am having some difficulty with a couple of aspects. The basic/core requirements are as follows: We sell educational resources to schools. The resources are digital files and schools purchase licenses from us which enable them to download the files and use them. (File distribution is not a concern here.) Each customer (school) may place one or more orders over time and each order may consist of 1 or more licenses. I created 3 forms:
View resticted to only grid view
Anyway to make a view only show in grid format, at the moment you can make it default view grid but the user still has the options to change it to another type of view. Thanks
Obtaining an existing dropdown list value in a field before it is changed
Hi Maybe simple question, i have a drop down field with Sales1 / Sales2 / Sales3 as the choices if the field is changed i want the existing value to be written to a form "Original Sales Person" and the new selection to be written as "New Sales Person" Basically i am trying to record any changes regarding who is handling the sale The problem is that within a field onupdate script only the new value is available I tried to get the original value when the form loads or at another stage but then i have
System down
Hi I my contacts list is missing and I just have the message unable to reach server. Its been down all day. Is there a problem with the site. regards Wendy
Text Disappeared for All Databases Using Set Email Notification
Until 30 minutes ago, text (to, subject, message) that I had written in "set email notification" has disappeared. PLEASE tell me that you can restore this text in all of my Creator databases ASAP.
Next Page