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:

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]

Yes.

Create a summary report using the "percentage of total" option. Please see: https://www.quickbase.com/help/creating_a_summary_view.html

In the table bar on any application page, click the table featuring the report. Within the menu that appears, select Customize --tablename-- table > Reports. Click on the "Display" button next to the particular view name to bring up the view. If you look in the address bar of your browser you'll see the query identifier as the last numeric portion of the URL.

For example:

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.

Let's assume that you have a District table, a Contacts table and an Orders table. The District table is the master table to the Contacts table and the Contacts table is the master table to the Orders table.

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.

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"