view

Syndicate content

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

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

February 5th, 2009 - 6:02 PM

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

If your boss is like my boss, she wants to know what I accomplished this week, what I accomplished last week, and what I plan to accomplish next week. Building Reports in QuickBase to help you manage this reporting requirement can be a little tricky, but with some well-built formula fields in your data table, you can get it done.

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

When you set up a Role, you can limit the reports that are available to users on that role. If however, you have "activated" or given access to the role "Everyone on the Internet," your users will see the "superset" of all reports available to their Role as well as the Everyone on the Internet role.

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

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

1. Create a new view or edit an existing one. On your Repot Builder screen, click on "Custom Options" in the "Additional Options" screen. Check the "Define a custom formula column for this view" box to further expand this section.
2. In the "Type" drop-down list, select "Checkbox."
3. In the "Formula" box, enter the following formula:
[Field 1]=[Field 2]

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