Skip to Navigation

Field Types

Syndicate content

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

You reduce or increase file attachments and the change in size is reflected under the application properties but not in the account management application tab.

There are two possible causes.

February 5th, 2009 - 6:02 PM

1. Open the table containing the field, and click Settings.

2. Select Fields.

3. Click the name of the field that you want to modify.

4. In the Choices text box, highlight the choices that you no longer want included in the list, press the DELETE key, and then click Apply Changes.

This works whether or not users can create new choices.

February 5th, 2009 - 6:02 PM

1. Open the table containing the multiple-choice field and click Settings.
2. Choose Fields.
3. Click the field's name that you want to modify.
4. Check "Allow users to create new choices".
5. Click Save to finish.

February 5th, 2009 - 6:02 PM

For a multiple-choice field, you cannot enter a blank line as a choice in the list of options. If you do, the blank line gets removed when you apply your changes. However, you can leave the "Default Value" option blank. If you leave the default value blank, then the Add Record and Edit Record forms will have blank selected in the drop-down list.

February 5th, 2009 - 6:02 PM

Create either a view with a "Custom Column" of type text that has the following formula:

Int(ToHours([Date Created]-ToTimestamp(ToDate([Date Created])))) & ":" & Int(Mod(ToMinutes([Date Created]-ToTimestamp(ToDate([Date Created]))), 60))

or a formula text field with the same formula.

The formula for "Date Modified" would be:

February 5th, 2009 - 6:02 PM

You can create a formula field of type text that has the following formula:

List("-",ToText(Year(ToDate([Date Created]))),Right("0" & ToText(Month(ToDate([Date Created]))),2),Right("0" & ToText(Day(ToDate([Date Created]))),2))

February 5th, 2009 - 6:02 PM

If the key field for your master table that contains the actual file attachment field is the built-in Record ID# field then you can put the following on your Exact Form:

~="<img src='/up/dbidofmastertable/a/r" + fid["11"] + "/e17'>"~

you'll need to replace "dbidofmastertable" with the dbid of the table that contains the pictures. To learn how to discover dbids please read:

February 5th, 2009 - 6:02 PM

QuickBase operations time out after a fixed number of seconds, so the file upload needs to complete before this time out. The two most common reasons why the uploads don't complete is because either of following two causes:

- The file is too large. This can often be remedied by compressing the file with a third party compression application.

February 5th, 2009 - 6:02 PM

© 2016 QuickBase, Inc. All Rights Reserved.

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