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.

1In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.

2. Click the field's name that you want to modify.

3. Select the "Allow users to create new choices" check box, and click "Apply Changes".

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:

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:

To learn how to change the ownership of a single record, please read the online help: http://www.quickbase.com/help/default.html#change_record_owner_single.html

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"