QuickBase doesn't set the width of columns in reports. Since the program has no way of knowing what font and font size a user's browser is configured to, we leave it to the browser to determine the appropriate widths for each column and the appropriate width for the entire view. Usually the browser does a pretty good job of this.

Most QuickBase data will export seamlessly into Microsoft Excel. However, there are some cases when data is lost or displayed with the incorrect formatting.

One example is exporting a 5-digit zip code stored in a text field. When displayed in Excel, any leading zeroes in the zip code are lost. Similar problems can happen when exporting ID numbers, etc.

1. I have a time of day field set up as military time but when it exports to Excel it converts to normal time and adds AM/PM.

For example, 18:00 exports as 6:00 PM.

2. I have a duration field that is exporting differently than on the view.

For example, 2:30 exports as 2.5 hours.

In order to display a date in this special format, you'll need to create a new field whose job is only to display the date.

To do so, add a field to the table containing your existing date field and make its type "formula - text". (Don't know how to add a field? Please read: https://www.quickbase.com/help/adding_a_field.html)

Let's assume the text field is called "Notes". Create a formula text field with the following formula:

Left([Notes], 100) &
" " & URLRoot() & "db/" &
dbid() &
"?a=dr&rid=" &
[Record ID#] &
"&dfid=11"

where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form please read:

Assuming your date field in QuickBase is called "Your Date Field Name".

Create a text formula field and set the formula to this:

Year([Your Date Field Name]) & "-" & Right("0" & Month([Your Date Field Name]), 2) & "-" & Right("0" & Day([Your Date Field Name]), 2)

The font that is used to enter information is controlled by your browser's setting. Refer to your browser’s help for directions on changing font settings.