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
Single Item View vs. Letter
Hello, i have created an application handlin a list of users and some infos about them. I do sound sendmail stuff etc. One feature i was thinking about to implement remains unsolved. I can#t find a solution: I would like to have a button per row (like custom actions) where I can generate a Single View of the Item in the List View. For example a Page where I have a Letter with static Text and the (dynamic) infos of the row (person) like address, name etc Has anybody an idea? thx
Autopopulated one drop down and another from the first depending on what is selected
I am new to zoho and to creating db's and view etc, I need to create a nice little way to track all off the loot i get while hunting in my favorite game. Something like this... Application Title - AfterWorld Loots The Form Add Loot Select Zone: this would be a drop down box that is autopopulated with zones that I have added using the "add zone" form Select Mob: this would be a drop down box that is autopopulated based on what was selected in "Select Zone" Select Maturity: this would be a drop down
Page Break in E-Mail
With regard to an email generated by "Creator"... Is there a way to insert a page break for printing? I'm using ZOHO's "Creator" to generate a report, of which I need certain pages to contain isolated data. Any help is appreciated!
Is this Possible
I would like to have a quoting system for my web site. I envision a series of 4 dropdown menus. The client would choose a product from the first dropown. The next dropdown could be color, followed by quantity etc.. I would then like the form to total the cost based on their input and display the quote to them as well as email me. Is this possible... Yes i am a newby
Creating Views Dependent on a Value in another Table
I am wanting to restrict a view based on the client who is looking at the view. I have 2 tables. User Table: This contains the User Name, Email and the Client Name View Table: This contains all sorts of fields including Client Name Any suggestion on how I would restrict the view so only records that match the Client Name are shown? Producing a new view that has a filter for each client is not very workable, as I will have to create a new for every new client. Glenn.
RadioButtonSet.Select() does not invoke RadioButtonSet.OnUserinput()
Hi, I have a radio button set. I'm using the .Select() statement to programatically select a radio button option. I'm expecting that when I do this that the code behind the radio button's field action OnUserinput() will be called. But this is not happening. Once I issue the .Select() how can I invoke the OnUserinput()? Obviously when I use .Select() I'm expecting that it would behave as though the user had selected that option. Any ideas or workarounds? Thanks, Tony.
Shared
Zoho team, I have been invited to an app, twice, but still get the message : You are not authorised to access this application in Zoho Creator. Go to Home Maybe you guys can take a look at this?? Regards, Danny Sterke
please help me..need to disable "View Log Details" on my form
please help me..need to disable "View Log Details" on my form
Dynamic HTML view
Im wanting to embed a view that displays a record based on a field value For example; <div elName='zc-component' viewLinkName='Class_Details' params=' " Where field 'teacher' = 'Mr Baldwin' " &zc_SecHeader=true'></div> This should be ver simple - although I cant seem to make it work - not sure of the sytax However I need to take it one step further... lets say instead of 'Mr Baldwin' being a record in the form the view is based on, lets assume its a related field in another form (related as he would
newbie and reports
Really dumb question but I usually use ms access and thought that I would give creator a go as it gives me much better mobile access. I use reports inacccess how do I achieve that here. I probably need a book as i did in ms access. I looked at the videos but I think there very poor quality
Empty Dates
Dear Sirs, I wish to do a picklist of all the values I have in a field where the date has not been filled yet. However I'm not able to search for null or "" or Empty dates. The Script I'm using without success is: AWB ( type = list values = Control_Valijas[(Fecha_Arribo is null)].AWB ) Do you have any solutions to this issue? Thanks for your help...
Nested
Hi again, I have a table "Tasks". I'd like to be able to make tasks nested. I'd like to have a field that is a lookup on the Tasks form itself. Eg. I'd like the Tasks form to look like this: Task ParentTask Wash all dishes Wash cups Wash all dishes Wash plates Wash all dishes Wash bowls Wash all dishes Rinse cups Wash cups But as far as I can tell, this doesn't seem to be currently possible? When I try to
Clear Multi-Line field
Is it possible to clear a multi-line field using script?
how to create a form that inputs data to another forms database table
Hi, I have a form that inputs data to a database table. One of the aspects it inputs is "team", because there are more than one development team. I have created a second form exactly like the first, but with the "team" field preset that I will give access to one of the teams. When they input data, they don't have a choice to select the team. However, the data does not seem to go into the same table as the original form, because it never shows in the view I created for the first form. Does each
Unable to update Multi-Select field in another form
Hello I have the following code in the "Edit - On Success" event of my frmCountry_Market form: for each recP in frmPlayer [Market.contains(input.Market_WithCCode_before_edit)] { newList = {"item1", "item2", "item3"}; info newList; recP.Market = newList; } One recP record is found (the list newList is displayed in a log message). 'recP.Market' can not be set. This is what the log says: "Unable to update data on the form variable null" I tried updating another field in the same form (recP.Name
More complicated scripting based on Time and Graphs?
Hello, I just discovered the Creator section and I find it really magnificient. I am considering creating an app that is unlike any that I have seen developed so far. I would like to make use of the graphs. I work with groups that I want to support with data that is taken from the forms they fill in. For instance: - So far today your average is 10 (on a ranking from 1 - 10) - Here is your perforance today. - You are less than your average for the past week. - This is your progress over the past two
Reference Fields
I need some help. Zoho is great at editing literal records but I am having a hard time making a useful application that does not mirror a DB record. 1) given --- form PERSON known by ID has Last Name has first Name --- form COUPLE lookup PERSON.ID for man lookup PERSON.ID for woman Now when I build the COUPLE form I want to use a reference of ID back to PERSON twice, but I can only fill a drop down list with abstract IDs. I want the drop down to shown the names (First, Last) but then once I select
Application sharing not working
I have entered the correct email as a user to my account. I have shared 3 views to this email. Still the application does not appear under 'Shared Apps' (Home). If the user tries to access it directly (by clicking the link in the email that was sent to him when I shared the views) it says that he is not authorized. What to do?
Email Notification Based On Separate Date & Time Values
I have a delivery scheduler application and I need an email notification when the requested delivery date is tomorrow and the added time is after 2PM today. I've been trying everything I can and have been unsuccessful. Help please!!!
Help with multiple field lookup and returning a SUM total
Hi all, We are recent ZC converts and we’re trying to build a Job Management application for a creative agency. The application will manage: - Job workflow (Jobs contain different Tasks and Status’) - Track Hours per Task - Track total Hours per Job - Calculate Invoice amounts - Track Expenses - Generate Profit + Loss per Job The Jobs Form/View has these fields: Client, Job Name, Status, Hourly Rate, Actual Hours. The Logged Time Form/View has
Script runs slow
Hi When woring within Internet Explorer, our zoho application is requesting data from a table and is trying to dispaly this data in a drop down box that the user can select from. This was working ok until, to improve usability, we tried to request the data in a sorted [A to Z] list. Now we get a very slow response and this triggers a time out in Internet Explorer with a dialog box asking the user if they wish to terminate the script YES/NO? I have tried this in Firefox and while the response time
Simple navigation from one app to another
I want to have a click-able link in the side bar of my views to send me to another application. Seems like a simple request, but I can't find how to do it. Please help Wes
Trying to Create a Stateless Form
I am trying to create a Stateless form and am getting an error. I am looking up a field from one form and then trying to have it display relating fields that can be updated and then saved back to the other form. The form I am looking up is called Players, The field is called PlayerName. The fields I am trying to display are Team, Position, Owner. I keep getting an error and am not sure what is wrong. Can anyone help? The code I am using is ....form Draft { store data in zc = false
Next Page