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
I can not view the repports embed in Zoho Creator.
Hello, I have created a Report using the tool in Zoho Creator, but from some computers I can not view. I see the message The page web exploration has been canceled. The error detail are: Detalles de error de página web Agente de usuario: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; GTB6.4; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 3.0.30618; .NET CLR 3.5.30729) Fecha: Thu, 18 Feb 2010 17:44:53 UTC Mensaje: Carácter no válido Línea: 1 Carácter: 1
Is it possible to control column behavior depending on data in other columns in Zoho Creator
Hey guys! This is Jane McCarty with http://webappsatwork.blogspot.com. Currently I am trying to figure out the situation with dynamic in forms http://webappsatwork.blogspot.com/2010/02/lets-check-situation-with-some-dynamic.html I want also check if Zoho Creator is capable of doing this? Is there such a functionality in Zoho Creator and where can I find any info on this? Are there any tips in Help or on the web site? I would really appreciate any info on this! Thanks! Jane
Need to update records that contain multi select fields that were populated dynamically
I have a form containing a multi-select check box field that is dynamically populated from a look-up table according to a field selected above it. Eg. "Training Type" dynamically populates "Training Subjects" according to the Training Type selected. QUESTION: How do you configure the "On Edit" to populate the Edit form properly and allow you to submit the updates? I assume the multi-select field needs to be populated from the "On Update / On Load" function, but I can't figure it out. Either I get
Parameter passed from non-Zoho page into an embedded view not working
Here's my dilemma. I have an HTML view with serves as a dashboard to two other forms. Both of these links call different forms and pass to each the field Username to it in an attempt to prepopulate the Username field. The HTML view dashboard is embedded in a non-Zoho webpage. The non-Zoho webpage passes Username as a parameter to the HTML view. Thus, the intention is to pass the Username from the non-Zoho webpage to the dashboard, and then to the appropriately-called form. Somehow, the Username parameter
Count Records Matching Each List Value and Return Total for HTML View
I am trying to create an html view report to show the total records matching each value in a list from a dropdown field in a form. What is the most efficient way to do this? I have over fifteen choices in the dropdown field and would like to count how many records match each item in the list and show the total. I've seen different ways to do this on the forums. But I do not want to create fifteen to twenty variables. Is there a better way to iterate through a list and display each total? Thanks.
Images in HTML View
I have been using images from a third party repository on my Home Page (HTML view). Because that site is not secure, I get a warning message every time I navigate to the page. I think this problem would go away if I could upload the image to Zoho which I can do in an upload field on a form, but I have had no success refering to it on my Home Page. Thanks in advance.
Basic development questions on displaying and keeping records
I really like the simplicity of one particular sample app (Basic Lending Library ) and would like to learn how to tweak a few things to better understand how to use Creator. If I wanted to track a member's borrowing history on Book Copies, what would I need to add? Such as Dates for check in/out, and writing to the member records what copy was borrowed. Under Book Title's All Title View you can see how many copies exist, is there anyway to display rather than number of copies the Book ID numbers
Using the send mail function, can I send email from a second email address, not just the zoho.adminuserid?
I'm thinking of creating a form with a dropdown list asking if you have problem A, B or C. Can I customise the send mail comfirmations so that A queries receive a response from a@mywebsite.com, B queries from b@mywebsite.com etc?
How can i keep this goin?
Hey folks I have through this Zoho Creator application been working on setting a DB up which looks like this: Test DB Now I'm doing this on a Free Account type within the Zoho environment. Recently having looking at the pros/cons of this type of account i found out that there is a limit to what can be done by this account type, and thats the issue! I know that i can upgrade to other account types, but the thing is that I'm doing the above DB test- project without any financial profit and am not
Add Item Method
I'm trying to find some information on Add Item deluge statement, specifically the .getall() Method (method? property?) Are there other methods for this statement? Leo Saumure
Domain Portfolio Manager
Hi! I live in Brazil and manage a portfolio of 800+ domains. Its being hard to manager them, specially its expiring dates. I am looking for someone to develop an application to make our life easier. I started adding data to ZOHO but dream some integration between ZOHO and any GMAIL, for example, to update database on demand, while we receive emails from Register. Best regards Claudio Santos
Appointment Setting Form
I received a phone call from Customer support and I was asked to post this request here. I am trying to create a form with Zoho Creator that has some dynamic field population functionality. Please see this form that I have created in another site as an example of what I am looking for as far as form design . http://fs3.formsite.com/steveepm/form010783660/index.html Background: We are a property management company that rents apartments. I need a date field to only show availability for Today(if a
How to input data on success?
Okay, so I need to automatically add data to a field called "Supervisor" from a reference field "Location_Subscribed_to1.Supervisor". And then I need to add data to a field called "Group_Manager" from a form called "Location_Subscribed_to1.Group_Manager" and I cannot figure out how to do it on my life. So please help me! Thanks, Michael McNeill
Next Page