Skip to main content

How do I Group the multi-select field or the Linked filed to where it will show only one option vs Grouping the 2 or 3 I have in the original record?



I am tracking my Daughters Daily Symptoms, mood, meds, etc.



Here I am grouping the Symptoms. How do I only show the 1 Symptom vs showing all 3 from that day? Maybe I have this setup wrong for what I’m trying to do.





Any thoughts?



Thank you!

Hi Hanna!



I would use an auxiliary table, what has extra advantages: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships. Then you could Group in that extra table by the singular Symptom.



You could also extract the first Symptom with a Formula field and something like this: Split First and Last Names



Hope that helps 🤷


Hi Hanna!



I would use an auxiliary table, what has extra advantages: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships. Then you could Group in that extra table by the singular Symptom.



You could also extract the first Symptom with a Formula field and something like this: Split First and Last Names



Hope that helps 🤷


Thanks Elias for commenting! I created the Symptoms as Linked Records and created a table for it. I guess then just grouping by name. That’s a lot of tables to look at to Group what I’m wanting, but I believe that’s what I want.



I’ll have to read more about the Formula field and extracting the Symptom.



Thanks again for the help! 🙂


Reply