report

Syndicate content

1. Create the report that you want to embed. If you're not familiar with how to create a table report, the following link explains the steps.

https://www.quickbase.com/help/creating_a_table_view.html

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


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

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

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

Create a report with a custom formula column of type "Text". Use the following formula:

Case(DayOfWeek([Your Date Field's Name]), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday")

Then sort and group on the custom column.

February 5th, 2009 - 6:02 PM

In order to show a portion of a particular field's data on a report and/or form, you need to take these two steps:

1) Create a new formula field that will hold the subset of the original field's data, and

2) Add the new formula field to the forms and reports where you want the condensed field showing.

February 5th, 2009 - 6:02 PM

QuickBase allows you to configure email subscriptions and reminders for each table in your application.   

February 5th, 2009 - 6:02 PM

When you create documents using an exact form, QuickBase generates one HTML file per record. If you want to display all these records in one document instead, do the following:

First find the qid of the report that contains all the records you want to print out with your Exact Form. To learn how to determine the qid of a report please read:

http://quickbase.intuit.com/developer/node/2087

February 5th, 2009 - 6:02 PM

If you're using Internet Explorer, you can use any of these XSL stylesheets with QuickBase:

https://www.quickbase.com/xsl/genericstructured.xsl will work with any QuickBase database. Just make sure that the XML output from QuickBase is of the structured form. It will display your database information as a table of records.

February 5th, 2009 - 6:02 PM

© 1997-2013 Intuit Inc. All Rights Reserved.

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