Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Conditional Reference Links to Data Table

Topic Labels: Base design
704 0
cancel
Showing results for 
Search instead for 
Did you mean: 
tomkenkel
4 - Data Explorer
4 - Data Explorer

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