view

Syndicate content

Yes you can! You can create a formula text field that will display the value you want to see on the calendar as well as being a colored. In other words, if you want to see the Status of a record in red on your calendar, you could create a formula text field that displays the value from the field Status and is colored red.

June 25th, 2009 - 2:06 PM

Use a field of type "Formula - URL (Link)". Set the cover text to "Click Here.." and then use a formula to point to a report that selects for only one record based on the Record ID# field which is unique for every record.

The URL for a report using the API is for example:

February 5th, 2009 - 6:02 PM

1. Create the report that you want to embed (To learn more, please see our Create a Table Report help topic.)

2. In the HEAD section of your Web page, add the following <script> block:


February 5th, 2009 - 6:02 PM

To achieve the results you are asking about, you will need to do the following:

1) Create a Zip Codes Table where each record is a Zip Code that will be assigned to your projects.
2) In the Zip Codes table, designate a Zip Code (text) field as the key field. (Normally Record ID#)

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, click on 'Custom columns' in the 'Columns' section. Once you've added all the columns you'd like to display on the report, check off the box next to 'Define a calculated column.'

In the expanded area of this section, set the field 'Type' to 'Checkbox.' Enter the following in the Formula box:

February 5th, 2009 - 6:02 PM

To accomplish this, you'd design your report with a custom formula field that combines values in all three contact fields and then (though they won't know it) let users search that field.

February 5th, 2009 - 6:02 PM

For reports with grouped data, clicking a column heading sorts the data within each group based on the selected column. It does not change your groupings.

February 5th, 2009 - 6:02 PM

You have a choice of Normal (HTML), Plain Text, Comma-Separated Values, Tab-Separated Values, XML (flat), or XML (structured). To change your report's output format:

1. On the Table bar, click the name of the table that the report is in.

2. Click Reports & charts.

3. Click the name of the desired report to open it.

4. Click Customize this Report.

February 5th, 2009 - 6:02 PM

1. In a new report or an existing one, create a custom calculated column. To do so, make sure that 'Custom columns' is selected in the 'Columns' section. Once you've added the normal columns you'd like to appear on the report, check off the box next to 'Define a calculated column.'

Set the field 'Type' to 'Duration,' and enter the following in the Formula box:

February 5th, 2009 - 6:02 PM

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit