Help

Rock Paper Airtable

2052 1
cancel
Showing results for 
Search instead for 
Did you mean: 
bdelanghe
7 - App Architect
7 - App Architect

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:

1 Reply 1
openside
10 - Mercury
10 - Mercury

Great stuff as always! Looking forward to playing Airtable Blackjack