302 Found

Found

The document has moved here.

field

Syndicate content

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 being a colored. 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.

June 25th, 2009 - 2:06 PM

This can be accomplished by adding a new table to your application and using the snapshot property of a date field.

February 5th, 2009 - 6:02 PM

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.

February 5th, 2009 - 6:02 PM

During the import process, if you import your resources, or contacts, by name into a user field (such as Assigned To), QuickBase may not recognize the names as users (To learn more about User fields, please see our Manage Users in an Application help topic.).

February 5th, 2009 - 6:02 PM

The total value at the bottom of a column is the total of all values above it in the report. The same is true of the average value at the bottom of a report. The average value is the average of all the values in the column above it.

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

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 6:02 PM

There are two techniques. The first technique is to convert the field from what ever type (i.e. numeric, text, date) it is to a formula field of the same type (i.e. formula-numeric, formula-text, formula-date). Then convert it back to the type it was. This erases the contents of the field. To learn how to change the type of a field please read the following:

February 5th, 2009 - 6:02 PM

Certain fields are never editable directly. These include the five built-in fields, all formula fields, and all lookup fields. In addition fields that were at one time reference fields can behave in such a way that they don't display either a read-only or an editable value. Here is the situation that creates these former uneditable reference fields.

February 5th, 2009 - 6:02 PM

The best way to do this is to flip the problem around on its head.

1) Instead of making the date field a formula field, make it a plain date field.

2) Then remove the choice of "Complete" from your multiple choice "Status" field.

3) Create a formula text field called "Computed Status".

4) Put the following formula into the formula property of the "Computed Status" field.

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.