I’m recording activity of participants in a challenge to earn points. There are about 18 participants and the challenge consists of answering several questions daily. The participants can earn 1 point, 0 points, or choose not to answer.
I have a base with 3 tables. Players (i.e. “participants”), Challenges, and Data. The Players table links to Data and uses a couple Rollups to SUM() total Points and to COUNTALL() total Entries. The Data table includes a column for earned points (either 1 or 0).
In the Players table’s initial “Link to Data” column (Data Records), Airtable inserts references to the Data table as “reference buttons” — so I can click the reference and see the full record.
How do I add a column that inserts “reference buttons” only to records where Points = 0 (zero)?
Any other insights into base design much appreciated!
Sample of Data table grouped by date and “challenge question” (e.g. “Breakfast”). Each response to the question on a date receives 1 or 0 points.
Section of Players table with “reference buttons.”