I’m creating an App which will have a ‘status page’ which will show things like ‘Current Shift Manager’.
I have the following collections set up:
Team Members
Today Status
So, on the screen where the Current Shift Manager is chosen, I have added a Dropdown field. I have this set to show menu options from Team Members collection.
I want default visible option when the screen loads to show the currently selected Current Shift Manager from the Today Status. However I’ve been unable to get it to show this unless I change the menu options to show from the Today Status, which then doesn’t give me the list of team members to select from.
I’m struggling somehow to get the functionality to work as there aren’t any options showing available in the default value.
Any pointers? 