A while ago, my boss asked if it was possible to set up an automated tip of the day. His idea was to have an Airtable base with a list of tips and use Make to grab one each day and post it into Slack.
I’d already come up with my own auto-numbering sy...
For those interested, the base has been published to Universe.
Airtable
The Tip of the Day - Airtable Universe
A while ago, my boss asked if it was possible to set up an automated tip of the day. His idea was to have ...
A conditional autonumber is very achievable with two related tables and zero automation (no need for Pro). You can do this by rolling up the recordIDs (or a UNIX timestamp) of related records, and then searching for the position of that number within...
Yes. You’d need to nest your if statements. Remember that an if looks like IF(A is true, Do This, Otherwise do that). Your ‘Do This’, and your ‘Otherwise do that’ can be additional IF statements. So, you build the IF needed to test for your employee ...
You can make the formula dependent upon a day of the week. Datetime_Format provides a way to get the ‘day of the week’.
So you could do this with something like IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Thursday',{Total Load}-{Total Load}*{Deduction amo...
