302 Found

Found

The document has moved here.

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

February 5th, 2009 - 6: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 - 6: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 - 6: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". (Don't know how to add a field? Please read: https://www.quickbase.com/help/adding_a_field.html)

February 5th, 2009 - 6: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 - 6: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 - 6: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 - 6:02 PM
302 Found

Found

The document has moved here.