Contents x
Common Solutions: Beginner
6 Articles  in this category
  • Print
  • Dark
    Light
Contents

Common Solutions: Beginner

6 Articles in this category
  • Dark
    Light

Using checkbox fields in formulas

When working with checkbox fields and formulas, "= 0" means that a box has not been checked, and "= 1" means that a box has been checked. So, to make a formula field which returns A when a box has been checked, and B otherwise, you would need to se...
Updated on : 06 Jul 2022

Converting numbers and text in a formula field

In addition to using formula functions to convert data types, there are a few alternative options you can implement in your formulas to cause similar conversions. Number to text string If you append &"" to a formula working with numbers, then ...
Updated on : 06 Jul 2022

Convert a serial date from Excel to a readable date

One of the ways Microsoft Excel stores dates is as serial numbers which are formatted to be used in calculations ( more here ). This means that by default, January 1, 1900 is serial number 1, with each new day being assigned the next sequential numb...
Updated on : 06 Jul 2022

Extract the file name from attachments

If you'd like to extract the file name from a file in the attachment field, you can do so with a formula like the example below: LEFT({Attachment Field},FIND("(",{Attachment Field})-1) Note that this formula only accounts for attachment ...
Updated on : 06 Jul 2022

Convert unix / epoch time to current date

Epoch time is defined as "the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch'...
Updated on : 06 Jul 2022

Using a formula in the primary field

The primary field (the first column in any table) can be configured as a formula, which takes data from other fields in the table to compose a unique name for each record. This can be useful if your table does not lend itself particularly well to ...
Updated on : 22 Aug 2022