Changing view criteria based on user?
I have an public form that i have multiple sales people submitting sales information to me from. I want these sales people to be able to view all records that they have submitted. I do not want them to be able to view other sales persons records. Is there a way using html views to have them input a user name and password. If it is correct, view all records that they have submitted? I figure they submit a logon form that then does an if then and determines if it should forward them to the view
I'm having trouble with PERMAlink
I'm having trouble with PERMAlink all the forms works except for one. https://creator.zoho.com/avivacanada/midmarket/view-perma/All_requests/mgAkbGQYvABm5pK1DrxAQA4kdSshOs57BKxrpUADXpbH7RffP7GvSqekx4QfG7aY5jJr9k4jZX26BJtWUfVde67VVZsMKYxwnWKp works but https://creator.zoho.com/avivacanada/midmarket/form-perma/Feedback_Form/6sAa49Ja3RwrbK4F3ABmH61BMprAGZZKAktCbfP1n1K6bN02NrufBPAE3EtdbeGmD3aqDseHe3yZUBh375fUPthxMqY8O71gCrtq/ doesn't any help?
Can't remember how to display fetched records without using HTML view
I haven't used Zoho in a while and I can't remember the best way to do the following. I know how I could do it using an HTML view, but I don't want to because of the built-in functionality of the Zoho View's. I need to filter the records in a view based on criteria selected by the user in a form. I have a table of three different size criteria of an item in the "Item" table. Let's say, width, length and height. I want a user to be able to enter specific criteria in a stateless form "Search" for
Adding a new User
I've been trying to add a new user by entering their email address, but no email is being sent to the new user? Am I missing something? Martyn
Says variable isn't declared, but was entered as a parameter
I am trying to fetch records where a field is greater than a parameter. Using deluge... I am passing a parameters into the function, criteria I want to fetch records where Height of the item is larger than the criteria items = item [Height > criteria]; but it says Error in statement at line number 1 The Left expression is of type BIGINT and the right expression is of type STRING And the operator > is not valid here So if I try to set the variable by using criteria = .toLong(criteria)
Client Survey
Hi all, I am new to ZOHO ...i know this is used to create survey forms I would like to know how will i generate leads using this forms...what key info do i fill in and How? Rgds Naveen email:Naveenrao02@gmail.com
Hide/Show option in embedded forms
I have embedded one of my Zoho forms in a Google Sites page. The form is configured to show one field based on an input to another field. This works fine in the Zoho Creator page, but once embedded in the Google Sites page, the application throws up the foll error message - "Error occured please contact application owner" when the trigger input is provided. For greater clarity - here's a simple example of the problem I'm facing. Say, I have a form which has, among others, 2 fields: A and B. A
About the Tabs
Here's a simple suggestion for the application interface... I make extensive use of tabs and hidden tabs in my applications. One thing that bugs me is having to click edit application to find some of my views or forms that are in hidden tabs so I can open them in live mode to see what's there. A better implementation would be to have an options to hid tabs from public (everyone), or users, or developer, or admin. Maybe gray-out the tab to indicate that's its hidden property is set in one of these
Settings Page throws error instead of validating the input
I was trying to create a simple form as a support one to an article about cross-site scripting vulnerabilities. When the link name was having a <script> tag it immediately bombed with an error message instead of showing a validation message. See attachment for more details. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
save data in Google spreadsheet
I am trying to use Zoho creator as front end and like to save all the data in google spreadsheet. is it possible to do so!!!
How to refer to some table in Criteria ?
Hi, My application has more than 1 users and I want them to access to different set of data In the Customer form, there is the field called "SITE" I have another form to assign which "SITE" a userid can access However, I can't query that userid-site form in the Criteria for View. Is there any way to do this or can it be done in a different way ? Thanks
Can't See Google Apps Users
I'm currently trying out Zoho Creator Helpdesk. When I go to adding technicians and requesters, the form is completely blank. I can't figure out why.
NULL RECORD COUNT
WHILE DEBUGGING MY APP I CREATED "TEST" RECORDS. I DECIDED TO "GO LIVE" AND DELETED ALL THE RECORDS. NOW THE APP RECORD COUNT IS NULL AND APP WILL NOT LOAD. HOW DO I RESET THE RECORD COUNT TO ONE.
APItite (Zoho CRM API application) updated...
Hello ZC Users, I just republished APItite and here's why :) Hi, I have modified your APILite application to include a daily schedule to fetch recently created contacts in Google Contacts and update in ZohoCRM. Kindly re-publish your application to Marketplace and get back to me for further queries. Rajesh.U, ZohoCorp, http://zoho.com Hi, We have enabled support in GETURL task for reading GData API. Earlier we did not have option for sending Header information and hence it was not possible to authenticate
500 Internal Server Error
I'm trying to post a new record to my Zoho Creator app via the REST API POST and JSON format, but I get a "500 Internal Server Error" back. I'm using the format: http://creator.zoho.com/api/private/json/<applicationName>/<formName>/add/ What might I be doing wrong?
How to have seperate filters ?
Hi, Currently all the filters are put in 1 drop-down list in the View. Is there any way to put seperate filters for seperate fields ? And a way to define the combination logic (should be "AND" anyway) Thanks
Workflow Recommendations...
I am looking for recommendations on how to handle the following: 1. I have a form that collects inspection data. 2. Inspectors will check anywhere from 1 to 15 boxes per each shipment recieved. 3. To keep the "size" of the inspection form on the manageable size, I have set the form up so that a user will enter data for "one" box at a time, submitting the data for "one" box and repeat entering the additional boxes to be checked. 4. I then set up a "view" where the data is grouped by the
Another Defect ...
Just noticed ... In List Views ... when specifying Set Criteria ... with Show Restricted Records ... it lets you select the Field Name and the Field Value ... and allows you to click on the Done Button ... but when you return to this section, the Field Name is reset to Modified User IP Address. Tried it in multiple Views with different (single line text) field names ... same result. Is this another case of Another Update ... Another Defect ????? In any case, it needs to be corrected urgently as
Missing fields from report screen?
Hello, I'm trying to create a report based on a form I've set up in Zoho Creator. The form has five fields, but when I try to set up a report, only one of those fields is available to drag into the report. Searching for the other four by name shows no results. The field that's showing up is a 'single entry line' field, and so are three of the four that are missing. Does anyone know why these other fields aren't available on the report screen, please? Thank you! Emma
Number of Form Fiels Available? I need to have a form with many many fields........
I have run into a problem. I need to collect data various data on a form. I have to collect sampling data on 13 items subdivided into 6 categories having aproximately 7 to 10 questions each. For Example: 1. We require our inspectors to inspect boxes. 2. For the number of boxes recieved, a certain amount need to be inspected. 3. Each box will have 7 to 10 questions that must be anwsered as to the condition of the product recieved. Once the data has been collected, various
Maximum size limits to a Zoho Creator database
What are the maximum size limits that Zoho enforces for a database application (gigabytes, records, forms, views and reports)? Is application performance impacted when a database gets large?
Creator (Form) that do not require user log-in (public access)
I been trying to setting some form as public access, but their status are still "pending". Please advise. Thannk you.
Printing PDF reports as a shared user
Hello, I am the creator of a Creator DB and pivot table. I can print the PDF when I'm logged in as myself but have no option to print the report as a shared user. What am I missing?
Question with regards to Data retrievl from Zoho DB
Hi everyone I am hoping that someone can shed some light for e on the following IT solution I am trying to scope out, I am using airset.com as a cloud server for my client and I wish to create forms with the Zoho creator that can be deployed to the cloud so the team in the office can sign on to the cloud enter the data into the form and all data is recorded onto the Zoho DB. Now before I go any further I am not looking to use Zoho free I will be using the highest level of service plus probably an
Intermittent strange text artifacts in Free Flow editor -- what is it?
I occasionally get very odd text artifacts in the free-flow editor (image below). I've seen this effect in both Firefox 3.66 (Mac) and Safari (latest version), and I think I even saw it in Chrome (Mac) one day when trying to escape the effects. For no clear reason, the editor sudden displays a shadowy replica of the code in light gray shifted down a few lines. It creates problems with cursor placement and readability. This effect is intermittent, not all the time. But I've seen it almost daily.
How to support key-value in drop-down ?
How to let drop-down to display "United States" but to save just "US" to DB ? Right now if it displays "United States" then it will just save the same thing to DB when submit the form
Usage limits for deluge statements
Hi I am currently accessing the free edition of ZC. I understand the following user restrictions apply for the free edition: 1. Maximum number of executable statements per deluge action (e.g. on load or validate or on submit ) is 5000 2. Get Data statements per day - 500 3. Post Data statements per day - 500 Can you please let me know if the above limits would stay even if I were to upgrade to paid member? What would the revised limits be? Regards, Varath
Is there any way to filter releated fields values with dropdowns choise?
Hello! I have two views with records like View 1 Field A 1 2 View 2 Field A Field B 1 A1 1 B1 1 C1 2 A2 2 B2 2 C2 Both views have fields 'Field A' with values corresponding to each other I need to create a form 3 where selection 'Field A' value = '1' in dropdown for the 'Field B' will show only records 'A1,B1,C1' (releated to 'Field A' value = '1') and on select 'Field A' value = '2' in dropdown for the 'Field B' will show only records 'A2,B2,C2' (releated to 'Field A' value = '2') is there any
Creator "Pivot Reports": suggestions to improve
The image below illustrates several issues with pivot reports sent to PDF No way to customize the reports The date shown for the report is in GMT, not the designated time set in Application Settings; in my case, Mountain Daylight Time (US) --- most folks reading this report will not understand GMT time. All of the gray shading in the columns makes the report more difficult to read and uses printer toner In this example, the "Total Paid Hours" column should be resized smaller (and centered!) to match
Problem when the labels on the form are aligned on top of the fields
ZC Team, I meet another case of broken functionality after an update, and, my luck as always, this happened when deadline for my application is very close. I appreciate a lot the new feature which allows users to place the labels in a form on the top of the fields. So I used it, and it worked OK by yesterday, when I saw that an important form from my application ceased to load. The scripts at on load section works properly if the labels are aligned on the left, but if the labels are aligned on the
Cannot figure out How to create professional looking finished survey e-mail? Please Help!
When I have an employee complete an inspection/survey the e-mailed product contains all the questions and answers, but the e-mail has no definition, its hard to tell the questions and answers apart, and it is hard to distinguish what is what. Is there anyway to edit the e-mail view I am receiving so I can share the results with clients and they can understand what they are looking at. Example: Bold answers, different colored questions, even lines or spaces separating each question. I’m new at this
ACCESS DB TROUBLE MIGRATING TO ZOHO
Hello Whenever I try and import my access db to Zoho creator orreports I keep getting an error "index was outside the array" Any idea how to solve this? Thanks!
Confusing script save message
It says "Script modified" It says "Please wait" "Please wait" goes away and script modified stays. It always stays. I'm confused. If I'm compiling and waiting why does it say 'Script modified' simultaneously?
Global Search
Over the years several people on this forum have asked how to build a global search. Unfortunatly I could not find an answer in the forum. I need the user to enter a search string and then a view of all records that contain the string in any field is returned. Any suggestions? Herb Wexler
Pre-production server updated with Latest Updates & Bug Fixes
Dear Users, We have updated our pre-production server http://precreator.zoho.com with the latest updates and bug fixes. Listed below are the changes that have gone in this build. General Fixes In form edit mode, if the 'height/width' values of a field are empty, it will be filled with default values. Grid View Record Saving error fixed. When a decimal field is hidden and has more than 10 digits apart from a decimal value, record was not being saved. It is fixed now. When a new view is saved out
How do you restrict viewing of solutions?
I am using Zoho Creator Helpdesk through Google Apps. I want only certain users to be able to see the solutions. I couldd have some private and some public, but if the only way to do this is to make them invisible to all but the techs, that is okay to. I tried to use the criteria for the Solutions List, but could not find a way to make this work. Any ideas?
"New View" = "An error occured"
Tryng to add a new view only gives a "An error occured..." I have tried Summary view and HTML Page.
Is it possible to get extra reports on an add-on basis
Is it possible to pay for extra reports as an add on? I certainly don't need an enterprise account, but I would like to have 5 or 6 different reports. Any way around this?
Please Reply this----Very Urgent Problem in Application _Zoho Creator
Hi Team I have some problem in my application .Now I Can't write script or I can't duplicate the application. I allowed you to access my application.Please response me as soon as. When I click on the Script or one of my View it shows the error [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' Report this problem to support@zohocreator.com Please Help
Stateless Fetch, Update, Add
I have a stateless form and I have the fetch and update working fine. The questions I have is; How can I add an "Add Record" option to my picklist so an add record can be initiated from the stateless form?
Next Page