Auto populate a table on a form in Zoho Creator based on what was select from a drop down above
Thank you all in advance!!! Currently, I have a drop down field on my form that when I select a value in the drop down, a drop down field below is auto populated with a certain values depending one what was selected on drop field above. Keeping that in mind, I have some fields above that are not auto populated such as check boxes, calendars and radio button. I would like to shorten my form so it would not have so many fields. My goal would be this After I select my value in the drop down field,
forms: show list A as multiline, combine with picklist B, save every A-B as a single C value
Hi, how can I do the following form C? There are two lists A and B. In form C, all A values are listed. There each A list value can be combined with one B value by a picklist. On submit, every single A-B combination is saved as single C value. Thanks
Changing Field Names via Form Definition
When the form is in edit mode, you can change its name and display string, but you get an error if you try changing the name through the form definition. If you make lots of changes all at once (as I did when I applied a naming convention), it's cumbersome.
Form formating
Hello, I am new to ZOHO but am finding my way around fairly easily. I am building a application which has a couple of lenghty forms in it. Is there anyway to change the format of the form to 3 columns so that i can fit all the fields on 1 page? Thanks Steve
Format a Number Column
I have a simple count routine in an application that updates number in a column. The highly unsatisfactory rendering (at least in Firefox) looks like this: Please don't tell me I have to render them as text to make it look better
POST the XML String Without A Form
How do I post the XML String Without A Form?
Control over the default sort order
The default order for sorting of records in a view seems to be the inverse of the order they were entered in. Is there a way to arbitrarily change the default order?
Line Feed in multiline field on stateless form
I am trying to inset a line feed into a multiline text field on stateless form using script called from a button. I have seen other posts on this topic but have been unable to get this to work. When the user click the button, I would like the multiline field to populate with text and input fields seperated by line feeds. Following is the script i am trying to run with no success: RateTextProperty = "Property: " + input.Property + "<br>"; RateTextRate = "Rate: $" + input.Rate + "<br>"; input.Rate_Text
Automatically open and filter a view
I've created a Jobs database whereby you can create Tasks and assign them to Jobs using a unique Job number. I'm trying to find a way whereby when a Task has been created against a Job, after the Task has been submitted, the Task view automatically opens but only displays the Tasks assigned to the Job in question including the recently added Task. I've been trying to do it with 'OpenURL' but not sure if this is possible. Any ideas? Martyn
Zoho Creator - Vincular formularios
Hola! estoy realizando una base de datos con zoho creator y tengo un problema. POr un lado tengo un formulario con los datos de empresa y por el otro tengo un formulario con los contactos de estas empresas. Querría vincular estos dos formularios para que quede toda la información ligada. Como puedo hacerlo? Gracias, Sandra
Can not Select Text in HTML View Freeflow Mode under IE v7
I had reason to access ZOHO Creator from my IE v7 Browser (instead of my usual practice of using Firefox) ... when trying to edit an HTML View using Freeflow Mode ... I could not "select text" with my mouse ... tried it (unsuccessfully) in a couple of Applications ... same attempt under Firefox worked just fine. Gaev
How do I update data on the DB that was input via a Zoho form?
I've created 2 test forms and started entering data via the forms. How do I now go back and access the DB to update selected fields? Can someone point me to some examples or tutorials? Thanks, Rocky
Calculation based on total numbers of a particular field
I would like to create a field for Total Weight in my View. This would calculate all the Weights chosen over a period of time from the Weight Dropdown by user in my form Example: User: Chris Weight: 3 Weight : 5 And then calculate the total in a Total Field in my view Total Weight:8 Does anyone know how to do this? Thanks!!
Autocomplete - order of displayed options is different to order of given options
I'm using Jorn Zaefferer's Autocomplete plugin on a couple of different pages. In both instances, the order of displayed strings is a little bit messed up. Example 1: array of strings: basically they are in alphabetical order except for General Knowledge which has been pushed to the top: General Knowledge,Art and Design,Business Studies,Citizenship,Design and Technology,English,Geography,History,ICT,Mathematics,MFL French,MFL German,MFL Spanish,Music,Physical Education,PSHE,Religious Education,Science,Something
Dark Black Background when Editing a Form Field's Properties ...
@ZOHO Creator Team: Just noticed this morning that when editing a Form Field ... the dialog boxes that pop up to allow entry of properties of the selected Form Field (or Stateless Form Buttons) ... have a dark black background. If I recall correctly, you used to be able to see the rest of the Form and Widgets in the background ... is this a deliberate change from before ... or just another unintended result of the recent release of changes to the platform ? f.y.i. I am using Firefox 3.5.7 under Windows
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you Example: Choose "A" from a drop down list Then a list of values "1,2,3,4,5" will appear in drop down or any type of field below If you choose "B" from a drop down list Then a list of values "6,7,8,9,10" will appear in drop down or any type of field below
Fetch Record for IF statement
I am trying to figure out how to Fetch specific fields from another form, to implement IF statements in the first form. For example: Two forms: STAFF and RECORDS In Staff form is: NAME, Position type, and several Decision boxes -- Do you want to receive email if EVENT A, EVENT B, EVENT C In the RECORDS form: There are many fields, one is STATUS. So, if STATUS changes from NONE to EVENT A or EVENT B, or EVENT C, I want the database to go through each Position_Type, and depending on the NAME
Question - Group By and Sum within a View
Hello - Let's say that I have three records in a form with two fields (Product, Order QTY): Product A, 12 Product A, 37 Product A, 19 In a View, what I want to do is produce an output that looks like this: Product A, 68 I don't want it to look like this: Product A, 12 Product A, 37 Product A, 19 Product A, 68 Instead, I just want it to look like this: Product A, 68 Just one row and ORDER QTY summed together, grouped by Product. Is there a way to do this in a view? I've struggled with this... I can't
Can I fill Checkboxes from spreadsheet data?
I'm looking for the option to have a user pick an option from a pick list, and then have the script check boxes in a list from the data associated with that option. For instance if I picked Tennis from the list, the script would check 'racquets' in the equipment check list 'courts' from the location check list and 'college' from the level list. Any suggestions?
again VERY slow
since yesterday, saving Creator script is again extremely slow ! why is this happening so often ?
Import data in application/spreadsheet from XML feed
Hi, I want to ask, if there is any way to import data in my Zoho Creator application (database) or spreadsheet from XML feed provided by API server of webpage? I am trying to create online database here in Zoho, previously I imported data from XML feeds ad got neccesarry information from nodes by using MSXML v 5.0 in MS Excel2003. Thanks a lot!
Edit permission for restricted users for a public application (not all apps just the ones I specify)
I have an application that is public. I have given add permission for public to add to my application, however I need to assign edit permission (/admin previledges) to a specific number of people alone and not the public. I could not find a way to do this in creator, any help will be highly appreciated. Thanking you
Error Message
Illegal pattern character 'n' This is the message I am getting in my application when I try to edit a single record. What does it mean?
formula fild empty after add to form witm many rows
I add formula fild to form that's have around 7k row, all was ok, but in view formula value is empty. I make experiments, add an other formula with value 1, and see same story. As i know formula value recal after row update, so i update some rows, w/o change filds values, and formula calcs in updated row, i try more and more, some to all was ok, some a have error "Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting
Accessing information from other ZOHO applications
I would like to create a custom application accessing information from our ZOHO CRM instance. Is this possible?
jQuery JSONP Request Breaks ID Values
I'm working on an application which pulls data out of Zoho Creator using JSONP calls through jQuery to manage the cross-domain data exchange. I'm debugging in FireBug / FireFox. When I load the JSON data directly by pasting the URL into a firefox tab, the values in the Zoho Creator ID fields for the records are correct. But when I load the same data from the same URL via jQuery, the values of the ID fields are wrong. Specifically, the ID values are correct up to the last three digits. Some of the
Go to URL after submit
This should be real simple, but I can't get it to work (works fine with wufoo, jotform etc.). On 'submit' I want to go to a new page (URL) from the same site. The form (made with creator) is inside an iFrame on my site. I have used 'on success' form action On success, web data 'open Url' and have tried settings of open in new window, parent etc. Either it does nothing, or opens the URL inside the iFrame. I want to open URL in main window of browser (close iFrame and open URL). I don't want to open
how to make bi-directional relation - help pages not loading
probably my question is covered in the help section but I cannot access any of the help pages or videos... page not found. I need to make a bidirectional relation between two field in two form: I have a "journalist" form and a "media" form. I've added a lookup field in the journalist form that let me choose in which media the journalist is working now I want that a field in the "media" form show me that information. I could insert another lookup field in "media" form but I would have to manually
Import data from email replies
I have a public website form that gets filled in by external people. Upon submission of a new form, an email is triggered to 5 teammates so they may review and comment on the submission. I'd like to capture those comments automatically in the database by having them reply to the form email. On that same form are hidden five extra fields, one with each teammate's responsename on it to hold their response. How can I configure Zoho to automatically receive the emails and put the data from each teammate's
How Can I create a Report from a single data entry?
I have created a database form for a Healthcare Procedure, ie. PICC (peripherally inserted central catheter) Line placements. All of the data regarding insertion and any complications and dispositions must be documented. When the procedure is completed, a computer record must be stored in the database and a "Report" documenting the procedure for that patient must be printed and placed in the patient's (hard copy) chart. Is there any way that a Report can be generated and printed showing only the
info from one form to email data submitted in another form
how do i use a specific emailid from one form to send specific data of another form. Example: FormA has partner name and email address. FormB has a signup form, where visitors check the name of a partner (from FormA) that they want to volunteer for. Upon submitting FormB, the results should be sent to the email addresses of the partners chosen in FormB. Thank you for your help.
very slow
Zoho Creator is very slow - I am developing forms/views/etc and find performance a lot slower than usual. Any specific reason ?
Redirections Not Working in Internet Explorer (FF is OK)
Working on a user registration system via ZOHO accounts.... The sign-in is working, but the page redirection (OpenURL) fails for some reason. It's shared to support. You can try the application here: http://creator.zoho.com/niskypto/myusers/view-login/USERTYPE htmlpage USERTYPE() <%{ //This script checks if the user is signed-in with his ZOHO account. If not, the page reloads. if (zoho.loginuser != "Public") { //This script finds if the user is already in the database. If he
Is it possible to remove the Annual Revenue field?
We have no use the the Annual Revenue field, however it's displayed as a required field by default. How does one remove it? Professional Edition (Trial) Mike E.
On Success script no longer works properly
I have an 'on success' script which grabs data from the current form (add sales order) and populates the next form (add line) with that data. This used to work well but has now stopped working. The 'Add line' form opens correctly, but it is empty. There is no error reported. What might have changed?
Re-Format URL as Named Link
This seems like a newbie question, but I cannot get it to work. I have a url collection field in a form. It's set to just accept a url (no targets, titles, names). In the code, I want to reformat it as a clickable named link. Here's the code: urlstring = "<a href='" + input.URL + "' target='_blank' >Click here to learn more about this particular HHM.</a>"; The output in the table is a garbled mix of text, no links. Note I'm using the single apostrophe ' for the typical double quotes. What am I missing?
Update Field with Named Link
I've tried using update records script triggered by a forms on Success to update a field with a named link as follows: Sym = "<a href='http://creator.zoho.com/zoho.adminuser/zoho.appname/view-perma/TrialMap11/COJqONF68mVRfFy3UgPXXQ2jbX0OWJur3p4zUnkBWWPwq5ZWwMpHYeR0J4aEsP8MSV8DWEn5HJ6Tx4Pkb8PMTSV9te1zDBqQGBPC/TrialID=" + input.TrialID_Entries + "' target='_blank'>-</a>"; V = EvalResultGraph = [(Variety == input.Variety && Region == TrialTemp.Region) && Year == input.Harvest_Date.getYear()]; V.w1 =
Create a timer
I am having a hard time making a timer. Right now I have a field "Duration" where the user enters how many minutes they need a room. When they go into the room, I have a drop down list of the Staus as Starting. I then want to count down to how many minutes are left from the expected duration field. This script that I write works, except that it does not dynamicly update. e.g. Room is needed for 120 min, on Submit, the Time Left returns 119 - and then stays at 199. How do I make it continue
Picklist not filtering out duplicates
I have got a dynamic pick list for my form. When the user picks a particular component, the pick list should dynamically retrieve all the relevant sizes (which are number types) for that selection. Unfortunately it doesn't seem to work properly, displaying duplicates in the pick list. Why doesn't it work? clear size; size_list = List(); for each recs in inventory_administration [component == input.component] { if (!size_list.contains(recs.size)) { size_list.add(recs.size);
There has to be cleaner code
Word of warning....this is kind of a long post. In the past, I've tried being abstract in order to understand concepts, but I don't think my true intentions come through my posts, so here's what I'm working on. I've created a stateless form called frmTimeSheetDataEntry (see design below). What happens is this: when the user updates the intEventID, it follows this procedural flowchart (see below). I CAN get the form to do this procedure, but it is spaghetti code (see below). //1. User Updates intDuration
Next Page