I have a FILTERS view/table that allows the user to select what’s offered from an ENUMLIST.
Until now, I have hardcoded the ENUMLIST. This worked well.
I prefer to have the ENUMLIST be dynamic, based on values in L_groups_offering for a selected L_group.
My latest attempt is…
F_section > Auto compute > suggested values:
Please use a de-reference formula to grab the value you want:
[F_group].[L_group_offering]
It should be that simple; if not, then something is missing - an additional reference connection is necessary.
If you’ve got a reference connection between here and there - there being where that list you want lives - you can de-reference that column through your reference connection.
Maybe that list isn’t directly connected, but it’s one or more steps away; in these instances you can use chaining dereferences to get your value
[F_group].[FG_Location_Ref].[L_group_offerings]
Provided that the column you’re pulling is a list/enumlist, and you’re pulling that into a list/enumlist column - apples to apples - it should work without needing any transformation or anything.
I think I just “got” references. Inspired by your post I persisted and I managed to replace a very complicated set of formula with clean and simple . references!