How can I create a hierarchical multi-select or checkbox field?
How can we produce / display a hierachical multi-select field? E.g., "Cars" might look like: Acura - MDX - TL - TSX BMW - 330 - 335 - M3
Total a check box field
I have a form called Register It has a checkbox field called Events_Open and a Net_Amount field for the total. The data for the checkbox field comes from a form called Events with field names of Event_Name and Event_Price. Event_Name is a calculated field holding the value of a dropdown called Event_Product. In the On User Input of the Events_Open field is the following code: //Set the initial value of Net Amount input.Net_Amount = 0; //Fetch the amount for the selected items and calculate the Net
Problem with a disabled lookup field
Hi All, I have a Form (Master) with 3 fields: Type , Color and Thickness. This Master Form has a SubForm with 2 lookup fields (SubColor and SubThickness) referencing "Products" and another lookup field Sr_Num referencing "SerialNumberHolder". On selecting of 'Type' 1. Filtering the 'Color' Values 2. Filtering the 'Thickness' on user input of 'Color'
Need help scripting toString Function - Pretty stumped
Hi, I'm working on an automated scheduler function to fill out teams into game slots in an ice hockey league season. I want to have one game per team, per week, based on the criteria supplied in the team lookup field that "Team 1" is based on in the code below: void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(((Season == "Winter 2013" && Reverse_Record == false) && (Team_1 is null)) && (Team_2 is null))] sort by Team_1 { scheduleteam15
Wow, I really need a 12 hour time format!!
Doing an on-line schedule of events with Creator and it works great except that time can only be displayed/chosen in 24 hour format. Which most people don't understand. So I opted for a dropdown list where they could choose the time in "text" (1 am, 2 am, etc.) But that won't sort properly! When you try to sort by time, it lines up all the 1 am events followed by all the 1 pm events, then the 2am events and the 2pm events! Oh no!! Can we please have the time in 12 hour version too? dustylinden
PayPal Usage Question
Can the PayPal payment data be queried just like any other table? If I wanted to find all payments where payer_email=zoho.loginuserid, would this work? Thanks, Jeff
Cannot add fields to a form
I have been trying to add new fields to an exiting form. I can drag and drop the fields into the form where I want them, edit the field names, etc. but when I access the application, they are not there. I have tried this with a variety of field types and none get saved to the form. I am able to changing the titles of existing fields. I thought it might be a temporary problem, but it has persisted for nearly a week. I wrote to the support email address, but have not received a reply. The application
Audit Trail / Change Log
Admins need to be able to create a report on a table/form that lists all changes by date, user, and value. There are some ways of kludging this into an application, but this should be a native function supported by the Creator back-end.
How to Hide a Sub-Form
How do I hide an entire Sub Form based on a conditional statement?... Not just a couple of Fields on a Sub Form?
zoho creator data to google calendar?
zoho creator data to google calendar?
how to avoid overwriting
Hi there, I have a form „Leads” with one of the fields „Comment”. When I make a new comment I don't want Zoho to overwrite it, but to add this comment as a new record. How can I do it ?
Create Form with N-field (arbitrary numbers of instances of a field)
I want to give users the ability to list an arbitrary number of fields of a particular type on a form -- e.g., I have a URL field called "Specs" and I don't want to limit the number of "Specs" links that can be attached to a particular instance. How can I accomplish this?
i dont want any asociation with facebook or zoho
i began signing up for zoho till facebook came up as a part of it i stopped the application in midstream since i get unlimited spam from facebook unwanted and i never finished creating a zoho account [3407love] not my hotmail has gone to outlook on me more unasked for.unwanted invasion of my mail please remove zoho from any connection to me, my account, etc pls disable outlook i could not after following 2 sets of instructions please dont presume those were wrong and send new ones ---------------CUT
Can't hide field with Form -> On Edit -> On Load Deluge script
I am using the 'hide' statement to hide a field from anyone other than one particular user. I am referencing the zoho.loginuser variable to decide whether to hide or not. Here is my form called 'case' as viewed by the administrator in application execution mode where the field called 'approved' is not hidden (as expected): Here is the same form as viewed by another user. Note that the checkbox field 'approved' is no longer visible. Here is the code that I have in the two events in the script
Recursive Function Work
I have a need for a recursive function and don't know where to start. In the form shown below, I have a sub form for Unit Entry. I need to create a way so that every time someone enters a line item in the Unit Entry sub form the system will generate a list of those items with the same unit number, sales order number, and work order number but for each individual part, it will generate a new serial number. In other words, In the example shown, my user enters quantity 34 of the unit number 1234123.
Auto fill based on 2 sets of criteria
I have a database started and have made some headway in Auto-fill. My question is I want to create a form that will auto fill based on two sets of criteria. Currently I have a script written that will will auto fill based on one criteria. I want to be able to be able to auto fill based on the a Client ID and also the Product number (there might be the same product number for multiple clients, this is why I need the script to look at both criteria. this is the script I currently have: if (count(Extinguisher_Locator[Number
the warning for field type changing on new formula field addition
When I add a formula field the warning for changing a field type appears - see the screenshot below Regards, George Baltatescu Zoho Creator Developer
Hide Print opcion view
I need hide print opcion in one view embed in htlm view, zc_ print ?= false????????
Add contact email and phone number information on quote
Hi all, I would like to know how to add contact email and contact phone number information on the quote model inventory. Could please someone help me? Tks a lot. Felipe
Multi Select returns values in a different order than I selected them
Hi, anyone has an idea for my issue? I have a two multi select boxes, multi select 1 multi select 2 choice 1 choice 1 choice 2 choice 2 choice 3 choice 3 etc... etc... I select the following, in this particular order multi select 1 multi select 2 choice 3 choice 2 choice 1 choice 3 choice 2 choice 1 etc... etc... in my view when I go to analyse the info i entered, i should see multi select 1 choice
How do you format a formula
I am using a simple formula and i need to format it as currency. How do I do it ?
Sorting Pick List generated from Related Data
Hi: I have a Creator Application with several forms. Most of the form need a field that I am using as a relationship. To make things easier for the users I have a Pick List of imported data from the Personal Information Form. Here is the script code that generates the list: ust have Contractor_ID ( displayname = "Contractor" type = picklist values = Contractor_Information.Contractor_ID displayformat = [ " " + Last_Name + ", " + First_Name + " - " +
Ho do i Delete tabs on my App view?
I have 4 tabs that I made while learning how to do reports, Now how can i delete them? Help!!!!
copying the field from a different form
Hi all, I somehow have troubles with finding the answer to this simple question. I have two forms: -Companies -People Form Companies has 3 fields: -company name -telephone -address Form People has 4 fields: -first name -last name -company name (a lookup field) -telephone (I want the field to be automatically filled) How to set the field “telephone” so it automatically copies data from the field in form Companies ?
zc_ variable for private key
Anyone knows the zc_ name that we have to use to pass the secure key when we to insert view in html view without user login ? The insert view in html view is better than the regular IFRAME. <div elName='zc-component' viewLinkName='Rapport_des_rdv_View' params='zc_XXXXX=CM53WNP4jg8Bvt4pOKYAjeB78hSAeX99C86uBwAwUM3HkygeX1N9787f48EqkRTTBthhdKM9g5gwBxFBNPz8vVG2VPQXRK2pE&zc_Header=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_RecLimit=false&zc_SumRow=false&zc_Summary=false&zc_RecSelect=false'>Loading
HTML view + css: Chrome [blocked] The page at ... ran insecure content from
Hi everyone, I'm using a couple HTML views to display some contents on my website. The css formatting for the view is processed through a link to a css stylesheet on my server. Everything works fine on Firefox (see for ex. http://www.meridian-online.com/about-us/ -- scroll down), but I discovered Chrome blocks the loading of the CSS stylesheet... According to the developer tools, Chrome detects that this is 'insecure content.' Any way to circumvent this issue? Without the CSS, these views are rather
Show record data in form - but not allow edit
I have a function which brings up a stateless form and populates it with the current record information. The user then will edit some fields and click submit to update the record. I would like to make certain fields like redord ID, Name, etc, show up as plain text rather than in a editable textbox -- in order to show the user which record they are working on, but not be able to edit the information. Is this possible?
Search and Auto Complete
We are experiencing a problem with the Search and Auto Complete feature on some pick list fields. Our users love that the forms load faster in the case of very long lists and love that the search feature in addition to 'starts with' handles 'contains'. But, the pick list does not always populate with all the available selections. We understand that with the Search and Auto Complete option selected, by design the pick list only partially populates until the user requests additional items via search
creator custom domain for app
hi how can i share my app with custom domain name? for example appname.mydomain.com or custom-domain.zoho.com
Focus Traversal in forms seems to be vertical only
I've created a simple two column form like this: But I find that when I use / preview the form, the "focus traversal" is not horizontal but vertical. When using the form, after I fill the value for the left field of the first row, and I hit the tab key, the focus goes to the left field on the second row, instead of the right field of the first row. I think this is not intuitive, and I can't seem to find a way to make focus traversal be horizontal rather than vertica. ¿What can I do about this?
Has JSON Changed?
The url for viewing JSON data https://creatorexport.zoho.com/adminname/appname/json/viewname/ Used to display the feed data in the browser. Now it wants to download it as a file. I think this may have messed-up my application. Cheers, John Whitney
JSON feed does not display all fields in combined view
If we have a combined view and it happens that a field from the related form has the same script name with another field displayed in the view, the JSON feed does not display both fields, but only one. For example, let's say that we have a view based on Kids form The form contains the fields Name , FatherID (lookup field to Fathers form, which also contains Name field) , MotherID (lookup field to Mothers form, which also contains Name field). If in the view I display Name, Father Name (FatherID.Name),
Connect to an existing SQL database/server
Hello Guys, Apologies if the same question has already been asked, but i am having trouble understanding how to connect an existing SQL database to Zoho applications or if it's even possible to do that? Our current system is currently using an SQL database, so we would like to use the existing SQL database with Zoho creator applications. Any advice would be truly appreciated.
Invoking user input within a custom action
Hi, I'm a newbie and am struggling with how to approach this. I have two custom actions in a view - Pass and Fail. An example of pass is as follows: void test.PassTest(int id) { rec = Testing [ID == input.id]; rec.Outcome = "Pass"; } What I would like to do is when this button is pressed in the view the function prompts the user for one or more additional fields. I have created a stateless form but cannot see how to invoke it or pass the values from the form back. Is anyone able to provide
Edit data directly
In addition clicking on the 'Edit' icon to edit existing data, I would like an additional quicker way of editing data. Specifically, I would like the ability to double-click directly on any of the data fields of a 'View' which would open the field up for editing. Thanks.
forms and permissions - is it possible
Hi all, I have a question regarding forms and permissions. I have two forms:- People - Project The User inputs data in the form Project. Fields also include fields from the form “People”. When User inputs data in the Field “Name” in Project, he firstly is able to check whether certain person is already present in the database, if yes he can simply add this person to the project. If no he inputs new record, which is automatically copied to the Form “People” User does not have access to People View:
Internationalizing an application
Hi, I am building an app for a recruiting company that takes applications in four different languages (English, Spanish, Tagalog and Hungarian). Is there an easy way to 'internationalize' the app? By this I mean I want to be able to re-label all of the text fields in the appropriate language. My initial thought was to use stateless forms to populate the main form. However, this won't work because I am using sub-forms. The only other option I can think of is to just duplicate the form and change the
Free Flow Script - Chrome visibility
The problem occurs in the Chrome browser. When I view script via "Free Flow Script", I do not see and cannot edit anything. When I change to "Script Builder", I can see and edit the code. It was working fine yesterday but I cannot edit my views, forms or functions using the free flow script editors. Can someone please investigate? I have tested it with IE and Safari and it appears fine.
SQL statements in Zoho
I am now beginning to understand Zoho a little better. Obviously there is some sort of database in the background that is at work when we use a Zoho app we have created. 1) Is there any way to have access to the database for my app through SQL statements either to execute some sort of transactional statement or statements? Ex. "Update mytable join mytable2 on . . . set myfield=1, myfield2 = 2 . . . where . . ." "Create table . . . " Etc. In some of these cases we would need to know to to access
I need a piece of code to clear certain fields on user edit.
Alright, Basically, I have a form (current form). Once I add/update a certain field, the records of that row of that field is copied to archives. So I need it to clear certain fields (on the current form and not the archive form) once I update this certain piece of information. For example, (This is a bike application) Customer checks out bike 1, once the customer brings the bike back (actual check in date), that row of records will be moved to archives. i need it to where i can clear certain records
Next Page