multiple criteria in .contains ?
What is the syntax for .contains for multiple criteria? field.contains ("blah") something like field.contains ("blah" OR "foo")
tooltip for formula field
Now that formula fields can be displayed on a form we need a Tooltip for the formula. This will help communicate to the user information about the formula. Herb Wexler
Auto Complete
Ref the new auto complete feature does it only search by entries that start with the letters you enter, or can it search all entries for matching letter sequences. e.g. If I enter "chilled" can it only find entries such as "chilled food" or "chilled dessert" or can it be set up to also find entries which include the word "chilled" such as "keep chilled" or "store chilled". Thanks.
Where to I go to add custom text to the top of my database?
I use Zoho to host a coupon database on my website: http://www.simplesavingsavvy.net/coupons/oklahoma-inserts/ I need to edit the text a the top of the database (please see link). I can't remember where I first added this. Have looked everywhere. Help!
Subforms on load
I have an application which contains a subform that loads 5 records on load of the parent form. in this subform i have a fields called "day". What i would like to do is have the names of the days of the week be embedded into those fields on load of the parent form, starting with Monday, and ending with Sunday. Here is the Application This is what I want it to look like (image) This thing has been driving me crazy. Any help would be GREATLY appreciated. thank you in advanced.
How to add line separators
Hi.. I am trying to run a small survey using Zoho Creator. There are about few questions, which can be logically grouped into a few sections. In the survey, i want to add a line in between each section, to improve readability and make the form look cleaner. However, I just cant figure my way through. I am really new to zoho, just been using it for 2 days. so please bear with me as i learn. Regards Sreeny
How do i get a submenu field to = the option chosen in main form dropdown field?
how do i get a submenu field to automatically correspond with the the option selected by a user from a drop down field in the main form?
Change ownership with Google Accounts sign in
Hello! I would like to change the ownership of my Zoho Creator project, but I want to pass on the ownership to someone who will log in with a Google Accounts ID and not a Zoho ID. I know I can change ownership by adding an admin and then make it as primary, but since the "Add a new email" page asks for an email and password, I don't seem to be able to indicate that the passing on will be through a Google login. Is there a way to override this?
Search Interface
Hello all, I would kindly like to get help in making a search interface. I have already created the stateless form with the search button and also the html view. However, am having difficulties in writing the script. Ideally the search form has 6 fields which can be used to search,I would like that an input into any of the fields gives a result. Any ideas and help will be highly appreciated.
custom action to download attached file from multiple records
I've a form with a "file upload" field. I want to build a custom action to download this file from multiple selected records. Any ideas?
Noob Question
I have manged to get my head around populting the fileds within creator and then linking them back to corosponding fields in zoho crm but what i want to do is create line of instructional text to show on the form. Can anyone give me an idea of who i do this with maybe an example, explination or code snippet. Thanks Chris
Disable SSL
We work from a slow connection and find that SSL is quite slow when logging queries. Is it possible to disable SSL when adding data to a database ?
Passing parameters via URL in embed form (or permalink) not working on iPad
Hi guys, I can't pass parameters via URL on iPad... This is working everywhere else. Is there a way to make it work ? http://creator.zoho.com/nsisolution/<appname>/form-perma/iPad_Test/from=iPad Thanks Pascal
Import date errors in Zoho Creator
Hi When I import any data into zoho creator document view I have created, if the date on the data is older then the todays date it give an error Row 15 Col 15 - Value '24-Jan-12' is not a supported date format Row 15 Col 16 - Value '24/1/2013' is not a supported date format Row 18 Col 15 - Value '01-Feb-12' is not a supported date format Row 26 Col 15 - Value '01-Feb-12' is not a supported date format Is there something I am missing? I have a lot of data and I don't to want add each date manually....
How to Sum across all records in an application
I have an application where there are 2 fields that capture numbers in dollars. I want to be able to total all numbers for all of the reports. How would i go about doing this? Here is the application I want to be able to get a total for all records for the fields "PAID" & "BACK" thank you in advanced.
Trying to fire an email that contains a group of reports for a single country
I'm trying to fire an email that contains a group of reports for a country. For instance reports due for this month or reports past due, etc. I've got it sending 1 report per email - not what I want and I've got it sending all reports to every country (not just their own, but every single one) - not what I want What I want is to send only the reports for a particular country in a single email. As in sending the 4 over due reports for Ghana in one email. Thoughts? ******************** This sends every
Set the Minimum Characters in a Text Box
Is there a way to set the minimum number of characters required when a user fills a text box? I need to set a team number to be exactly 10 characters. I see how to set the max, but wasn't sure how to set the min. Thanks
GApps Users
I tried pulling in the GApps Users option from the form builder, but when running the application from a Google Site - all I get is "Select" in the dropdown field and no user names. I don't particularly want a dropdown list - I'd rather actually capture the GApps User's name behind the scenes and tag the username for the user adding data to a form. Any more examples of how to implement? I've tried logging out and logging back in to my GApps acct to see if that would trigger it, but that didn't work.
"Send mail" script doesn't work.
Hi everyone. At a moment's notice, "Send e-mail" script just stop to work. I have tried Safari, Firefox and Chrome (i'm a mac user) but nothing happens when i click at "Done" button and i am not allowed to see my other forms in edit mode. When i select "Rich text mode" the field appears blank, and i need it working fine to copy and paste.
Checkbox
Is it possible to add script to a form that would result in unique data entries for checkbox selections -- for instance, I have a form with "Date" -- "Lecture ID -- "Students" with Students being a checkbox listing each student. The default creates a data row for each submission with all student names in the same cell. I would like to code it so that for each student checked a unique data row is created in the view. Is that possbile?
Chrome compatibility
Seems the google's browser not compatibile with ZCreator. If you try, x exemple, to edit a Form, after More Action and after Set Email Notification the screen remains gray... nothin happens. The same trying to put that post in forum from chrome... Please check it and let me know...
How do I integrate a Creator Form into CRM?
I created a Form to update the contact information in crm. Is there a way to post this data into crm when the submit button is pressed?
Moving Forms
Hi, quick question. I created a form in a new application and now want to to be associated with another application. Is there any way to transfer or copy the form to another application in creator without recreated it? Thanks heaps Jason
Parameters in url to filter a view on related data (lookup field) ?
Hi, is there a parameter to use in URL to filter a view with data witch comes from a related field ? I know I could add a field in my Parent form and copy the data (of child form) but I have a lot of related fields, and if we change data in child form, data won't be updated.(-without writing a script) Do you plan to allow it please ? thanks Cyril
Need Help
Hi When the lookup field drop-down, it was the rich text field covered, it's need to fix? Thanks Stanley Guo 2012-2-18
Looking for a Zoho developer consultant to help freelance
We are a boutique advertising agency and set up a zoho database for a major client with a web developer who has retired. HELP we need someone who is very zoho savvy to freelance for us - make updates, train our client, offer advice, support ongoing for hourly fee.... We are in Australia (Brisbane) ideally someone local but fine if overseas
Combining Fields
Hi I'm a newbie who isn't that techy oriented who has managed to get tied in knots. I am trying to create a leaderboard for our equestrian club. Here's how our system works. We have 1. one rider who may have 2. several horses that he or she 3. rides in several different classes - (see bottom of page for an example of points accumulated during one event.) From this we then 1. Assign points to each horse/rider combination for the classes they rode in and 2. Keep a running total for the year
Disable Rich Text-not working
When a Rich Text Field is Disabled it still allows users to type in the field. As a test I switched it to a multi-line text and it is disabled as expected. Thanks for looking into this Herb Wexler
disable lookup field with "Show a link to add new entries"
I've a lookup field with the option "show a link to add new entries". I disabled this field on edit on load. The lookup field itself is disabled, but the link to add a new entries is still enabled. In my opinion this doesn't make sense, specially becouse the user can get confused.
[Form Customization]: How go control the location of placement of a control in Zoho Creator
I think I had come across this information at some place a while back but can't seem to find it now that I really need it. I need to layout the controls on the form so that they are placed over three vertical columns (v/s two columns that is the default). Actually in my case, most users have a wide screen and prefer to have the controls laid over three columns such that they all fit in a single screen view without any scrolling. I do not want to break the controls over two forms either as they want
Custom Action - E-Mail Notification Question?
Hello Zoho Community, I Would Like To Have A Custom Action - E-Mail Notification Button ("show action in view header") that sends notification to all that meet the following condition. void MonthMembershipExpirationNotification() { for each record in Form [(E_Mail != "" && Method_of_Payment = "Cash" && zoho.currentdate.getMonth() = input.Month_Membership_Expiration_Notification.getMonth()] { sendmail ( To : record.E_Mail From : ""
How to find Zoho expert in Nashville, TN
I'm looking for help in configuring zoho for specialized real estate company
Fantastic!!
I just creating a trouble ticket app in 30 minutes! The last time I created one in PHP with a mysql database - it took me 2 weeks! Thank you so much for this. How much space for data comes with this service? shoffman
how to use 'NULL' in a schedule
i would like to be able to email attachments that are included on a record when its updated. the schedule i have setup works fine and emails the attachments. but i want NO email to be sent if no attachment exists in the 'IP_File_Upload' field. currently i have if(input.IP_File_Upload != NULL) { if((input.Currently_With == input.IP_Approver)) { if((input.IP_Status != "IP Approved")) { if((input.IP_Status != "IP Topic and IP File Fully Approved"))
problem with dynamic lookup picklist
How I want to create a dynamic lookup picklist based other field entry? for example, If State A is chosen, list of City under State A will be listed if and only if entry for Enable field for that City is "Yes".. if Enable field is blank or "No", the City will not listed.. i have tried a lot methods but still doesn't work.. thanks..
Please need help
I Have a problem with my attachment, when i edit my record on ipad. When i click the edit in my apps view, the attachment didn't show up. and when i update the record, the attachment get deleted. How can i solve this out ??
Submit Print Button
Hi I use this link https://help.zoho.com/portal/en/community/#topic/2266000000362158 for print a view but I have a problem: howe can i change the default header and footer to invisible when i print a view??? this my mail: walid.jaha@yahoo.fr thanks
Pop up window
Hi, Is the a window that can pop up and allow you to answer yes or no then take the answer bach to the form Thanks Nigel
Pass data from parent form to subform
Hi, I would like to build a control report using the pareant form for general data, like customer, item, etc. and the childform for the control values. The childform is subform to the parent form. For later statistics I would like to pass the ID of the parent form to each childform record that I enter. Could you help?
HTML View > Insert Html not working properly
Dears, on Chrome it is not possible to insert HTML in HTML View now.(Only problem in Script Builder Mode.) It was previously worked but now after opening insert html page and klicking done button nothing happening. Also in opened insert Html page it is not possible to switch between Rich Text mode and Plain Text Mode. Windows7/64 bit I tried ie,mozzilla and chrome. SI I already tried to re-install java. SI I already tried with another computer Any solution offers ?
Next Page