Convert dropdown values into decimal number
Hi I have a dropdown menu with this values: 1 1,5 2 2,5 But I cant work with this values as number I tried with toLong() but it does not work with decimal numbers. Thanks in advance
Problems with Custom Themes
When I change the theme choosing to create my own (Custom theme), the chosen properties are not applied and I get a sort of text+hyperlink version of the UI (see attachment). Sometimes saving the application, after changes to the custom theme, takes a very long time (3-4 minutes and the changes are applied but then if I logout and in again I get back the bizarre UI. I use Firefox.
Auto-compile date-time field when other field's been modified
I have a field where to manually input a number. I need a date/time field to be automatically filled up with current date/time when the above field has been modified. Thank you, Gianluca
Conditional field labels?
I have two fields on my form: Country and State/Province. If user selects "Canada" I want the field label for State to say "Province". I the form definition I added the following code but when I go to save the script, it never stops saving. Am I doing something wrong? Thanks, Jeff
Enhancement Request: Conditional field labels.
I propose an enhancement which would allow developers to conditionally set field labels on forms. Example: if (input.Country=="United States") { displayname = "What state do you live in?" } else { //Canada displayname = "What province do you live in?" }Thanks, Jeff
Create CRM Event from Creator
I am trying to create a CRM Event from Zoho using the following function: response = zoho.crm.create("Events", { "Owner" : "carlgifford", "Subject" : "Test", "StartDateTime" : "08/01/2012 10:00:00", "EndDateTime" : "08/01/2012 10:30:00", "WhoID" : input.CRM_ID }, 2); It does not seem to be working, I am thinking that the date formats are incorrect. How do the dates need
About toDate(), why the "15:00:00"?
I've put a Formula field which converts a time (which holds date and time like "May 5, 2011 18:08:01") to a date ("May5,2011"). I used "Deadline.toDate()" to achieve so, but it always gives a time like "May 5, 2011 15:00:00". Why the "15:00:00"? Shouldn't it be just "May 5, 2011"? Please help. Thanks very much!
can HTML be added to related list for contacts using custom functions??
Hello, I need to display some data associated to each contact on the contacts page. So,is it possible to use an iframe in a related list or load html into the related list directly?? I didn't find detailed information regarding custom functions for adding new related lists. Please suggest some examples regarding the same or some workaround if its not possible... Thanks
Looking for a ZOHO Creator developer in Amsterdam area
We are looking for a ZOHO creator developer in the (greater) Amsterdam area NL who could develop a relatively simple Assignment Tracker System for Master Students fo a University department. Please respond to this message if possible.
Xml rpc update on a field in a form with subforms failed
Hi i am trying to update field in a form with couple of subforms. When i try to update the field after payment i get weird errors that are not related with the form i am trying to update, but instead it is related with subform in this form. I tried removing this subform but then it gives me same error with the next subform in the form. My question is, does zoho suports update on a form with subforms ?? Or this is some other issue. I checked the code multiple times and there are no errors in it. This
How can Admin see every record with zoho.loginuser active
I have a form that my salesmen use to ask for maintenance for our customers. I used a zoho.loginuser so that each salesmen can see ONLY his entries. Once they submit a form, I have to edit the entries in view mode, in order to let them see when I've processed their request. PROBLEM: I can't see their entries because I'm logged in too, but with my userId! So I could see only my entries (which I don't need...) Any suggestions?
System restore has not restored data
Hello, I have done a backup of my application 'KiwiOz Childcare.' I have then completed a Restore and renamed the application kiwioz_restore. However, in the restored application kiwioz_restore, none of the data has restored. I have also backed up and restored my other application (Cafe Nanny). This restore worked and the data was restored. Please advise, thank you (I have allowed edit access to support for both of these applications).
webhook keeps firing
My webhook keeps firing every 10 minutes, instead of just once. It is configured with a workflow action on create/edit that checks the existence of a (custom) field, and fires if it is true. The webhook service returns an empty response with status 200 OK. It completes in 10 seconds or less -- btw, what is the timeout on webhooks? It has fired 15 times now in the 2.5 hours since I "tested" it by saving a record, firing every 10 minutes with the same data. There is nothing listed in the errors tab.
How to sum up pre-added field?
Please see photo, i need to total every amount that is added on the subform. Hope you guys can help me asap. Thanks.
Issue with deluge script executing in a sub-form
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in when editing the
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 I don't think Zoho has an explode type function
Can't use dropdown form fields as display fields
Hi, I have a SERVICE subform that has a SITE look up field. I want the SITE lookup to display the site name and site address. However, when I go to Edit Field ->Advanced Options -> Display As, I do not see all the SITE fields. The ones that are missing are the dropdown fields so I cannot select site address. Note, site address is a dropdown in the SITE form. Is there a way that I can use the site address field as a display field in the SERVICE form without making the site address a textfield in the
Sending notification from one app using email ID of another
I need to send notification when data is entered in one application to the email ID of registered users of a different application.
Refresh Fields Within A Form Without Reloading or Submitting the Form
Is there a way to refresh fields within a form without reloading the form? Problem #1: I have a Jobs form. And I have a Contacts form that is linked to a contacts database. Within the Jobs form, there are two places to look-up contacts and add them into the Jobs form. But one of the places also allows adding a new contact. When I add a new contact at this place it does not appear in the look-up list for the other place. I need a field.refresh() option to refresh the look-up so I can see the
allow shared users to have edit or add permission to records
Hello, How do you give edit/add permission to shared users on your application. I would like to be able to allow users to add or edit records on certain form or view. I did not see any functions that allows me to do so. Please advise. Thank you
zCreator Emails are treated as junk by Microsoft Smartscreen Filter
Dear zCreator Team, I would like to bring to your kind attention that zCreator emails are being treated as junk by Microsoft smart screen filters. ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
Convert string to numeric?
Is it possible to convert a string or portion of a string to a numeric variable that can be acted upon in a function? E.g. I want to take a string like "5 - High", extract just the "5" substring and create a function to multiple that by a separate numeric value. Currently failing because the substring is still a string. Thoughts?
Layout of Charts and tables
Is there any way to have headings in a table or chart wrap so I can make the columns smaller but still read the headings.
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)?
Next Page