Application

Syndicate content

This would occur if the spreadsheet's or database's CSV (comma separated values) parser is substandard. Excel comes with an excellent CSV parser that knows how to deal with hard returns (aka line breaks, paragraph markers, etc.) that are embedded within the contents of a field.

February 5th, 2009 - 6:02 PM

To maintain rapid application response time, QuickBase does not allow an import of more than 1000 records containing a user field. If you're unfamiliar with user fields, please review this help topic.

https://www.quickbase.com/help/about_local_users.html

The 1000 record import limit only applies to records containing a user field.

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

It is possible and quite easy to import data into QuickBase in such a way that it will update existing records. The key to being able to do this is that you must include the key field so that QuickBase knows exactly what records to update. By default the key field is the "Record ID" field.

You should go through these steps to export then reimport records:

February 5th, 2009 - 6:02 PM

Yes. Templates are provided to help you get started. Once you create a new application using a template, you can customize all aspects of the application.

February 5th, 2009 - 6:02 PM

Access to a particular QuickBase application is controlled by anyone who has administrative privileges for that application. Permission for each user of an application can be set to permit: View, Modify, Add Record, Delete Record, Save Views, and Full Administrator. The message you are receiving indicates that you are attempting to perform an action that you don't have permission for.

February 5th, 2009 - 6:02 PM

Create two summary fields in the Projects table. The first summary field will be labled "Number of Tasks". It should be configured to count the number of Tasks. The second summary field should be labeled "Number of Completed Tasks". It should be configured to also count the number of related Tasks with a condition to include only the Task records where the "Status" field is "Completed".

February 5th, 2009 - 6:02 PM

You can use formulas to create fields that are calculated based on other fields or the time of day. There are a variety of built-in functions that can be used in formulas.

For information on how to use formulas in QuickBase, see "Using Formulas in Quickbase" at https://www.quickbase.com/help/using_formulas_in_QuickBase.html.

February 5th, 2009 - 6:02 PM

© 1997-2013 Intuit Inc. All Rights Reserved.

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