Labels for Subtotals & Grand Totals in View...
I've enabled the sum function for a numeric field, and I get subtotals and grand totals for that field in the view. The downside is that my users might not readily know what these fields are. Can I add a label in the view to define them? I've attached a screenshot for reference.
How to Customize Form
How do I go about customizing the Zoho form to fit in with my website? All I am seeing is the iFrame and the PermaLink. I have tried viewing the source for the PermaLink, but the form does not process right. Help!!
Dynamical Line-Item Form
Dear all, I would like to create a typical form-document in ZOHO Creator. With a Header, table and footer. For example a Sales Order Document: User can enter the Customer information, Dates, ... on the Document header. Then user wants to select the Products in the Table area. The table area should add more and more lines dynamically, as more lines the user would enter. For example the first line will be displayed per default with columns like Product Code, Product Name, Quantity, Price, Tax, Discount,
Filters for Dynamic Picklists
I've created a dynamic picklist using script. When I attempted to filter a view by that field, I noticed that there were no options (since the picklist is populated from another form). I thought then I might have to use a lookup field (because I tested it and noticed that the field values were available in the filter) but then noticed from the help topcics : Note: You cannot set the criteria expression based on field values in the current form. The lookup field could not meet my requirements because
Implementation details of iCal Feed
This is how the iCal Feed will be available in Zoho Creator. - Views(List,Summary or Grid) which has a Date-Time field in its list of columns selected, will have an additional option "iCal Feed" under More Action. - Once the user clicks the option, a pop-up window similar to Embedding Options will be opened - In the popped up screen, User will first enable the iCal feed. - Once enabled, user will get a default feed url - Options for matching the view columns with the iCal property names will also
Using "if" statement if nothing is selected in multi select box
I would like to send an email only if at least one item is selected in a multi select box. However, I am not sure how to do this. I've tried (see highlighted text): if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != null)) and if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != "")) but neither of these work. What is the
Subject of your feedback
Hi - Is there any way to script something to delete old records (say, records prior to 1 year from today). Thanks Alfio
Scheduler Workaround: SOLVED
I know the ZC team is working on the Scheduler (to be released in June I guess). However, I have been toying with a workaround using free serveries that send scheduled emails. The idea being to kick-off some code when the email is received. My question is, how to I get this to work with a private application? I get this result: "You are not authorized to add record"
Hitting 2 birds with one stone
Hello friends, Is it possible to fill in 2 fields at once using lookup in Creator? My database has 2 forms: sales report and tax rates. From the tax rates forms I have 2 fields: COUNTY and TAX RATE. Both these fields are also in the sales report form. Instead of using the lookup object for both, can I not just select the COUNTY and have the corresponding TAX RATE automatically filled in? Or do I need to write a script? Thanks!
Sequential Dropdowns
Hi I am trying to alter the options available in a dropdown field based on the values entered in 2 preceding dropdowns. So, for example dropdown 1 allows the choices "core", "higher" and "advanced", dropdown 2 has a choice from 10 values (e.g. general, acutely ill, cardiothoracic) and then dropdown 3's list depends on the combination of values from dropdowns 1 and 2. That means Core-->General-->dropdown 3 choices will be different from Higher-->General-->dropdown 3 choices. Can you give me any guidance
ZOHO Reports: Cost vs Value
This follows from the Cycle 3: The Path Forward discussion which got off track: http://help.zoho.com/portal/en/community/topic/cycle-3-the-path-forward Please use this post to continue the discussion on the value, strategy, and cost of ZOHO Reports for Creator... To start off, I think the Number of Reports = The Number of Applications/plan
Change Email
Hi, How can I change Zoho.UserID (Email), in order to send emails using other email (not the one in my account?) If necessary, how can I change my account email? Thanks Nuno nunoalexandre
Cycle 3: The Path Forward
Since Cycle 2 has been completed and Gave has stepped down, the community needs to consider a path forward for Cycle 3. I'm fine being the new coordinator, unless somebody else feels strongly about this. In this role, I will again offer a ZOHO app for you to submit ideas, followed by an evaluation phase with Charles et. al, and finally a voting phase. Let's discuss the path forward for at least the next several days before we start the ideation session.... Thanks,John (NiskyPTO)
Can custom actions be added to Summary View?
I created a custom action and added it to my app's Summary View - but the action does not display on any of the records. Is there a limitiation that Summary views cannot use custom actions? or is there something I need to setup to allow it?
Reset radio button on edit record?
Is it possible to reset a radio button to a certain value when I edit a record? I have a radio button with the simple options of "Yes" or "No". How can I make it so that when I click "Yes" and then submit that the next time I edit that record the radio button goes back to "No" automatically? Thanks in advance for any help
How do I assign an image to image upload field?
I have an image upload field in my form. The image upload is optional - but I want to provide a default image for those cases when the user does not upload an image. Sorta like a "no picture available" type graphic which gets stored with the record. How can I get the form to pick up my "no pic avail" image into the image upload field? And where would I store the image so that the script can access the image?
Can Summary view have custom actions?
I created a custom action that I use in my List View. I've added it to my Summary View but it does not appear. Is there a limitation? or am I missing something? I have customizations on the summary view- does that matter?
For each record criteria & formula fields
I have two forms (A & B). Form A has the following fields: Lot Description formula field combining the two fields Lot_Desc. Decision box Form B has a lookup to form A using the Lot_Desc field. In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria? for each x in Batch [Lot == input.Lot] works for each x
How to use boolean for empty text field
I want to enable an action (sendmail) only if the two conditions are true: 1) Text field "SenttoEncode" has no text entered 2) Radio button is set to "No" How do I write the "if" statement to do something when the two conditions are met? I have tried: if ((input.SenttoEncode != null) && (input.STPandDolby == "No")) and if ((input.SenttoEncode == "") && (input.STPandDolby == "No")) Neither of these work as the next step is to send an email if the condition is true, and even though the
Creator Form fields don't match view fields
I was editing a field the other night and canceled out of it. The fields I see in the application form view are all there (I have several), but I only see a few of them in Edit Mode now. What happened? How do I get them back?
Form Fields in edit mode don't match fields in application view
I was editing a field the other night and canceled out of it. The fields I see in the application form view are all there (I have several), but I only see a few of them in Edit Mode now. What happened? How do I get them back?
Dates are a Mess!
Dates are a mess....you guys need to understand that the U.S. market uses a different format than in India. It is month day yeasr - not day year month. With the date field on a form, if you enter using slashes as mm/dd/yy the system interprets it as dd-mm-yy. So I have lots of bad data in my system. In such cases it should be interpreted as mm-dd-yy. Please fix.
Zoho creator+google maps
Using Zoho Creator ,Yahoo Pipes,and Google maps to Build cool mashups. Note:I will upddate links and Images for your Reference shortly please check for my blog mesporatitech.blogspot.com/2007/11/using-zoho-creator-yahoo-pipesand.html Intro: Integrating Data (overlaying in developer terms) onto maps (Google, yahoo) has become a fad these days, the applications range from trivial to Interesting. By opening up their Mapping platforms Google and Yahoo, have given Interesting framework on which developers
Google Calendar iCal feed setup question
I am trying to add a Zoho Creator ical URL to Google Calendar without success. In Google Calendar I go to Add/Add by URL then paste in the following ical URL and select 'Add Calendar'. I get the following error...."Failed to add imported calendar at https://creatorexport.zoho......... for user@gmail.com" I followed the ical feed steps at http://help.creator.zoho.com/iCal-Feed.html My Zoho App is private, so I selected the link that adds in the encrypted code. I've tried two versions of the URL.
Set a variable in a FORM from a VIEW
I've figured out how to do some custom actions / functions within zoho -- but now I'm trying to figure out how to have a custom action in a VIEW populate 2 fields in a FORM. This is an application that helps us manage child sponsorships in South Africa, Moldova, and Brazil. We're trying to add a little more functionality -- and have photos, ages and first names available for people to look through as they are setting up a new sponsorship. User Action would be like this: User goes to VIEW - which
script for returning values in a Multi-Select field
Dear Friends: I'm a newbie to databases and scripting, so I need a very basic helping hand. I've created a database to collect data about metrical events that occur in lines of poetry. The fields I've created, together with abbreviations I use for the individual events, are these: Lines (Single-Line) Properties (Multi-Select) Penthemimeral (Single-Line) (pc) Hepthemimeral (Single-Line) (hc) Bucolic Diaeresis (Single-Line) (bd) Homodyne in 4 (Single-Line) (hm4) Heterodyne in 4 (Single-Line) (ht4)
render image in HTML view with different dimensions
How do I display an uploaded image with a different width/height in my HTML view? On my form, I have a display_picture field with the formula specifying an image width of 100, and I render it in my HTML view using <%=rec.display_picture%>. How can I specify different width/height dimensions when displaying it in HTML view?
In a view, how to prompt for text and then set specific fields to that value for all selected records
Subject pretty much describes it.... Want to have a custom action which prompts for some text, which then sets a specific field of all selected records to that text. Any pointers anyone? Thanks in advance
Syntax error: function doaction(recType)
I have a form that has three fields: one drop-down, one text entry, and one checkbox. I have this code in the checkbox, on user input: if(input.Tickybox == null) { enable DropdownField; disable TextentryField; TextentryField=""; } else { disable DropdownField; enable TextentryField; DropdownField="-Select-"; }When I go to the form, I can check the box once and have it work as it should, but subsequent checkings don't work. In Firefox's error console, this comes up:
Managing variable name in multiline text field
Hi everyone, I'm using a form to store success messages that I display in HTML view. I'm calling the message with his ID from the HTML view like this : In my HTML view, I have : e = Entreprises [ID == input.entreprise.toLong()]; // Fetching the good enterprise m = Messages [ID == input.MessageID.toLong()]; //Fetching the message to display In the message table for the matching ID I have (multiline text field): You have created <%=e.Entreprise%>
iCal Feed Issue for Robots.txt Setting
Google calendar is reporting this for ical feeds
look up configuration dialog box not showing multiselect/radio button/multiline fields
Hi Zoho friends, I am creating a form that has look up fields from another form. The fields I want to look up are multi-select and radio button fields. I drag the look up field to the new form, I select the correct application for the look up, I select multi select or radio button as the type. When I scroll down to select the field to copy, there are only the single line fields, and none of my multi-select or radio button fields show as an option. I must be doing something stupid here, but what?????
Problem for addind users to an app
Hello, I've got an error message when i want to share my app to multiple users. It says "an error occurs, try later or reload" (broadly) since yesterday. May you fix it 'cause i need to add 20 users quickly. Thanks
Cycle 2: HTML View To PDF
As you will see here ... http://help.zoho.com/portal/en/community/#Topic/2266000000398836 ... the suggestion made by user deepa7476 (HTML View to PDF - http://help.zoho.com/portal/en/community/?ftid=2266000000361648) was voted by the Community as the one to be developed by the dedicated resource at the ZOHO Creator Team. I have opened this post so that all details pertaining to the design, development, testing and implementation of this feature can be discussed in a central place. I urge Charles
Firefox/Chrome need different reference then IE for conditional statement to work
You may be aware of this already but just in case there are those out there who might benefit: When creating an if statement that references a unselected dropdown list you need to use "-Select-" for Firefox/Chrome and "" for IE. Easy workaround is of course to do the following: else if (((input.Report_Type == "Slotting Graph") && (input.Region != "")) && (input.Region != "-Select-")) where Region is your dropdown list. It is not necessary but it would be interesting to know why this is
Populate controls in a parent form
Ok, this will be kind of long, so please bear with me. I have a form (see below) that allows the user to choose an Agency, and in so doing, the form will display the Venues associated with the selected Agency, as well as offering the option of "New Venue." If the user chooses an existing venue, the database will populate the Venue Details field (see below) However, if the user chooses "New Venue", it will open a pop-up form, and prepopulate the required fields, that will allow the user to enter
Query a XLS table
I'm new to Zoho creator and I wonder if it's possible/where to find a working example of what I plan to do. I basically want to create a status checking application where I will import an XLS sheet that contains email, password, status and other info. The users will be present with a form that contains email and password field. When submit, it will query the table and depends on the value of the Status column, will return different custom message. I will update the XLS offsite and upload the XLS
Can I create an online calculator for my website?
Hi, I am a wedding photographer and I am considering building an online calculator which will cost up wedding packages for prospective clients online. They would enter information from dropdown lists like year and month of wedding, then choose which services they want with radio buttons and checkboxes - this will then calculate a price for their package. They should be able to print that quote out - and I should get a copy of it emailed to me. However when the page gets refreshed it should go back
Ability to perform an action at a future date
hi im new to creator, so this might be a stupid question, but an answer to this might get me to work on creator. you could even point me to the right direction i need to create a very simple tool where we feed in a future date and time with the comment and the comment goes to a web URL on that date and time. basically like a reminder thing. is this possible with creator. thanks in advance
Is the limit of records within one month or one year or perpetuity?
Dear All, Please open http://www.zoho.com/creator/pricing.html, e.g the $25/month plan, it has 10,000 records, so could you tell me Is the limit of records within one month or one year or perpetuity?
Next Page