Skip to main content

Grouping by Linked Record - Show Group with no record

  • January 16, 2023
  • 1 reply
  • 15 views

Forum|alt.badge.img

I have a table with a linked record.  I am grouping by the link record, however the show group with no record toggle that shows up for single select is not there.

Is there a way to show all groups even without records?

1 reply

Forum|alt.badge.img+15
  • Inspiring
  • 51 replies
  • January 16, 2023

Hey! One workaround is to copy your linked records to a Single Select field through an automation and then group by the Single Select field.

Another is to link your unassigned records to an "Unassigned" shell record just for grouping purposes. You could have all new records assigned to this automatically with an automation as well.

Both of these workarounds assume only one record can be linked at a time.