I have a base with two tables (“Studies” and “Outcomes”). The Studies table is a study-level table with bibliographic, exposure, outcome, and other information for each study. The Outcomes table is a long-format table with one row per outcome.
Both t...
I am using Airtable for a systematic literature review and have two tables in one base. In Table A, I am extracting individual outcomes from 300 studies, so this table can have multiple rows for a single study (e.g., Study C has 5 outcomes with data ...
I’m so sorry for the delayed reply - I have been traveling and haven’t been able to touch this for a few days. This is super helpful, and I’ve been playing around with it, but I realized that I can’t see the formulas in the columns (I tried to add a ...
Thanks so much for your reply. I want two things from these tables:
Using Table A, count the number of studies that have Outcome 1 (or 2, 3, etc.) and a “positive” finding for that outcome. For example, Study C assessed suicidality, and it found a s...
