Hi Team, I have a collection form where I apply the filter of the ‘Get Drop Down Data From’ to be ‘Current Logged In User’ and when I trial it the dropdown field still displays ALL data instead of the current logged in user data.
To give more context, I have a collection Called ‘Divert Notices’ with the fields ‘Health Facility’, ‘Divert Info’ and 'Contact Number '. The ‘contact number’ field is where I am having the issue…it is a field of dynamic data from the ‘Contact number’ field in another collection called ‘User’ .
What I am trying to achieve is that when a logged in user adds a divert notice in the collection form the contact number in the drop down field is the contact number assigned to that user from the User collection. I dont want the user to add their contact number every time they add a new divert notice on the collection form and I dont want them to scroll through all the contact numbers in the Tenant organisation. They should only see one number and that is their own contact number
I am not sure what I am doing wrong