Text

Syndicate content

The formula looks like this:

Right("00" & Left([IP Address], "."), 3) & "." &

Right("00" & Left(Right([IP Address], -1 + Length([Ip Address]) - Length(Left([IP Address],"."))),"."),3) & "." &

Right("00" & Right(Left([IP Address], -1 + Length([Ip Address]) - Length(Right([IP Address],"."))),"."),3) & "." &

Right("00" & Right([IP Address], "."), 3)

February 5th, 2009 - 6:02 PM

right("000" & floor([octet1]), 3) & "." &
right("000" & floor([octet2]), 3) & "." &
right("000" & floor([octet3]), 3) & "." &
right("000" & floor([octet4]), 3)

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

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

February 5th, 2009 - 6:02 PM

The field containing red values is a multiple-choice field. The red values are "orphaned" values. An orphaned value is an choice that was removed from the list, but still appears in some records. By showing that entry in red, QuickBase is alerting you to this disconnect. If you add that entry back to the multiple-choice list, those values will appear in black again.

February 5th, 2009 - 6:02 PM
Tags:

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

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

© 1997-2014 Intuit Inc. All Rights Reserved.

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