autopopulate a form field to a particular item on a picklist based on the previous submission
Hi all, Hoping someone can guide me on something i'm trying to accomplish with a form and a big picklist. Suppose i have a form that looks like this: Username: Day of the week: Pick of the day: The username is a dropdown picklist that has a large amount of entries, say 300ish. Every user has a pick of the day for every day of the week. It's only really necessary to do data entry for the information once a week. So let's say that i have seven entries that i need to enter in for Zachary Taylor.
Cannot add record via a form
when I tried to add a record via a form, the following error appeared: 1 . [t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary .[t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary
Cannot convert String null to Numeric
Hi, I've an application in which I have a field that I fill with numeric values. In on user input I set this fiel variable wiht: if (input.Costo == null) { input.Costo = 0; } The application run, But system still return this error to me. If I cancel the Alert, application run correctly: Error details: Error occured while executing on user input script. Unable to update variable Costo Invalid Numeric Format found Cannot convert the String null to Numeric My application: here
Export to PDF names filename with .html extension
When i try to export my views to PDF, the downloaded file is named with a .html extension.
complete search
i have used zoho creator for a week now and found it to be better for managing my contact database than any spreadsheet. but one thing is missing - search query to seek all data fields. can you, dear developers, add it, please? sven.sapelson
Creator CSV export should double-quote multiline text fields
If you export data with multiline text fields that contain line breaks, the data from the multiline fields is not quoted with double-quotes. When you import the data into Excel or other CSV reading programs, the line breaks will cause the program to think it is the end of the CSV row and start reading a new row of data. Creator should double-quote fields that contain line breaks. Example: Create an app with Field1, Field2, Field3 where Field2 is a multi-line text field. Enter: Field1: Data1 Field2:
Cannot add records
I cannot add new records in form or list view. Below is the error message. 1 . [t_650582000000012062] Exception occured while setting value in PreparedStatement for the Column [Strategy_N_650582000000019535] Check whether the datatype for this column is given as specified in the data-dictionary .[t_650582000000012062] Exception occured while setting value in PreparedStatement for the Column [Strategy_N_650582000000019535] Check whether the datatype for this column is given as specified in the data-dictionary
Filtering an HTML view by Country and State without making hundreds of pages with iframes?
I have a form that collects country and state service area information from groups via 2 multiselect fields. They are multiselect because groups can provide services to one or more states or even countries. This information will be accessible to the public to find groups nearest to them. I need a way to display the data once the user selects the criteria. They will select their region, then their country, then if in the US or Canada, their state/province. This will take them to an HTML view
Public should function like any other user in the share tab
I right now have a app that has a form and a few views. I'd love to make the form public, and maybe one of the views. I'd like to make another view (that the public can't see) and the form accessible to another user. I wish I could select what options the public has access to and that it wouldn't be an all or nothing option like seems to be right now.
Count - autonumber - some conditions
Hi, I have a view in which I list all class of some universities. So I have fields as, University (U), Matter (M), Teacher (T), Year (Y)... It´s possible to generate a complex autonumber machine for each value as 1, 2, 3, 4 for each UMTY condition in the view (I have 5 Universities, 100 matters, 150 teacher and 3 academic years (so I need 150 autonumber machine for each year)?... Sometimes my tutors forget the sequencies! So I need to get free them from this function! Normally I use this function
URL shortner
Hi guys, none have idea about how use a URL shortner in a creator application? I need to reduce a large url using a webservice (as goo.gl) and send short url in sendmail with .qr suffix to produce a QR image. I find here a function to shortify url and here Api documentation. Here a site that have a source code that may be use. Any suggestion? THanks Mic
Roles & Profiles?
I am creating my first Creator database for a customer. My customer has 6 employees and needs them to have different access levels to the data. Is it possible to create roles or profiles or field-level security for a Creator database like with ZohoCRM? I am currently a free basic user. Thanks -- DJ
Change Font on Field names
Is it possible to change the font and color of the field names?
update a form field to indicate email has been executed
I'm sure this will be easy to solve for you pro's out there, but this layman is cornered. Seems simple enough, but I've tried to script this a couple of different ways and am burning the hours without getting any success. We have a 'send email' function that works just fine. All I want is to do is add into the function a second step of updating a field to indicate the email was sent. (change 'Email Sent' from Pending to Sent). I've searched the forums and wiki's with no success. Anyone?
Toggle show/hide divs
Hello everyone, Hopefully I don't start a new forum, if so, please close this one and let me know where to find the right forum... But I'll give it a shot anyway, I'm really new at jQuery, but it's unbelievable interesting. But I've run into a problem, I just can't seem to get to toggle between show/hide a div. When I implement the jQuery it's showing or hide all the Div's and let mee see only the first one.... I'm using the following jQuery code, plz let me know how I mess up: $(document).ready(function()
Email Address Blocked
My email address is raywhche@zoho.com and I had received Sender Address Blocked message, while I had not sent more than 250 emails today! Please help to get this resolved. Thanks.
Fill a dropdown based in conditions and others dropdown in others forms
I have to generate a complex choice based in an initial selection. I have Universities (A), Years (B), Matters (C), Teachers (D), Lesson titles (E). In the first step people select A, so I have a script to populate B. Then people select B and another scritp populate C, and so... as soon as E. Now I have to add another variable condition, that is type of course (complete or partial (X), so when people select B may also select X, and I need to populate C based on two variables, B&X. I try to rich
embed problem with summary of view and updating form information
HI Thanks for any help you can offer. My users are unable to find the popup box to update information from the summary view because it is centering itself on the default size of the iframe instead of the users screen. I believe the problem stems from me having to set a default height (7000px) instead of 100% so that the form displays correctly in all browsers(firefox inparticular). I assume this is the issue because the pop-up box displays correctly when not embedded. Let me describe a few of
Make Table Query in Creator?
MS Access has make table query. is there something equivalent in CREATOR? I have loaded a form with data. I want to just select out the unique entries in one of the fields and use it to populate a new table (form).
Buttons won't open dialog boxes when form is embedded on website
I used the notes field to add buttons and call up html views inside a dialog box when the button is clicked. The problem is that these buttons don't work when the form is embedded in my website. My colleague says it is a cross domain issue. Is there a way to get these buttons to work when the form is embedded?
public access to the form
I have requested public access to zoho form but this message is being displayed: "your request to the feature is pending." how long does it take to get public access?
Changing Font size has no effect
In customizing the embed code the font size never changes no matter how big I set it, the Field labels appear too small in my site.
Sum Form to display another Form
I have two Forms - in one, the User inputs Daily Sales, Labor, and other figures. In the other form, the User inputs Supply ordersm broken down by Food, Paper, etc. User can input more than one Supply Order a day. I want a View that shows me the Daily Sales, Labor, and Total Supply Amounts for that day. How do I sum the Supply Amounts and add that to the Daily Sales Form? Thanks, Kim
Use of empy field condition
I have generate 2 forms (1) Form-1 : 3 fields (2) Stateless form Data will be entered in stateless form. Total 6 fields generated in stateless form. A customized button also generated. A deluge script attached with this button (On click). Script is such that it will add first 3 fields of stateless form as a first record in Form-1 and another 3 fields of stateless form as second record in Form-1. But If I keep fill only first 3 records in stateless form, keeping another 3 fields empty, deluge script
last question: How can I change the automatic Creator ID
Hello once more, Using the ID option is very handy. In the email notification the user receives in this way a personal nr and I can store that nr besides in the view for later reference. The number that Creator uses is very long, like 225749000000034400. Can I change it that it would automatically give another (shorter) nr like 08091000 and with each following user of the form the nr would be 08091001, 08091002 and so on? Thank you so much for your help. Greetings Seafroggie[/img]
How to postURL to your own PHP website.. is it possible?
I have a PHP program that takes post data and fills a PDF form then flattens it. I want to send my Zoho data to this program but it seems that there is no way to post data in such a way. Is there a way to post data to an active PHP program page which will be opened?
Negative Currency Values when importing CSV file
the only format for negative currency values is to remove $. () around number also fail to load. if you have -$12.34 you have to remove $ and it will load properly.
Help: Need to fill in a field on one form based on field in second form
Form hierarchy: PROJECT ---- WORKAREA ----------WORKFLOW The relationship is that 1 project can have 1 or many workareas and then each workarea can have only 1 workflow When each workflow is marked complete via the field COMPLETE? = yes, I want the associated workarea to be marked complete. Further, the project needs to be marked complete when all of the associated workareas are marked complete. Also- this needs to run well on a mobile device and not include anything that would prevent an iPhone,
Multiple input to same field + onditional requirement
Hi -- Here is what I need : Users need to enter their country of citizenship. If their country is not part of the EU, then, they *must* enter their green card (equivalent) number, validity start date, validity end date. Here is how I thought I would do : A "Country" field, with a dropdown listing all E.U. countries + "Other" option. If pick ≠ "other" : move on If pick = "other" then show 4 new *required* fields : - Other country - Card number - Start date - End date Two problems : I need the "Other
Editing Forms and Child.Parent Relationship
In my application, I have set up a relationship between "Courses" and "Programs" by creating a look-up. Each Course and Program is also associated with one or more fields from a "Taxonomy" form. I have created a View called "Programs and Courses for Taxonomy." I would like the View to show a list of Programs, and then the list of Courses associated with each Program. I would like the following in this View: 1) For each Course to have its own line and for the Course Name to be a hyperlink into
Form report strange error on sending
Hi, I have a form that run correctly, but today report this error when click on send: 1 . [t_92720000002162027] Exception occured while setting value in PreparedStatement for the Column [Data_pagam_92720000002329055] Check whether the datatype for this column is given as specified in the data-dictionary .[t_92720000002162027] Exception occured while setting value in PreparedStatement for the Column [Data_pagam_92720000002329055] Check whether the datatype for this column is given as specified in
Force a link to be clicked or for a email reply to confirm order
I was curious if it is possible to create the following procedure: 1) When a form is submitted, to shoot out and email with a confirmation link 2) When the confirmation link is clicked then the entry is added to the DB. Is this possible?
Get an IE alert with many records selected for a form object
The above pops up in Internet Explorer with a custom action bringing up a form, if more than about 50 records are selected. Anyone know how to turn it off or get around it? It scares users. Works fine for me in Firefox, though a user reports similar there as well (I have not been able to replicate it).
How can i attach two forms with one form?
Dear Members, I am create a form which value are depend on other two form then how can i create this type of relationship. like one is type of login form and another two is type of signup pages. now how can i create both (signup) pages relationship with only login page. means when user type any information in the login page then it is fetched or verify data from both two pages. Thanks in advance Wait for reply
Problem with formula field
I'm trying to make formula field, where I'd like to use variable from another formula in this form. In result there is warning message, that "variable is not declared". Have you any thougts to solve this? Janis Sorry, for my english...
Exception occured while setting value in PreparedStatement for the Column
Hello, I am getting the following error when entering data in my form http://creator.zoho.com/dcmvhm/dreamcatcher-database/#Form:Bookings: 1 . [t_643693000000013024] Exception occured while setting value in PreparedStatement for the Column [Total_owed_643693000000013845] Check whether the datatype for this column is given as specified in the data-dictionary .[t_643693000000013024] Exception occured while setting value in PreparedStatement for the Column [Total_owed_643693000000013845] Check whether
How to add a new field with an "if statement"
I would like to know if it is possible to have a new text field to appear on my form when a user selects a specific item from a drop down menu. Example: If the user selects "other" from a drop-down menu, I would like for a new single line field to appear labeled "other" so that the user can fill in the required information.... Please help. Thank You in advanced
Can't delete form?
I have had trouble doing what I thought should be simple: assigning the value of one drop down field (values taken from another form/table) based on the value of another drop down or radio choice in the current form. Frankly, it shouldn't be as difficult as it is -- your point-and-click script builder should make it easier and your help samples should be clearer. Be that as it may, I did my level best to attempt this on my own. Then, all of a sudden during one of my test cycles of viewing code, using
PHP Forms
I have been using PDFTK tools to fill forms then flatten them. By taking various free/opensource scripts from the net I managed to make a program that will take POST data and fill a form then flatten it. I use INKSCAPE to create the form graphics and OPENOFFICE to create the fields. I also manged a way to include photos. If there was an elegant way to present data then it would be great. For example a WYSIWYG type of editor where you drop and move fields around to where you want them to be displayed
How to POST data to my own PHP webpage
I have created a PHP program that takes POST data and combines it with a PDF file then flattens it. It seems that postURL only posts to Zoho Applications. openURL would require a GET where the data would be exposed in the URL. Is there anyway to do this in Zoho?
Next Page