Skip to main content


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:



  1. A Public Form View:

    this is a single entry form where the player chooses their move

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



Great stuff as always! Looking forward to playing Airtable Blackjack


Reply