Disable export in Zoho Creator
We have been helping customers get started in Zoho and ALL of them ask if Zoho can disable exporting and printing. This feature is key to protecting business data. I see that others have asked for this feature. When will it be available?
How to program dynamic calculation ?
I explain my problem : I have a Project , containing Steps (Step A & Step B, for example). My users declare activities on project belonging to step A or step B. These activities have a value of days (0.5 or 1 or more). I would like to have an dynamic udate of the consumption consolidating all activities declared by step. For example : 2 users declare activities on step A. 1 declare 3 (days). The counter of consumption for step A becomes "3". Then a second user declares 4 days on step A. Then
Can anybody help me?
I am very new on zoho creator... I want to know that.... Can I create a database like http://www.mintarticles.com.. It is an website that has an option for user of mintarticles.com. Users can earn money from that site. They submit article and then they will be get a bill for every article. If i can create database like that please send me some information... How can i create a database like mintarticles.com
Lookup field limitations?
I am creating a form for class registrations. I have one form which contains the details of the class, including drop downs for location, class type and state - and single line forms for name and other such things. I have a second form which contains the student registration. My goal is to connect the two forms in such a way that from the student form I can pick which class the student is attending. My goal is that when the class name is picked the other information, from the Class form, will
Questions About Column Sorting
I'm trying to figure out how to do the following, but can't find answers in the forums... How to visually indicate sorted column(s)? How to un-sort a column? How to un-sort any / all columns and apply sort to different column, all in one step? How to make it clear which is the primary sorted column and which is secondary? Any advice would be greatly appreciated. Thanks!
Layout when trying to Edit Forms ...
@ZOHO Creator Team When I went to edit a Form in one of my old Applications ... found the layout to be messed up (see attached image). This happens for most of the Forms that I tried (being a Lab Application, there are many many Forms in it) ... but not in a few other Applications I just tried. Please address this urgently ... as I can not edit the Forms as they stand. f.y.i. I am using Firefox 3.0.14 under Windows XP Pro SP3. Gaev
Requesting Ideas / Help in Creating a Dynamic Table on Zoho E-Mail
Hello. I've been developing an order processing Zoho application for one of my clients. I would like some ideas / suggestions / assistance on helping put together a "Receipt" e-mail that creates a dynamic table or as a minimum the right amount of items on the e-mail message of the Receipt. I have multiple items and need to put them on a dynamic table (so it grows with the size of the pulled data) where for example: Table: PN Description QTY Price Ea. Sub-total
Linked Dropboxes - For Example State and City - Possible?
I'm building an app to accept a US address (among other things). I'd like the user to select the state abbreviation from a dropbox containing 51 values (the 50 states plus DC). Then I'd like the city dropbox to autofill with *just* the cities in the state selected. I have the full list of city names in Excel. But I don't know how to code the dropbox linkage. Is something like this possible? Thanks!
Nice Form Formatting
I just came across a public form at http://creator.zoho.com/beltz02/ja-finance-park-date-signup/form-perma/JA_BizTown_Date_Signup I like the way the fields are grouped into two columns. How is that done?
Filter a view via a function using more than one argument
Hi All, I've created a simple function that will filter a pop-up view by the name of the associate (see code below): void basSelectedInterpAvail(string Associate) { //This code will open a view which displays a list of all of the speakers of the selected language, displaying their availability information. openUrl("#View:vwLangAvail?cboAssociate=" + input.Associate + "", "popup window", "height=100,width=100"); } I'd like to add an addtional argument that would further filter by the language spoken
Form vs Tables in Zoho
This part of Zoho is confusing me- In Zoho are forms the exact same thing as tables? Is there a way to view and edit the tables directly? e.g create new columns, without using a form? Can zoho use different forms to edit the same table? For example I want to use the inputs of two different forms to be related and be in one table.
Download file that has been added to the ZC application via File Upload field
Hi Team, The form uses the "file upload" field to upload documents (doc / exls/ pdf/ txt) -- This is working absolutely fine -- I am able to upload a file & submit the form -- I see the file (course.txt) in the view as well However, when i try to access the same txt from the view (ie.. download this file from view & see it) .. the url just displays this string (http://creatorexport.zoho.com/DownloadFile.do?filepath=/1253261765429_CourseList.txt&sharedBy=worlduplanning&appLinkName=worldu-data-tables&viewLinkName=Issue_Tracker_Resolved)
Why does ZOHO Creator do this ?
ZOHO Creator Team: When you type something like ... input.Field1 = input.Field2 + "something"; ... if Field1 is mis-typed, ZOHO Creator does not point that out at Save Script time ... instead it decides to turn it into ... Field1 = input.Field2 + "something"; ... i.e. turning it into a variable ... this then causes Run time unexpected behaviour ... resulting in time spent investigating the cause. What is the thinking behind such an automated change ??????? Gaev
Show Image on Form
Hi all, In an application I had on a Form,a upload field, and a Notes field, to upload and show a image. The Notes field contained : <img src="http://creator.zoho.com/DownloadFile.do?filepath=/" +\logo_upload="" +="" &sharedby="username'"> This used to work, but now it doesn't work anymore. Maybe somethin broke, or did I miss an alternative way of show images on a Form? Thanks, Danny Sterke
Error Creating a new Application from an Excel Spreadsheet
I am trying to create a new application based on an existing Excel Spreadsheet. I went to "Create New Application" and chose "Import XLS" on the left side. I specified the application's name, checked "Import Data" and selected the Excel file to import. It then brought me to a screen where I can choose the Field Type and Label Names for each column. Very cool. This is exactly what I was hoping it would do. The only problem I'm having is this. It says "We have identified 'Field Type' based on
Edit link in HTML view - Dialog problems
Hi everyone, I'm creating an HTML view that's similar to a list view, and would like to include "Edit" links for each entry. I've gotten as far as: The edit link pops up a dialog of the edit form When you make changes and press submit, the edits save successfully.I have two remaining problems: The dialog does not auto-close, you have to press close at the top, and If you then try to click "Edit" again, it no longer works. My edit links look like this: <a href="#Form:Time_Entry?zc_LoadIn=dialog&zc_NextUrl=#View:This_week_s_time&recLinkID=<%=id%>&viewLinkName=Time_Entry_View"
Send Mail on Update Question
Hello, I am setting a simple script that should be sending an email based upon the script syntax below. This same script works with the "on add" command but not with the "on update" command. Any advice would be helpful. I don't want this email sent until the person entering the data presses submit, which is what I thought the On Update command did. The on add command sends the email immediatly, which isn't ideal. Thanks if (input.Edge_Device == "211a") { sendmail ( To
One to Many Relationship (Parent with several Children)
I am creating a registration form, in the form I have created a decision field asking the user if they have children. If the user places a check in the box (Yes they have children), I would like to have a prompt for the child's name (First, MI, Last), birth date and drop down menu to select age range to be displayed. If they have more than one child, I would like the user to click on an Add button to add more names, birth dates, and age range selection. I would assume another table would have to
Count Function- look at multiple fields
I want to put a limit on the number of campers that can sign up for one session. Campers can sign up for up to three session. Let's call one of those camps "Open Age #1". Open Age #1 could be selected in lookup one (Camp_Session_1), two (Camp_Session_2), or three (Camp_Session_3). I've got my current code below that should check for records and alert if the limit is reached. It does not seem to work correctly. Can anyone spot my error? Thanks! max_people = 0;
if ((((input.Camp_Session_1 == "Open
How to Auto-Increment a Numeric Field for Multiple Submissions within Same Browser Session?
I've got a form that asks users to supply a set of data. They may submit one or more datasets per browser session. One field is a date field. Another field is a numeric field that should be "1" for the first dataset submitted for a specific date, "2" for the second dataset with the same date, "3" for the third dataset with the same date, etc. They can also enter a different date, for which the numeric field should reset to "1" and increment by 1 for each subsequent dataset submission for the
translation of commands
in the views we have word-actions like "More actions" "Print" "Import Data" "Export Data" how can i translate them into another language ? also can we have opportunity to have in 2 languages our applications like websites?
Column Sorting Problems / Questions
I'm a newbie to Zoho Creator, so I apologize if these are stupid questions, but I can't find answer in the forums or in google. I've got a form with many columns. When I sort by one column (let's call it "A"), it works, but there's no visual indication that column is the one sorted on. When I then sort by another column (let's call it "B"), it also appears to work, but it seems to be sorting "B" *within* the already sorted "A". I'd like to find out how to do a few things: 1) Visually show my end
How to fetch a record where column condition value is in between the values of two records
Hi, Example Table Pricebook: Weight Price 0.5 100 1.0 200 1.5 250 I have another form where the user enters the item required and the weight as 0.8. How do I search through the records to obtain the record with the higher weight than the user input value. i.e. in above case it is the record with weight as 1.0 A solution to this will be greatly appreciated. Thanks!!!
How to DYNAMICALLY redirect a form page?
I want to add a dropdown list on my form. Depending on the choice from the dropdown, the form redirects the user to a unique page. Is this possible in Zoho? Thanks,
Help Request Form
I have a form that keeps record of submitted requests. I also have a sign-off by administrator field that has a "work in progress" "pending" "completed" that is filled out once an administrator see the form and attempts to take an action on the request. Anyway I want to be able to filter through requests that have been submitted that has no sign-off status because when requests are added we need a way of searching the filters for those that have been added but not signed-off. There is no option for
Order Form
Hello, Please can you help me to create an order form like this 1st item 4$ ENTER QUANTITY1 2nd item 6$ ENTER QUANTITY2 Total = QUANTITY1*4 + QUANTITY2*6 Please can you help me to get a visible and live updated total field Thanks a lot Olivier
Grouping with a multi-select field is currently useless
In most cases when grouping records in a view depending on the contents of a mulit-select field, the user requirements will probably be similar to the following scenario: A diving school has three types of diving courses (A, B and C). Each diving course can have multiple instructors. Now the user wants to create a view that shows, which courses an instructor is assigned to. Zoho Creator would display data as follows: Mary, Paul Course A, 01.01.2010 Course B, 01.01.2010 Paul, Peter Course B, 02.01.2010
to know status of field (hidden or shown)
i have 10 fields which are hidden at the LOAD of form, and depending to the select of user can be shown. i need to know status of fields at the submit action. it's like if ( field1.status("hidden") ) { do something; } else if ( field1.status("show") ) { do anotherthing; } how can i do it. which command is it?
Realtional Database
I am new to database work. I need two simple forms 1. Apartment Form - with a "tenant apartment number" and a "tenant phone" feild only. 2. Repair Form - with an input feild "tenant apartment nunber", a "repair needed" feild and a "repair telephone" feild After all tenents are entered in the Apartment Form database, I would that on the Repair Form I could just enter an apartment number (not a dropdown, but enter it via keyboard) and the tenants telephone shows automatically in the "repair
Multi-select response triggers action on single-item field
Not sure if that title best describes what I'm trying to do but I hope that someone can help me with the coding for this problem. I'll be asking about a series of questions for which data may not be available, e.g. height, weight, shoe size We like to have a response for every question, i.e. no blank values. For dropdown fields, we'll include an "unknown" value, but to handle single-item fields, I am thinking of including a field (multi-select or checkbox) that allows people indicate that data for
how to create 4 mutualy dependent lines
Hello, similarly to a country/state dependent lines where accoridng to the country you choose, the seocnd line "state" would adjust to the choice of the country, i need to create 4 linges that each depends on the previous line choice. First line for examp,e would be maths, french, english if you choose french, a subset would appear , for example french litterature, french history and french arts. Then on the 3rd line, if you choosse french history, appears a subset of choices "french literature
Check if email field is blank before send mail
Hi everyone, in order to promote my blog I created a simple form so that visitors can tell there friends to come.It looks like this: Visitor's have to write down at least one email of there friends. How could I check if optional email fields (2,3,4) are not blank so the sendmail script does not bug? ("To:" field doesn't accept blanks...) Many thanks!! Sébastien
Multi-Select Field: Sorted in Edit mode, but unsorted in View
I have a Multi-Select Field which displays all values (selected and not selected) sorted in Edit mode. But when I save the record, the selected values appear unsorted in the List View. They also appear unsorted when I read the values with an html View. Further info: The field's property to sort the values is selected (field properties) I modify the field with Deluge script in the On Load event and use the built-in sort functionalityThanks for any help. Filip
Re solutiong for how let customers to easy place order
Hi I hope got bloow interface for place order by customer,how do that? I tried ued "for each list value" to read a Multiple List (it's a product list) , but do not know how to let about customers to input the number of urgent,hope you give me some recommendations and your solutions, thanks! Stanley Guo
VERY VERY simple application
I am having toruble creating a very basic application where: Users enters 6 fields including 1 link to a picture and the application creates a new html code. (i already have the html code and know where the 6 fields should go) please help PS the input part is already created i am having trouble creating the view
empty fields
Hello, I have table and i would like to create 2 different views with 2 different criterias. one criteria is: that a multichoice field called "received" is empty. in the form its a yes / no choice, but since i cant choose a default value (which would be "no") i have somehow to also define the state that the field is still empty. But i dont get it: it doesnt work. I tried it with length = 0 with !="" but i don't get it And the other criteria is that a DATE field is empty. i thought about it and than
"Invalid entries found..." Error When Updating with Multi-Select Lookup Field
Here is the app: http://creator.zoho.com/tombest610/cfcsongs I have opened it up to support access. Problem: When I choose values for the "Sundays" field of the songs form, I get the error message "Invalid entries found. Please correct and submit again." It works fine when I make it a single-select instead of multi-select. Can you tell me what I'm doing wrong? Thanks. Tom Editing this... to add... I just noticed that it works fine for adding new records. I added one with Title "zzz TESTING for Lookup
Cannot copy application
I cannot copy my application? It appears to work, but does not present me with a copy. Thanks
How to define the size of a multiline input?
I want to make the box (on the screen) larger for a multiline field. I see how I can do it with zc_TextAreaWidth & zc_TextAreaHeight if I were embedding the form in a web ap - but I'm not - I just want to change the look of my multiline box on my regular "form". Can it be done? Thanks
Who's Online?
This is customer support idea I'm toying with: I made an html view that checks to see if I'm signed-in, and then alter the html view to display my status: htmlpage ONLINE() <%{ if (zoho.loginuser == "niskypto") {%> NiskyPTO's online<%} else {%> NiskyPTO's offine<%} }%> > This view was then made public . Now if I (or you) open another browser and view this page, the view say's I'm not online. But in my browser, it say's I'm online. Clearly, I'm missing something. How can I make
Next Page