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.

How to Group Multi-Select or Linked Record differently?

5499 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Hannah_Wiginton
10 - Mercury
10 - Mercury

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.

image

Any thoughts?

Thank you!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
2 Replies 2

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-relation.... 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! :slightly_smiling_face:

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable