How to get a field value based on the current user?
I hope all is well,
I want to get a field value of the column called "EmloyeeN" from a table called "leave request" of the current user where the "EmployeeNO" field type is lookup on the table "Employees" in order to place the result in a dropdown Datacard automatically on login (the Datacard DisplayMode will be view only)
Did you put the formula in Default property of the Dropdown? If it is a Combo box, you need to set it in DefaultSelectedItems property as Default property only accepts single record while Filter function will return a table.
What exactly would you like to display in the Dropdown? There should be multiple records belong to a specific user in the Leave request table, unless you will only need to show the latest request of the user?
Community Support Team _ Jeffer Ni If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.