I have a data set with a few fields (Monday, Tuesday, Wednesday) that have entries in each. Now when I connect the dropdown to show me a list of any of the fields, it is easy, just go and choose one of these options to show its entries in a list.
However, is there a way in which I do not connect it to the field directly, and instead it connects to either of the fields depending on anything else? Say today's day? For example, if today is Tuesday, it connects to Tuesday and shows its entries, if Wednesday, it connects to Wednesday and shows its entries. Not just fixed on Monday. Any help?