Common Solutions: Beginner

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...

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 ...

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...

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 ...

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'...

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 ...