Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Conditional Reference Links to Data Table

Topic Labels: Base design
229 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Screen Shot 2021-09-08 at 11.09.52 AM

Screen Shot 2021-09-08 at 11.07.53 AM

0 Replies 0