How to access reports other than Pivot and how to create a GANTT chart
Hi 1 - When I go to reports from Zoho Creator, I see only Pivot Chart and Pivot table reports. Are there any other report types that I can create from within Zoho Creator? Note-I am using the free plan. 2 - How can I create a GANTT chart from Zoho Creator? Thanks. EK
Schedule not working
Is anyone here experiencing the problem that their schedule is not working? Mine is not working for the past 2 days
Why did my embeded view in Vbulleton stop allowing edit or delete.
I have no code experience so I hope my questions do not get tidious. I have had a public view imbeded in my vbulletin forum for about two weeks working wonderfuly. All the sudden it will not let the user delete or edit. It shows the delete and edit button but just brings up a "Loading" display that never loads. If I use the same embed on a web page it works fine. Any idea why I am having this problem. It lets me add, search, etc.
Edit a checkbox to completed
I am having the following issue and can't seem to find the answer. I have 2 forms in my application. 1 creates a request and the second for is used for follow-up. On the second form I created a link that pulls a drop down list of the requested with completed == false from the first form. What I wanted to do is on a succesful submit the field of the selected record ID the Completed field becomes true. Any ideas on how to do this? Thanks in advance for the assitance!
create and search question for public database
I am trying to build a publicy available database, that will accept data from approved sources from various states across the country. It will essentially list a restaurant. Then on the same website, i need to build a search feature that allows the general public to search through that filtered data to find specific locations. I got the first part down pat but I'm stuck on the second. Can anyone help? This has been great so far!
How to make the "Send email" actually show up with a clickable email"
Having no code experience I am not sure how or if I can do what I am about to ask but will appreciate any help. When a user fills out a form I have it sent to me in an email. How do I make it so the user's email address ends up in the "From" field in my email so I do not have to cut and paste to respond? I hope this makes sense. The form is a public form
Stateless form + Checkbox fetch
Hi all, The answer to my question is certainly very easy, but I just can't manage to find it anywhere... In the way suggested in this thread, I have created a stateless form that allows me to summon an HTML view containing records corresponding to certain filters. My problem is: if the following piece of code works to get records containing a certain word (here, submitted as "searchParam" through the stateless form)... EmpOtherInfo = Other_Information [(((Employee_Name.contains(input.searchParam)
Links inside of PDF export
I have a form with an upload field. I have run the form and uploaded a picture. I have seen the sample app which displays the picture with the standard view or html view and been able to get my application to work the same way. If I export the view to PDF however the picture comes across as a img link which is not a hyperlink inside of the pdf. Same is the case within the sample application. The HTML view exported to PDF does not show the image either. Within the pdf doc how can I either show the
How many crm records can be fetched to creator
How many crm records can be fetched to creator (for example: from Leads module), from this link: https://help.creator.zoho.com/Fetching-records-from-CRM.html, seems like we can't use WHERE clause, and we can only get Max 200 records from crm. Is that still the case? if it is, why should I still use the functions? am I missing something there? (oh, may be I can use ZOHO CRM API to get the records by Conditions or WHERE clause, is that correct?) Thanks.
Formula field question
In a formula field, can I use the value from a column in a related table?
Calendar: Best calendar solution Creator
Hi Everyone, I need a calendar solution for my Creator app. ...really bad! I have tried over and over to get the native calendar view in Creator to be useful but I just cannot get my users to adopt the Creator Calendar for many valid reasons they complain about. What are my alternative options. Honestly I've seen the google cal feed option but it just seems like such hack. I'd love to hear my impression is wrong. Let me know. Tony.
Stateless Form Intermittenly Nonfunctional
I have a stateless form that worked initially and then went to what looks like a nonfunctional mobile format. The problem seems to have started after I had accessed the form via my iPad but not sure if it is related. The issue first occurred on my iPad and immediately after I accessed the form via PC which reproduced the same results. After refreshing a few times the functional form returned. Now, however, the nonfunctional form always comes up.
Comments in Script Section keep disappearing ...
Just experienced this error this morning ... While I was editing a script section, I un-commented some previously commented lines ... then Saved the section ... all fine so far ... when I ran the Application, I got unexpected errors ... upon returning to the script section, I noticed that ... - the uncommented lines were still commented - but the subsequent lines were un-commented ... in two different places. So I repeated the process ... but this time, after Saving the script section, I navigated
Can I use Zoho Creator to accomplish what I need?
This is my first post on the Zoho forums, and I apologize for its extremely abstract nature and the length! My entire knowledge of databases (admittedly quite limited) has come from troubleshooting various software packages that utilize MySQL and editing a database directly. I have never actually designed a database in MySQL/Access or anything like that. Needless to say, I would have difficulty designing a custom database to fulfill my needs. In either case, I digress. I am interested in using
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
Next Page