Counting Form Cells
I have an app that a client will enter in a bunch of information about customers and who is the salesperson. What I am wanting to know is if there is a way for another form view to show a count of all the entries for a particular salesperson. So I would need it to go through each entry of the other form and check the salesperson then keep a count. I know how to keep a count and stuff but I do not know how to check each entry like that.
Show uploaded image in a new window?
Hello, I'm working on an image voting database, for a charity where hundreds of individually submitted photos are being judged by several internal users. They will upload directly into the Zoho Creator app. For the judging I want a link or way to have the user click to show an uploaded image full-size in a new window. I tried creating a Function and setting that as a Custom Action to create a button for each record, where imageid parameter was set as the file upload field but it doesn't work, it
Dynamically Update HTML Page
Hi, I'm trying to create an HTML page that fetches a certain number of records sequentially. For example, when it first loads, "Page 1" would show records 1-10. This is easy. How can I create a link or button that will cause the page to reload and fetch the next ten records, and so on. Thank You.
Help Desk system does not handle Japanese text responding to support request by email.. It is Garbled. (mojibake)
Hello, I am having an issue where whenever the email system in help desks touches an email that has Japanese, it will garble the characters. of the email replies, acknowledgments and updates to the requester and the tech. Entering Japanese from within the help desk application, which then notifies the requester and the tech, the Japanese text is fine. So it is just when support requests are sent by email and the system then sends notifications. Any ideas?
View Criteria
I'm attempting to create a view of things sorted by date without actually displaying the date field in the view. I have attempted to add the deluge "sort by USER_DATE" into the view criteria, but it wont accept this. I have looked the the functionality-based urls, and do not see an option to specify sort criteria. I resorted to building am html view and constricting the table "by hand", which is less than optimal since all the filters are not automatically present. How can this be done? John M.
Percentage Validation
I have a % field on a form and I need to ensure that the user enters a % between 0% and 100%. I tried using the following On User Input scripting, but it does not seem to be working. if (input.Fee_Percent > 100) { alert("Fee Percent cannot be greater than 100%."); } if (input.Fee_Percent < 0) { alert("Fee Percent cannot be less than 0%."); Should I just change this field to a drop down filed with only the options for values of 0 to 100 and then change my calculations using this field?
Remove "All Times are in PDT"
Hello, I was block the display of "All Times are in PDT". I have my time in IST anyways and this is misleading. Please suggest Regards, Rajiv
Displaying complete records (not just a few fields) from 2 forms in 1 view? Possible?
Hello, I have built two forms for a client organization with groups and service centers (called intergroups) worldwide. Groups and intergroups have to register with the main office, hence the two forms, group_registration and intergroup_registration. I have thought about consolidating the two into one, but each one collects some specific data that the other does not. The forms are made, but nothing is being used live yet. Both forms have 2 multiselect fields, named identically, Country and State/Province.
on click script in stateless form returns an error
Hello, I am developing two stateless forms to insert data into a main form. All I have is an insert code, an alert, a sendmail, and a reload. When I test the form I get the following error. Error details: Error occured while executing on click script. Error occured. (this is what I get when I'm logged in as admin) If I'm logged out, I get 'A problem has occurred, contact the administrator' The form I'm referring to here is "Group Registration S", which inserts into "ROOT Registration Form". I
Decimals in a Grand Summary on a Report
Is there a way to control the output of the Grand Summary in a Report so it doesn't display 14 decimals? The data is from a Formula field that has the round() function to 2 decimals, so the data looks good, but the summary looks silly.
Import / Export
Dear all, we have a app with any tables, testing the export and import data, we can difficulties, not retrieve the values of fields related to other tables, is possible to do this without losing our information whatsoever? best regards, Marcelo Parraguez A.
Transparent Forms
Is there any way that I can take the form I have created and make the background transparent? As it is now with the white background on the form, it clashes with my website making it look much less professional. Is there any way this is possible?
Populating Drop Down list from Form
I am creating a class website that will have information for my students regarding test, homework, and other information. I would also like to add a scheduler so that the students can set up times to come see me. I know basic html but I am not familiar with databases which I learned is need to populate the fields for the scheduler. I thought Zoho would be the solution to my problem however after creating the form Im wondering is it possible to connect the information from the database to the drop
Remove choices from look up field when selected
I am a real novice when it comes to code so I just thought I would say that up front. Is there a way to remove an item from a lookup field once it is selected by the user. I want to limit the number of people that can register for an event so I thought I would create a form that has seats numbered from 1-10. When they pick a seat the "1" would be removed then the "2" and so on until there are no seats left.
postURL not working
For the life of me I cannot get the postURL to work. My objective is to post for example id, name, address to my own PHP website. The PHP website reads the variables and creates a PDF file which is flattened and loaded into the browser. I have tried everything, read everything, but cannot get it to work. There must be a way! Somebody please help me. I am stuck!
Recommendation to relate 1 form with another?
I have a form, Policy. On it I have field Policy Number and Expiration Date. I have another form, Attachments, since a Policy form can have multiple attachments related to it. One attachment is only relevant to one policy. On Attachments, I have fields, Title and File Upload. What is the recommended relationship direction and why? 1) Put a lookup field on Policy to lookup the Attachment title (multiselect) or 2) Put a lookup field on Attachment to lookup the Policy number
Creator API: last records first?
Hi guys! I'm working with a Creator database in Flash. I'm trying to get my records 20 at a time, last ones first. Any way to do that? By default I get the first ones first. I could use range, but I can't find a way to see how many records there are. If I knew that, I could go range last-20 to last range last-40 to last-20 (I tried making a view that sorts them, but I can't load the view using REST for some reason, keep getting a 404 on the URL. Maybe because the application is private?) Thanks for
I can't use a dropdown list in reports?
I'm asking my customers where they heard about us through a creator form with a dropdown list of prepopulated answers. Now I'd like to create a report on this, to see how many people chose which option. The problem is that I can't see the dropdown field in the report builder?
error com.adventnet.workengine.task
Hi, My system return this error in sending the form (myform): java.lang.IllegalArgumentException cannot be cast to com.adventnet.workengine.task.TaskExecutionException At which part of the script may be referred? Anyone have experienced the same error? Thanks Mic
Ability to include ZohoCRM Modules in creator Application
I saw here http://help.creator.zoho.com/Working-on.html that a new feature will be released for paid editions Ability to include ZohoCRM Modules in creator Application If it is possible, can you describe it? A deeper integration with CRM sounds really good, a feature like this would be very helpful for my current project, and I'd like to know what to expect from this feature. How will be possible to include Zoho CRM modules in a Creator application? As separate pages, as embedded parts (like in the
How can I add a "other" option to my dropdown list?
I have a dropdown list with 4 options. I'm asking people where they've heard about our company. I'd like to allow having an open option as well, allowing my customers to give an answer that is not in the dropdown. What's the best way to do this? Do I have to link fields or merge them after submission? Thanks a lot!
Google App Engine Deployment Error
I tried the demo video process to create and deploy a simple two text field form to Google App Engine, and both running locally with the GAE SDK and live on the appspot.com deployment, the post operation fails with a huge series of errors. I am wondering if the App Engine has make breaking changes that have caused the Zoho Creator deployment to no longer work? Obviously it worked at the time the video was taken but not so much now. Any ideas? sleakbug
Number Format
Would it be possible to change format number from 1,000.00 to 1.000,00 in Zoho Creator? It is needed for application localization purposes... Regards Antonio
User login without "zoho user login system"
Hi. I had created a input data form on Zoho creator and i woud like to grant access rights only for or a list of specific users and password provided by me. Is it possible i design the user/password system without to use "Zoho Creator login"? Cause i have a free signature and needs to grant access rights only for a list of specific users. Thanks. Regards. Juliano.
Display Fields when a certain value is selected/inputted
I have created a form that contains a drop that menu when a certain value is selected it displays/hides specific fields. I am running into a problem tho... Data only is being displayed for the last value of the drop down menu. For all the other values, it just hangs and doesn't display/hide the proper fields, Please visit the link below as i have provided a link to the form i am speaking of... Please help! The form is located here: http://johnpia.com/zohoform Here is the code for the "on user input"
cannot add record
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
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?
Next Page