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 ?
example of HTML list view showing data from two forms
Hi trying to final a template example HTML view that will list all records from two different forms that are not child forms. records from each form have a 'name', 'points' and 'status that i will to display in a single list.
Latha Please Help! "Servlet Exception Error"
Hi, I am attempting to make changes to a view and receiving this message when I go to edit the view: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
"User Defined Variables" in Script-builder for Scheduler
Normally when we create temporary variables, they show in the User Defined Variables menu when using the script-builder wizard. This is not the case for the wizard in the Scheduler! John M. Whitney
Share by information in a View
I would like to share portions of an application by information in a View. For example an application may have a list of members that are either Active or Inactive. I would like to restrict access to some sections to Active members. In the share section it would nice to select a View and indicate the column which contains email address. When a member changes from Active to Inactive there would be no need to go back to the share section and change the list of email addresses. This feature can evolve
Second Criteria needed on report
Second criteria needed on report. I have one field which is (field_name1 is not null) which will put it on the report but I need a second criteria (field_name2 is null) to have it fall off the report. Hhow do I show both?
Help with Error Null Message
I am trying to edit a view and I keep getting this message: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
Form view criteria help please
Why wont the following form view criteria restricted records work? Date_Collected is formatted to zoho time field. ((Date_Collected < 'zoho.currenttime')) So in my head this should stop all jobs that have been collected from displaying in the jobs view. Thanks Nigel
Commissions Calculation
hello all, In my application, am trying to calculate the commissions to be paid out to sales people. I already have the criteria for the commission, e.g if a clients purchases product A, the sales persons gets "x". am having difficulties in writing this code; it would run like this: if the Product is A, then commission is "x". Any ideas on this? kind regards,
Embeded Verification
Verification code in my app works fine on the Zoho Creator domain, but after embedding it into my website it doesn't work.I tried it several times with no success. I am publicly sharing the application it's named "TOA Rating Application". Can anyone help me with embeding the app? Kind Regards J.Page
Private database, user authentication
I have several private Zoho db's we use for our company and it's brilliant. The only issue I have is the limited number of user accounts and limited authentication. We have around 60 staff who all use the db and they all share one generic login to Zoho for creating content. Obviously this is a fundamental security issue but I couldn't find any other way around this, can anyone give me best practice for creating a database for a team of 60 staff with user authentication? As a side thought, perhaps
How to archive patient data record?
Hello, I have created a medical database that handles patients. Every patient has a ID created like balasankar Unique ID example. I would like to create a button that would close the patient records, removing him from the "Patient View", and archive his data on a "Archive View". But if the patient comes back I would like the ability to reactivate him back to the "Patient View". Thank you.
Ho do I make a database private and use authentication?
I love Zoho Creator, one issue I'm struggling with is how to use it for my business. We've got about 60 odd staff, all the staff need to access the database but it's got sensitive client information so that can't be made public. Currently I've got all staff using one generic account and they all use the same password so they can view the data. This is not very good, when anyone leaves the firm they still have the account details and access to the database. So how do I do this? What's the best practice
Lost all my data and new data can no longer be saved.
I recently found out that I lost all my data saved under "Job Applicant" which I created under Zoho Creator. As I enter new data and submit, data is not being saved anymore.. what is happening?
Add a Record by Email: File Upload
The ability to add html data (rich text) by email is terrific (see https://help.zoho.com/portal/en/community/topic/rich-text-data-by-email) It seems logical to extend this functionality by also accepting an attached file. There are a number of situations where this could be valuable. For example, accepting PDF contracts, job applications as Word documents, and system logs as text files. In email, attached files are MIME blocks that are encoded with Base 64. Listed below are some typical ones A Picture
Next Page