# AirTable

Wow wow wow AirTable continues to impress.

### Formula Things

[Formula Reference](https://support.airtable.com/docs/formula-field-reference)

<p class="callout info">Formulas in AirTable are Excel / Google Sheets adjacent, but the syntax is a bit different.   
</p>

##### 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:  


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

```

##### Here’s a conditional IF

```scala
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&amp;D.

A further change:

```scala
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  


```scala
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')
```

[![AirTable-DateConcat.png](https://tech-almanac.org/uploads/images/gallery/2025-04/scaled-1680-/airtable-dateconcat.png)](https://tech-almanac.org/uploads/images/gallery/2025-04/airtable-dateconcat.png)

### 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](http://DocsAutomator.co) - 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.