toDate from Numeric Variables
I am trying to convert numeric variables to a date: curMonth = 2 curDate= 15 curYear = 2013 Date1= (curMonth+curDate+curYear).toDate() I have also tried Date1= (curMonth+curDate+curYear).toString().toDate() In my script i just keep getting error that it couldn't convert variable to a date. Can someone please help. Thank you.
Multiple Select List select/remove all
Hi, I have a Multiple Select List with the option to Search and Auto-Complete. Can you please enable options that allow a user to select all or remove all from the list? There are instances where a user may wish to select all the values from the list but at the moment has to click them all individually.
How can display pic in a Note Field
Hi Latha My application scenario is as follows： 1，I have a File Upload field in formsc 2,The pic can show in view 3,I now want to the image displayed in a plain field and put the code as bellow plain=("<img width='100' src='http://creator.baihui.com/DownloadFile.do?filepath=/" + r.zpct + "&sharedBy=" + zoho.adminuser) + "'/>" but I try many times it's dons't work,I don't know where is wrong, please help Thanks Stanley Guo 2013-3-14
How to edit a record in htmlview?
Hey - I know how to edit a record using standard Form/View URL, e.g.: /#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> It works great while the <viewlinkname> is a standard view. It fails to work when I use htmlview as the <viewlinkname>. Any idea how can I do this properly using alike: <div elName='zc-component' formLinkName='newXYZForm' params='XYZType=<%=openFormAs%>&zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset'>Loading
Changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades.
It has been brought to my attention that there have been one or two changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades. 1) Incorrect indication of change to the Deluge commands. When editing an Application (in Free-Flow mode), any time a user types Ctrl+A (to select all Deluge commands) or Ctrl+C (to copy selected Deluge commands), the red star (asterisk) next to the 'Application+Event Description' in the title appears. This red star is supposed to appear
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field Getting the distinct emails from the list
For Each Records that was update in the last month..
Hey all im trying to run a for each into a HTML table, and although I can get the records based on a field values I also want to query the date modified, how can I ensure that i only get the records that were modified in the last month? Thanks in advance Adrian
Considering Creator for Application Development
Greetings all: I have used Creator off and on through the years for smaller, personal projects but am considering it for an online application to sell to end users. I like the scripting capability as well as the deep feature set, but I have a couple of questions what I hope a few of you can weigh in on. 1) How problematic has the updates from the Zoho team been in the sense of application stability? In other words, how often have your apps been broken by new updates that were rolled out without
Getting stonewalled on variable call
Hey, Is there any reason why my function would say my variable is "not declared" even when it's clearly in the script? If I try to save the following script it states just that for 'maxweek1': void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(Season == "Winter 2013" && (Team_1 is null))] sort by Team_1 { scheduleteam15 = MHL_Team_Contact_Info_Entry [((((Current_Last_Season_New == r.Season && Nights_Playing == r.Day) && Team_Name !=
First and Last day of the month
Hello, I have a form, where there are two date fields: 1st field) From Date 2nd field) To Date I would like On Loading the form the current values of these fields to be: From Date = The 1st day of the current month To Date = The last day of the current month How I could write this script??
Search Records script
So, I would like to create a simple Search tool on one form, upon user input of a name, records containing that name will be fetched. Problem is, I don't know script. I've tried the fetch on user input etc. but it's just not working out. If it is possible, I would also like those records to be updated automatically (multiple users inputting information- in real time update on all computers) Is any of that possible? and if so, how?
converting a complicated excel formula
Hi I have the following formula in excel which I can't seem to translate to deluge: =IF(AND(B3>2,C3>2),"MANAGE",IF(AND(B3>2,C3<3),"INFORM",IF(AND(B3<3,C3>2),"SATISFY",IF(AND(B3<3,C3<3),"MONITOR")))) I understand the AND needs to be translated to &&, but the multiple 'IF's and comments are the problem. e.g. where B3 is a user input ranked 1 to 5 (drop down list) and C3 is a user input ranked 1 to 5 (drop down list), should this be a comment script or a formula script? thx :)
Make View Filter Searchable
I have several views with an Auto filter. The pick list on the filter is quite large and it is making very cumbersome for the users to scroll down to find the item to filter by. Is there a way to make an auto filter searchable?? Thanks in advance.
Related Tables
In general my question is the following: I am developing a Housing application. I have rooms, occupants, and occupancies. These are the 3 core tables of the application. These tables are related in database terms - in that there are 'foreign keys' in each of the tables. Can this be accomplished using Zoho creator. Thanks Tom Hirsch thirsch
Dynamically summing a field of a subform
Hi, I have a subform of invoice items held in a main form of invoices. When the form is loaded, all of the items (ItemCosts) are added up and the figure is loaded in the SubTotal field of the main form using: input.SubTotal = Invoice_Items[InvoiceID == input.ID].sum(ItemCost); This code will not help with any changes made to the open form using 'InvoiceItems > ItemCost > On User Input' as the code is working on the main database and not the open form. How do I access (and sum) all the items in
Want to create a second form to enter data for the same table (duplicate form)
This sounds like I want to create a duplicate form . . . but . . . I have read that thread about copying the script and pasting into a new form and that is not what I want. I want to be able to edit the same table information with two different forms. One will enter all the data fields and one with be a 'quick entry' to enter just a few of the fields which will later be edited on a view in order to enter all the data. Thus the two forms will be working on the same table, not two identical forms
User Add Choice to Pick List Field
Can you provide preferred methods of enabling a user to add a "Choice" to a pick list (a.k.a. Multi Select or Checkboxes Field Type)?
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!!!!
Next Page