This isn’t something a formula can do well. You’d be better off using the Scripting Block. You can re-post with a ‘work offered’ tag if you need someone to write the code for you.

Scripting Block

This is a new Airtable feature that runs a block of code when a user clicks a button. Because it only runs when you click a button, you could either use it to go lookup a value for you, then print it to a window. Or you could have it directly change the cells in the base. Scripting blocks are more difficult to use than formulas, but they’re also a bit more powerful. If formulas are tweets or a haiku, scripting blocks are more like short stories - they’re less constrained and allow coders to describe a great deal more.

Why Formulas Aren’t Ideal Here

The big weakness of Formulas is it’s inability to split up comma separated data for long lists. In an ideal world you’d do something like what’s outlined below, but a formula would stumble on the last part as lists grows beyond a couple items.

Pets (table)

Prescriptions (linked record)
[Zimectrin Gold] [Bute] [Potomac Horse Fever]

Active Medication (lookup)
[checked] [unchecked] [checked]

Active Medication (formula)
true, false, true

Active Prescriptions (formula) <- this one is the problem
Zimectrin Gold, Potomac Horse Fever

The trouble comes in trying to split up the comma separated true/false values and match them up with prescription names. Airtable formulas don’t currently have a great vehicle to express something like “give me the 4th item in the list.”

Zollie,
Thank you! I figured out what I needed to do based on your first reply about look-up, before adding the script info. I used look-up to bring in the Active Meds column into the Pets Table.

First I realized it did just what I asked, but no real value with only displaying the check box.

Then I went to the Prescription Table and added an IF statement in a new column, to return the Name field if the Active meds column is Not Blank (has a check mark)

Then back to the PETS table and did a look-up on my Formula column, came out perfect! Now I have a column that will just show the daily meds in my Main PETs Table. I’m going to create a new view in my Pets table to just list the name of the Pets and what meds they get every day:

Considering trying to get the doses in there, but that’s for another day!

Thank you again,
Stacey

Well I couldn’t help but try on the doses!

My formula to include the dose and instructions fields
IF({Daily Meds} = BLANK(), BLANK(), CONCATENATE(Name,": “&Dosage,” “& UOM,”, “& Route,”, “& Frequency,”, “& Duration,”. “& Instructions,” "& Condition))