Payment Information: Amount split to different codes
Is it possible to take one amount and divide its purpose among several categories? I have my donations divided into CATEGORY & CAMPAIGN. My example: Donor gives $260. $200 is for Annual Fund, $30 is for Merchandise, and $30 is for Supply Donation. Is it possible to split one entry into 3 allocations without having to create three records>
Formula field to pull value from another form with specifc criteria..
The Lookup field only allows me the following types: Dropdown, Radio, Checkboxes, & Multiselect. I need the ability for a Formula field to pull a single, specific value (text, number, etc) from another form based on specific criteria (i.e. ID == ID). How can I do this? Is it possible via Deluge scripting?
Zoho Web Developer
Hello I think Zoho Creator is a great enterprise application generator (EAG). I think it could also be the basis of a great web application framework (WAF). As an EAG, I think it pretty much hits the mark; I don't think it needs much more. As a WAF, I think: its pricing is inappropriate, it needs some payment processing features, and it would be a good idea to better leverage Google's App Engine. I suggest Zoho introduce a new product, perhaps called Zoho Web Developer. This should have all the features
Integrating existing application in to Zoho
Hey guys, hopefully someone can answer this question. Pretty new to Zoho, so just poking around. I have a PHP app that requires users to authenticate with a database. I want to be able to add this app to zoho for other users in my group to access. It seems like my app runs in an iFrame on zoho, so my question is, is there anyway for me to bypass authentication and use Zoho authentication of the user that is currently trying to access my app. In other words, user clicks on my app from within Zoho,
How to Alert the User on whether their Web Browser is a Supported Browser
Hello. I'm interested in writing a script within an HTML view or within the html coding of the View to notify the user of whether or not they are using a "supported browser" on my Zoho App.(I got over 100 Zoho users on my App) I get a lot of help desk calls and most of them are related to unsupported web browsers such as Safari & IE version 8. Any suggestions for this would be greatly appreciated. Thanks.
Criteria for embeded view: how to implement 'many-to-many'?
I have an html view in which I have implemented deluge script to fetch a list of cities from a certain "Form A" record (multi-select field). Below that (in the same html view) I want to embed a view that shows all "Form B" records where at least one of the selected cities are the same (Form B also has a multi-select field with cities in it). Is there something like: <div elName='zc-component' viewLinkName='TestView' params='Cities={London:Paris:New York}&Cities_op=99>Loading View...</div> where 99
Issue with date format when importing data
When I import data into an existing form, the import defaults to assuming any date is in a dd-MM-yyyy format, and sets the format to MM-dd-yyyy if it detects that the date is invalid in dd-MM-yyyy format but is valid in MM-dd-yyyy format. For example, if I import the following data:Transaction Date Transaction Amount 9/5/2008 52.39 9/12/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39 Zoho puts the data into my form as: 5/9/2008 52.39 12/9/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39
having created form sent
ok here is what I am trying to do: I created a sports registration form that I embed on my website. The goal is to have a parent of a child access the site, fill out the registration form, and then have a copy of the actual form get emailed to the person who filled out the form, as well as to the treasurer of the association (we are a non-profit church group). So far, I have been able to have the form filled out and the database updated without a problem. I believe that I have the access so that
Make it stop!
I have a simple "on user input" invoked function to make some text conform to a standard. input.RMC = thisapp.inventory.RMC_CHECK(input.RMC); It works, but the "on user input" keeps running forever (little spinning arrow next to input field). How can I specify this function to only run when a human changes the input field, and not when the function itself acts on the string in the field?
New String Function
Here's a simple request to compliment the built-in string function: xyz.removeAllAlphaNumeric() Please support: xyz.removeAllNonAlphaNumeric() Thus "OUCH! I banged my little @#$% toe!" would become "OUCHIbangedmylittletoe" Thanks!
how to create an editable multi select dynamic picklist?
for example dynamically create a books_i_like picklist from all the books. then allow a person to check and uncheck their selections without destroying their previous choices by rebuilding the picklist.
multiple pop-up windows / dialogs
Hi, I wondered if it's possible to have a pop-up dialog on top of another pop-up dialog? I've tried this myself, and it seems to have some odd behaviour. So I'm guessing it's not valid, but I just wanted to double check? Here's what I did: I created a view, with custom actions. The custom action is to pop-up a view (as shown in the attached picture). The pop-up view *also* has a custom action, which is supposed to pop up another view. But this second pop-up just seems appear momentarily, and
Strange behaviour on HTML embedded views that receive params
Hi all! I'm making an HTML view called 'Test' within 2 embeded HTML views. Both embedded HTML views are the same HTML view, but receiving diferent parameter values to print. See the code below: htmlpage Test() <%{ <div elName='zc-component' viewLinkName='HTML_view_A' params='message=FirstMessage'>Loading View...</div> <div elName='zc-component' viewLinkName='HTML_view_A' params='message=SecondMessage'>Loading View...</div> <%}%> And htmlpage HTML_view_A(message) <%{%> <%=message%> <%}%> Ok,
Disabling the standard edit and view links in a view
Hi, I badly want to know how I can hide the standard edit and view linktext in a view. These linktext always seem to be present in a list-view. I do not see some settings to disable those (and I need this because I want the users to edit the recors via a function via Edit a record via Record ID). Or is this dependent also on whether you are an admin of an application? Any help is appreciated. Kind regards, Silvester
How to show a field that is in another form?
On Add, I would like to add code that will allow me to Show and Enable a field from another form. When I select the Show option the pull-down menu does not display the fields from another form.
image loading is very slow
Is there a problem with the loading of attachements as the service is very slow, and is almost unusable due to the process. It actually appears as though it stops. Can you advise please? dp
When using IF I want to use the or function for a set of inputs but cannot make it work
When an input is made on a form and on field actions on user input I want to set a set of or conditions if (input.Key_post_code_area == "AB") however, I cannot make this save, and have had to add it condition by condition, which slows the process. Can you help? dp
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!!!
Next Page