Rock Paper Airtable
This base contains a formula that was the Airtable contest winner for April.
Watch my just released interview with @Zoe_VanDerPloeg on Built on Air, an @openside podcast.
overview:
This is a playable “Rock Paper Scissors” game against Airtable. The game play is best using a public form view which allows anyone to play regardless if they have an Airtable account.
“AI” design:
Airtable’s choice is based on a sudo random number generator:
IF({Human_Choice},
SWITCH(
MOD(
VALUE(
DATETIME_FORMAT(CREATED_TIME(),'s')
),3
),
0,'🗿',
1,'📜',
2,'✂️'
)
)
What it’s doing is choosing based on the time of record creation. It’s a clock that just happens to only have only a seconds hand. And it can only count to three. Instead of the clock having numbers they are “Rock, Paper, scissors”.
interface design:
- A Public Form View:
this is a single entry form where the player chooses their move
- A Public Block View:
this is a page designer block that always shows the most recent result of a match. It is expected that there is only one human player at a time.
play now:
bonus:
