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:

• Also included is a separate table “Rock, Paper, Scissors, Lizard, Spock” which is a game created within the show “The Big Bang Theory”.

• Separate post to come soon: