Making a new printable list from spreadsheet view
I'm betting what I want is simpler than I know--however, I have been searching for weeks now. I do not understand scripts or functions, so most of what I'm reading is going over my head. None of it seems to apply. If there is a thread that already discusses this, please post the link for me! :) Okay, here's what I want to do: weekly I enter store sales data into my Form. I then go into the Views, create a new one and filter out just the specific content (Store name, week, sale) that I want
Run a Excel calculation using input value upon action then output the result.
Here's what I am looking for. user fills out a form. then we have a blank box and on the right hand side we have a "calculate" button. as soon as the calculate button is pressed it will bring the user input values to an Excel sheet Excel sheet will look up on MS ACCESS file to translate the user input values into a number then do calculation then the calculated value in "certain" cell will be outputted into the black box. would it be possible to do it with ZOHO creator? because from the maintenance
I would like to give a initial value to a Lookup (multiselect field) dynamically from a user input.
In my samples form, I have a look up field sample type, from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a look up field parameters, from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_types form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the the parameters chosen.
How to get submitted application data to another application?
I have two applications and I need to take a list from the first application to insert into the second. How can I do?
How to login from my domain to Google Apps mail using zoho creator ?
hello, I want to setup a login form in my website where people will enter their google apps login to access their google apps mail. How to do this with Zoho creator forms.
How to only display a URL link to an uploaded file if only one of the four is actually uploaded in the form?
I have a form with 4 optional image uploaders. When the form is submitted it emails the input of the form fields and 4 links to the uploaded files. What is the script to only display the link in the sent email if for instance only 2 images were uploaded instead of 4?
Custom action on view
I want give the option to users to edit a field (radion button, with two choice : "Approved", "Not approved") by a custom action on a view. I want to change the Status "Not approved" by "Approved". I wrote this function : void status.Approval(string TheStatus) { if (input.TheStatus == "Not Approved") { input.TheStatus = "Approved"; } info input.TheStatus; } I added this function to my view : custom actions ( "Approve" ( function = status.Approval(Status)
Cannot use passed parameter while setting new variable in HTML view
Although it seems to be this is one of the most basic things one might need to do, when I try to use a passed parameter in an HTML view to set a new variable, it says the the parameter is no declared. Am I doing something obviously wrong? If I want to declare a variable, I use "set variable", right? Then if I click on the parameter under "variables" in the script builder window that pops up, it says it's not declared. Please, I need help on this asap.
CANNOT IMPORT DATA
For some reason, every time I try to import data (either CSV, XLS, or even pasting it into the form), when I hit 'OK' the page just does not post correctly. I tried the same file on multiple PC's and get the exact same result. This problem seems to be new, since I was able to import data 1 day ago. Did something change with the 'import' function? Any help would be greatly appreciated. The 'page' erros are below: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT
I would like to give an initial value to a lookup field (multiselect) dynamically.
In my samples form, I have a look up field "sample type", from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a lookup field "parameters", from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_type form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the parameters chosen.
Why doesn't the Help topic for open Url tell me how to open a view while passing more than one parameter.
I need to open an html view, and pass 4 parameters. I see that I can pass one using the example: searchUrl = "#View:Employee_Search?searchParam=" + input.searchEmployee; openUrl(searchUrl, "same window"); But what about when there is more than one?
Can a numeric field generate a number by itself?
I want that a numeric field generates a number, and iterates it. Also I would like to give a special number format, like : YYYYMMDDiteratednumber. Is it possible? I went through ZOHO creator tutorial, but i didn't find it. Thanks
Auto numbering
Hi, can soneone describe in simple terms how to auto number a field. Thanks
Create a View/Report?
Hello - I just switched to the paid version of Zoho Creator and am trying to figure this out. can someone help? I have a form that contains a drop down field with 4 options: AAA BBB CCC DDD I am attempting to create 4 individual reports or views that are password protected and based on the selection of either AAA, BBB, CCC, or DDD. (So you can view all the records that include one of the above selections) This is simply a commissions report Can anyone assist?
All forms form one application migrated to another application
Can I easily migrate all the forms/views from one application to another? I am trying to consolidate several applications into one......
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
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
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!!!
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
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
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
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
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?
solari board using jquery
hi, does anyone know how to make a solari board animation using jquery?
Multi-Line field with Line Break
I am using a script to add information to a Multi-Line field. Is there a way to force a line break. I tried adding <br> but that just shows as text in the field. Herb Wexler
Can't input data into forms
I was using ZohoCreator fine about two weeks ago to build out forms and views and start to add data. I came back last night and tried to add data in a form, and several times, when I hit submit, I get a "Please Wait" circle icon that never goes away. I cannot input data. It seems ot be an an issue with this particular form, as another form works. How can I troubleshoot the problem with this form?
Integrate Zoho Creator an Zoho Invoice.
I Need to develop an application to provide functionality to Zoho Invoice And it currently does not possess. Can I connect Zoho Creator with Zoho Invoice to read the customer data and invoices? Thanks,
Problem: error [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Hi team 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 You can access my Application
Need to Edit a Form to Automaticly move to the next filed by pressing enter
Hi There I need Help I Have the following Form Created, and i need to modife as described bellow 1. Date Time - Need That The Date and Time will be choosen Automaticly 2. Drop Down Menue - Choosing sales rep - and move to the next filed 3. Number Filed - Scanning Barcode - after it will scan i need it to move to the next Filed 4. Number Filed - same 5. Number Filed - same 6. Number Filed - same 7. Number Filed - same 8. Number Filed - same 8. Radio Botton - After Choosing up or down
Questions, help, broken...
help, bug! issue answer this These subject lines don't help the community any bit. Make your subject line descriptive people!
How to preview HTML page on mouse over
Is there a way to preview a html page with only a mouse over (over a link in a view) ? Thanks in advance for any help. Pascal
Getting HTML Form Builder & Online Database Software to show up under primary username
Hello! I'm new to Zoho. I really like the HTML Form Builder and the Online Database Software and want to be able to include these in my marketplace apps under my username. I don't seem to be able to - both are asking me for new usernames and will not allow me to log in with my existing one. Help?!?
Public URL's... Save yourself some headache..
Zoho Creator's public URL string system is many things.. 1. Wonderful Feature for quickly sharing views 2. Consistent and stable (the same string is generated and used for a single view's different data types; hash,perma,html,xsl,json, etc) 3. It's a pain to build private but quasi-public facing applications! I've written many public URL manager functions (holding all your public string URL's in a static map variable an then referencing them that way). One thing I came across when doing some work
Opening forms to anonymous users
Two questions: I am experimenting with forms to see if I can open them to potential users, but anonymously. According to the documentation, this is only available by special request to Free Edition users. However, when I try to fill in the request form the captcha image is broken. Is it possible to send forms by e-mail and have them filled in by the e-mail user and send data back to the database? Is there any documentation on this? Thankyou
DATE FIELD IMPORT ERROR
Hi! I don't know why, but every time I try to import date fields into a form, all the columns of the .csv are imported correctly except the date one. I've tried with many formats dd/mm/yy , dd-mm-yy, dd/mm/yyyy, dd-mm-yyyy, etc... Of course, I've tried with the app date format ( dd/mm/yyyy ). When I import I've no error message in the date field, neither in others, and even more!! The data field is required to fill up the form and it's empty after the import process!!!!??? Please I need help. I need
Next Page