
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2019 09:07 AM
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:
-
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2019 12:12 PM
Great stuff as always! Looking forward to playing Airtable Blackjack
