AirTable

Wow wow wow AirTable continues to impress. 

Formula Things

Formula Reference

Formulas in AirTable are Excel / Google Sheets adjacent, but the syntax is a bit different. 

Here’s a conditional IF to apply contingency to a line item:

IF({CONT} = BLANK(),0,SUM(ESTIMATE*.2)) “CONT” is field name
“BLANK” is if the box is checked

Here’s a conditional SWITCH to apply different contingency numbers on a line item:

SWITCH(
{CONT},
  "Buffer", SUM(ESTIMATE*.2),
  "Something", SUM(ESTIMATE*.22),
  "None", 0
)

Here’s a conditional IF

IF(
  {Watts/Unit} = 0,0,
  SUM(({Watts/Unit}/{Volts/Unit})*IF(OR(Calc = "R&D",Spare = 1),0,Qty)))

It’s saying if watts are filled out, complete the formula to calculate for Amps, then multiply by quantity to get the calculated Amps unless it is a spare unit or it’s used for R&D. 

A further change:

IF({Watts/Unit} = 0,0,SUM({Watts/Unit}/SWITCH(
Volts,
"110v",110,
"208v",208)
)
*IF(OR({Budget Calc} = "R&D",Spare = 1),0,Qty)
)

Adding this switch makes the Volts column attached to a variable switch. Based on voltage selection, calculate amps. If I add in additional voltage options, I will need to manually create that switch in the Volts column and then add it to the script.

Here’s a formula that will concat two date strings

DATETIME_FORMAT({Start Day / Time}, 'ddd') & " - " &
DATETIME_FORMAT({Start Day / Time}, 'MMM') & " " &
DATETIME_FORMAT({Start Day / Time}, 'DD') & " From " &
DATETIME_FORMAT({Start Day / Time}, 'hh:mm') & " to " &
DATETIME_FORMAT({End Date / Time}, 'LT')

Extensions

You can install extensions that do a variety of things. Some are paid if by third-party. Can recommend “Page Designer” (buggy, but functional) and “Charts.

Third-Party Tools

DocsAutomator - Highly recommended tool that takes the concept of AirTable's Page Designer and makes it... good. Really good. This is a paid tool, but the capabilities it adds are great. There's a bit of learning curve.