Explanation of script builder functions
I've spent dozens of hours browsing every help section I can find, but always end up posting in this forum because I can't ever find what I am looking for on my own. Occationally I'll find someone mention the tips and tricks section, but when I find the section, it is empty. (Why is there no index to this section? I have found links here and there from other sections for forums, but can't get to them directly) What I am looking for is a description of all the functions that the Deluge script
code spippet
If I do embed in my web side and put the code snippet without login it still ask for a password. Its a blog
Prompt to save
Hi, Can anyone guide me as to how I can ensure edited records in a form are submitted? Ie: If the form is closed the edit is not saved- I want a pop up to confirm the close without saving or to save the changes or force saving. Thanks for any help Colin
How to group fields in a form?
I would like to know if is it posible to arrange the fields of a form (ie, in tabs like MSaccess does) in order to avoid long fields list and an intensive scroll use. I have a DB with 80 variables for each case and I´m triying to do it more user friendly. Thanks
Column does not render in a List View ...
I just added a (Multi Line Text) field in a record in one of my Client's Applications. When I try to have this field rendered in one of the List Views, the column for this field is not displayed ... yet when I ... a) click on the View link to the left of a record, this field is displayed b) request the same field to be displayed in another List View for the same Form, it renders as expected @ZOHO Creator Support - please schedule a ZOHO Meeting session so I can demonstrate this defective behaviour
Copy sampleapps not allowed
Hi, may I copy this sampleapps? http://creator.zoho.com/sampleapps/private-search/# Thanks. Mic
Problems with zoho
The system is not working properly, all weekend no one could sign up, it has just started going agin now Coming up with Error when people sign up - saying it full Also the email confirmation is not being sent
Help! How do I get started?
I need to create an online form for a model search to be put on FB and our website. I have the information (as far as boxes and required info) set up but don't know where to go from here. No one ever answers at the 800 number and I'm stuck!! Any help would be greatly appreciated.
password reset in a none Zoho environment
Last year I asked Zoho about the ability to direct my users to a password reset facility that was not branded as Zoho. We have removed (and paid for) rebranding, and have hosted the app in our web site, however, if a user cannot remember their password, they are directed to Zoho. As I will be paying for all of my licence holders, I do not want the to be exposed to Zoho as it is confusing for many of my clients. All we need is a simple blank screen, where a user can just be asked for an email
Internet Explorer - Operation Explorer
All of a sudden when I try to access my application using Internet Explorer I keep getting the error message : Internet Explorer cannot open the Internet site http:<application website> Operation Aborted This does not happen in Firefox or Opera
data not showing
Hi Help We have the application but the data that has been entered is not there?
Calculate how many???
I have a form that collects: Name (text field) Position (Drop Down) [Values: EMT, Paramedic] I want to be able to create a report that groups by Position, and TOTALS how many EMTs and Paramedics. How would i go about this? -Tom
import and export data file
I built a contacts directory app in creator, but I have the data to populate it in .xls file, now two questions 1.- How can I import data from xls to creator? 2.- how can I export data from creator to xls file?
Assign A Lead To A Particular Manager
In my application the end user selects from a drop down list which location they want to work at. I want to be able to "assign" those to particular people. I have created a drop down list with all the manager names also (hidden from end user). Examples: Applicant1 applies for job in Stockton, CA - this applicant is "assigned" to "Steve" for follow up. Applicant2 applies for a job in Battle Creek, MI - this applicant is assigned to "Mary" for follow up. I need to be able to track if the managers
Need to limit field criteria on a form by another field on the same form
In the criteria section of the dependant field, how to I refer to another field in the same form? If you need more info... Form name "Purchase_Order" Field 1 "Vendor_Name" Field 2 "Vendor_Account_Number" Field 2 is a look-up field from table Vendor_Account_Number which in turn has a field "Vendor_Name" I want to set the criteria for Fields 2 to only include records that the Vendor_Name == Vendor_Name on the current form Thanks
.replaceFirst() Function is Broken !!!
@ZOHO Creator Team: Looks like the .replaceFirst built in function is broken ... when I try to Save (previously working) script sections that deploy this function ... even without making any changes ... I now get an error message ... here is an example script command ... input.Result_of_Action = (input.Original).replaceFirst(rFrom,rTo,true);... and here is the error message when I try to Save the code ... Encountered "," at line 3, column 65. Was expecting one of: ")" ... "*" ... "/" ... "%" ...
Long Relational Forms
I have created a relational database, and now am putting up forms on my website to collect the information (application). The problem is that I collect company information in one form, then I send them to another form where I hope to allow them to make as many contact entries for their company as necessary. I suppose the best way is to add a button at the bottom. So after the usual submit (which may be changed to submit final contact) and reset, there should a button that says add another contact.
Fetch from same form, Update two records from same form
I am having a problem updating two separate records as a result of a change in my incident report form. When you select the equipment that has faulted, and has been replaced, the faulted equipments status changes to "Faulty", and what I want, is when you select the replacement equipment, that it's status changes from "Backup" to "Active". Unfortunately if I put the bold code in below, I get a 'null' response on update. if((input.Condition == "Faulty & replaced with spare")) { EquipmentStatus
New data not appearing in Reports or Charts!
I'm testing the Reports and Charts feature and find it potentially very useful except... To simplify testing, I've created a "Record Finder" view to gather the needed fields from my Client intake form. I then created several reports and charts built on this view. On the date I create the report or chart, everything looks great but..... As new data is added in the following days the new data appears in the "Record Finder" view but not in any of the charts or reports. Here's a link to the Record
Export to Excel: numbers and dates are coming in as text
When I export a table's contents and choose the Excel spreadsheet option, upon opening the document Excel gives me that little green diamond and alert box that says that "numeric data is stored as text" (same for dates). I have to select that column and tell Excel to convert it to a number before I can do anything useful. This is not a show-stopper, though it is annoying and I would love to see it fixed. Cheers, Kevin
Importing data does nothing
I've tried to copy and paste, and import a csv file into a table, but when I hit "import" nothing is imported and no error messages are displayed. Literally nothing happens. I've tried in both internet explorer and firefox. Thanks
Import in Creator is not working.
The import function in creator is not working. Nothing happens.
Current Date failing sometimes
Hi, Only today I have a field with current.date script that failed in this records: 92720000000443743 92720000000443477 The system return null value. About other 20 data the script run regular. There are other field with formula that, obvious, return in the same value null when current.data not run. Help me to know what happen. Application: Consulado-geral-do-brasil Form: Matricula Consular Field: Expedida em e Validade até Thanks Mic
How do I restrict Edit Parameters on certain form fields?
Hi, I have created a view, but on certain fields I want view access only and no edit access/permissions. How do I do this? Thanks Bram
How do I change View Types when embedded in HTML???
Hi I need to be able to have the option for my users to change VIEW types in my HTML embedded code. From List or Grid View. How do I do this? If it is not possible, My 'UPLOAD files' fields are not showing up in my Grid view, any work arounds for this? I need my users to be able to change views from the website and upload files based on either LIST or GRID view Thanks Bram
Duplicated Auto-increment number from zoho system
Hi, this records below have experienced a duplicated autoincrement number. Probably two member staff have added data at the same time (but with different profile). 92720000000462187 92720000000462179 How may prevent this? The auto-increment number it's a company identity code and duplicates may cause serious legals problems. Regards Thanks Mic
Why is a parameter added to an HTML view always a string?
I am new to zoho, please bear with me! I added a parameter to an HTML view named PurchaseOrderID I only want the view to display one record, so I am planning to pass the parameter of the record that will be used as criteria. When I go to fetch the record, and enter the criteria as x = Purchase_Order [ ID == PurchaseOrderID]; it tells me "The Left expression is of type BIGINT and the right expression is of type STRING And the operator == is not valid here" Is this because the parameter
Sort by ascending integers
Subject: sorting numerically I'm constructing a database in which I want to sort a column by integers (1, 2, 3, etc.). Using 01, 02, 03, etc., lets me sort correctly, either ascending or descending order. Everything was fine until the numbers reached 100 and beyond. What do I need to do in order to sort in numerical order above 100?
Can I prevent the use of an iframe from specific web sites?
Hello, Currently anyone who copies my iFrame code from the HTML source page of my site can embed that into his or her own site and show my view. Is there a way to prevent that? So that only when I access the iFrame from a predefined domain / site the iFrame will be displayed?
share in zoho creator returns an error
i am a paying subscriber. when i invite a user to access database in zohocreator they click on link and it says zoho component does not exist. when you click ok to close that message you can then access the database. why is this happening please respond asap
Reference Function params through tooltip
Suggestion for easier function coding... I absolutely love the simplicity of your functions. While not as flexible as js functions they sure get the job done. Often times I need to quickly reference the params for a function. I think it would be so great if you added a "tooltip" on hover for the function links in the function menu bar. This way you could really quickly reference the order and typeOf params being passed in an existing function. Wow, this would be great. It doesn't even need to be
Help with IF deluge
In my application I have a radio button with 3 options "New", "Yes", "No". I have a multi line field called "If no, Why" I want the person editing to be forced to enter notes in the multi line box if they select "No" on the radio button. HERE IS MY SCRIPT if ((input.Hired == "No") && (input.If_No_Why == null)) { alert "Please explain why this person was not hired"; cancel submit; } If I take out the && (input.If_No_Why == null)) I get the alert and cancel submit, when I add the &&...
Nonprofit Access?
I represent a nonprofit gaming recreations program called GameHearts (GameHearts.org for more info). We have been searching for an database import program that can list redemption cards for our participants and today I began working with your site. Unfortunately, I encountered a couple of limitations - First, the "free" package is limited to 1000 entries and, Second, apparently we cannot share our data entry with our participants without their logging into our account. Are these issues something
Assign based on location selected
In my application the end user selects from a drop down list which location they want to work at. I want to be able to "assign" those to particular people. Examples: Applicant1 applies for job in Stockton, CA - some designation is given that "Steve" is responsible for follow up. Applicant2 applies for a job in Battle Creek, MI - this person is assigned to "Mary" for follow up. Sorting is not sufficient as the person following up is responsible for several locations and sometimes in different states
TOO FAST!
How do I slow down the "Your Data Has Been Successfully Added" after a users finishes enter and updating the CReator form? It doesn't stay on the screen long enough. Thank you. George YourBizzWizz
Alert and Cancel Submit Script When Input ==null
Hi, I have created an app that is used for people to apply for a job. Everything is fine on the form side. I have fields that are hidden on the form that are shown in the view. This is so that I can add notes for each persona from the View. I am trying to make it a required field or setup a script so that when I go in to "edit" I have to enter something in this notes field. Nothing in the script builder selections is working. Can this be done? How?
Nested lookups ???
I know someone has asked this but I didn't see a response so .... Can you do nested lookups in forms - I want to do something as follows I want to create a form that has two dropdown lists ( say Industry Sector and Industry Sub Sector ) The values of Industry Sub Sector should be displayed dynamically based on my Industry Sector selection. For example suppose my Industry List is { "Energy", "Healthcare" } and my Industry Sub Sector List is {"Oil", "Pharmaceuticals", "Health Care Equipment & Services"
Creator "Reports" Beta bugs
I'm using Firefox 3.5.5 on my MacBook. I'm using the "Drop Down Menu" Layout in my App. When I put more than one Chart or Report on a tab, they display properly in a drop down list but can not be selected. Moving the mouse pointer over the report or chart item turns the arrow into an "I beam" as though it was trying to edit text. Other forms or views on this same menu behave properly. If I change to any other type of layout, the issue is resolved. Rick Clay
How do I select only the latest entry?
I have a multiple dated notes for each of several subjects. How do I view only the latest note for each subject?
Scheduler in Zoho Creator - Preview
Dear Users, We are excited to announce the beta testing program for one of our forthcoming releases - Scheduler. If you're interested in becoming a beta tester, please sign up and we'll contact you with further details. This beta program is for limited people. So hurry up and be one of the first to try it out. Register now Starting from tomorrow, we will start enabling the preview for the registered users over a period of time, depending on the number of requests. How can Scheduler be useful for
Next Page