QuickBase Resources - recordshttp://quickbase.intuit.com/developer/taxonomy/term/57/0
enCan I color records in a calendar report?http://quickbase.intuit.com/developer/knowledge-base/can-i-color-records-calendar-report
<p>Yes you can!
You can create a formula text field that will display the value you want to see on the calendar as well as showing a color. In other words, if you want to see the Status of a record in red on your calendar, you could create a formula text field that displays the value from the field Status and is colored red. You would then display this formula text field on your calendar report.
</p><p>Step 1. Create a Formula - Text field. For more information, please see our <a href="https://www.quickbase.com/user-assistance/default.html#adding_a_field.html" rel="nofollow">Add a New Field</a> help topic. </p><p>Step 2. Enter the field properties of your formula field (To learn how, please see our <a href="https://www.quickbase.com/user-assistance/default.html#changing_field_properties.html" rel="nofollow">Change the Properties of a Field</a> help topic.). </p><p>Step 3. Check the "Allow some HTML tags" checkbox in the Text Options section. </p><p>
Step 4. Enter the following formula into the formula field with the exceptions listed below.
</p>
<pre>If(IsNull([User Initials]),"",
[User Initials]="AC","&lt;div style="background-color: #ff9999;"&gt;AC&lt;/div&gt;",
[User Initials]="SR","&lt;div style="background-color: #99ffcc;"&gt;SR&lt;/div&gt;",
[User Initials]="AE","&lt;div style="background-color: #ffff99;"&gt;AE&lt;/div&gt;")
</pre>
<p>The formula above says, "If the value in the field User Initials is blank, do nothing. If the value in the field User Initials is AC, color the field background red and show the text AC. If the value in the field User Initials is SR, color the field background green and show the text SR. If the value in the field User Initials is AE, color the field background yellow and show the text AE." See example color output:</p>
<table border="1">
<tr><td bgcolor="#FF9999">AC</td></tr>
<tr><td bgcolor="#99FFCC">SR</td></tr>
<tr><td bgcolor="#FFFF99">AE</td></tr>
</table><p>What you need to change to the formula:
</p><p>
1. Replace the words User Initials (everywhere they appear) with the name of the field whose value you want to display on your calendar. If I take my original example where I wanted to show the value from the field Status, I would replace User Initials with the word Status.
</p><p>
2. Replace AC, SR, and AE (everywhere you see them) with the values in your field you want to see on your calendar. Returning to my example of the field Status, I would replace AC with Overdue, SR with In Progress, and AE with Not Started.
</p><p>
3. If you like, you can change the colors that the formula displays. Below is a link to the Wikipedia page describing the hexadecimal codes for colors.
<a href="http://en.wikipedia.org/wiki/Hexadecimal_color" title="http://en.wikipedia.org/wiki/Hexadecimal_color" rel="nofollow">http://en.wikipedia.org/wiki/Hexadecimal_color</a>
</p><p>Step 5. Save your changes, and create a calendar report to see what they will look like. (To learn how, please see our <a href="https://www.quickbase.com/user-assistance/default.html#creating_a_calendar.html" rel="nofollow">Create a Calendar</a> help topic.)</p>http://quickbase.intuit.com/developer/knowledge-base/can-i-color-records-calendar-report#commentsRecovery / RestorecalendarcalendarscolorcoloredcolorizedcolorsfieldfieldsformulaformulasrecordrecordsreportreportsrowrowsviewviewsThu, 25 Jun 2009 18:56:14 +0000sshearin2290 at http://quickbase.intuit.com/developerWhat does this alert mean? “The application (application name) is almost out of room”http://quickbase.intuit.com/developer/knowledge-base/what-does-alert-mean-application-applicationname-almost-out-room
<p>This Alert indicates that a table in your application has almost reached its storage limit size. In order to keep the "quick" in QuickBase, tables have a maximum size limit. When this limit is reached, users are prevented from adding new records.</p><p>To see how close you are, you can check your application's
statistics:</p><p>1. From the Home&nbsp;page of the app, click <strong>Settings</strong>.</p><p>2. Under Advanced Features, click <strong>App management</strong>.</p><p>3. Click <strong>Show app statistics</strong>.</p>http://quickbase.intuit.com/developer/knowledge-base/what-does-alert-mean-application-applicationname-almost-out-room#commentsTablesalertsapplicationsappslimitationslimitsmy appsmy quickbaseoutrecordssizespaceTue, 02 Jun 2009 18:39:06 +0000pgross2287 at http://quickbase.intuit.com/developerHow do I limit a report to only show the top 5 records?http://quickbase.intuit.com/developer/knowledge-base/how-do-i-limit-report-only-show-top-5-records
<p>You can limit a report to only show the top 5 records by adding this string to the end of the URL you see while viewing the report.
</p><p>&gt; &amp;qskip=0&amp;qrppg=5
</p><p>You can replace 5 with another number to return a different amount of records. Be aware this will only work for table reports.</p>http://quickbase.intuit.com/developer/knowledge-base/how-do-i-limit-report-only-show-top-5-records#commentsReportsdisplayslimitsonlyrecordsreportsreturnshowviewsTue, 02 Jun 2009 18:13:39 +0000quickbase2286 at http://quickbase.intuit.com/developerWhy do I get an error message when I try to upload more than 10,000 records containing a user field?http://quickbase.intuit.com/developer/knowledge-base/why-do-i-get-error-message-when-i-try-upload-more-10000-records-containing-user-field
<p>To maintain rapid application response time, QuickBase does not allow an import of more than 10,000 records containing a User field. (If you're unfamiliar with User fields, please review <a href="https://www.quickbase.com/user-assistance/about_local_users.html">this help topic</a>.)</p>
<p>The 10,000 record import limit only applies to records containing a User field.</p>
<p>If you have a file that exceeds this limit, consider breaking it up into chunks of data where each chunk contains less than 10,000 records. Also, if your file is over 10,000 records because some of the data you are importing is static, consider only importing your changed records instead of all archival data.</p>
http://quickbase.intuit.com/developer/knowledge-base/why-do-i-get-error-message-when-i-try-upload-more-10000-records-containing-user-field#commentsImport10000errorsexportsfieldsimportslimitsmessagesrecordsuploadsusersThu, 05 Feb 2009 22:16:23 +0000quickbase2153 at http://quickbase.intuit.com/developerWhy are the detail records not displaying in the master record form?http://quickbase.intuit.com/developer/knowledge-base/why-are-detail-records-not-displaying-master-record-form
<p>If you can no longer see detail records in a report that you've embedded on a master form, someone has changed the Filtering (matching criteria) for that report. </p>
<p>Check settings of the embedded report - particularly settings in the Filtering section. Reports you embed on a Master form should have no filtering criteria set. More details about adjusting embedded reports can be found <a href="http://www.quickbase.com/user-assistance/default.html#embed_view.html">here</a> (specifically, see the FAQ at the bottom for more info).</p>
http://quickbase.intuit.com/developer/knowledge-base/why-are-detail-records-not-displaying-master-record-form#commentsView FormschilddetaildisplayembedformrecordstasksThu, 05 Feb 2009 22:16:09 +0000quickbase2059 at http://quickbase.intuit.com/developerHow do I copy a project and all its task records while maintaining the dependencies?http://quickbase.intuit.com/developer/knowledge-base/how-do-i-copy-project-and-all-its-task-records-while-maintaining-dependencies
<p>In the July 2011 release, we introduced a QuickBase feature called <strong>Copy Master and Detail Records</strong>. Use this feature to add a button to a master table that either copies the master record with its detail records, or imports a set of detail records into a different master record. QuickBase maintains relationships and dependencies when copying or importing the records. The Copy Master and Detail Records feature is available from <strong>Home &gt; Settings &gt; App Management</strong>. To learn more, please see our <a href="http://www.quickbase.com/user-assistance/#copy_master_detail.html">About the Copy Master and Detail Records Option</a> help topic.</p>
<p>Note: There used to be a stand-alone version of the wizard, but the current version is recommended.</p>
http://quickbase.intuit.com/developer/knowledge-base/how-do-i-copy-project-and-all-its-task-records-while-maintaining-dependencies#commentsImportcopycopy projectdependencydetailmaintainprojectrecordsrelationshipsubtasksThu, 05 Feb 2009 22:15:50 +0000quickbase1946 at http://quickbase.intuit.com/developer