format

Syndicate content

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 report. Usually the browser does a pretty good job of this.

February 5th, 2009 - 5:02 PM

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.

February 5th, 2009 - 5:02 PM

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.

February 5th, 2009 - 5:02 PM

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". (To learn more, please see our Add a New Field help topic.)

February 5th, 2009 - 5:02 PM

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:

February 5th, 2009 - 5:02 PM

If you'd like to change the default date format to YYYY-MM-DD throughout your account or app, see the instructions in this help topic: http://www.quickbase.com/user-assistance/#about_localizing_dates_numbers...

February 5th, 2009 - 5:02 PM

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.

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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