Skip to main content

Hi all! New here — thanks in advance…



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.







QUESTION



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!







SCREENSHOTS





  1. 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.


  2. Section of Players table with “reference buttons.”






Be the first to reply!

Reply