302 Found

Found

The document has moved here.

view

Syndicate content

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

The "Edit" and "Display" Icons shown in table reports can be displayed in one of two styles: Descriptive or Small

This is a user-defined setting, effective for all applications with which user interacts, and is controlled via the User Preferences for each user.

Read how to change your user profile preferences: https://www.quickbase.com/help/change_my_user_profile.html

February 5th, 2009 - 6:02 PM

1. Open the table containing the report.
2. Click Reports & charts. A listing of the reports on the table appears.
3. Choose the report you're looking for. 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:

https://intuitcorp.quickbase.com/db/6ewwzuuj?a=q&qid=6

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

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.

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

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")) & "')}"

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.