Re: Trying to make the Current User the default in a field that uses a Standard Record Picker
Forrest has an interesting solution but to launch the Add Purchase Order with a formula field you would need to have the users go to a table, say a single record table which has this formula field, so that is an extra click.
An alternative is to set up a Sync table and Sync across a copy of your employee file to another table in the app, filtered on where userid is not blank. Set the Key field of the Sync table to be the userid.
Then on the Purchase orders table make a field called [Current User] with a formula of
User()
and make a relationship back to Employees Sync, and and lookup the badge # of the current user.
Then set a form rule that when the bade # is blank, change the badge # to that lookup, and uncheck the checkbox so it fires all the time.
An alternative is to set up a Sync table and Sync across a copy of your employee file to another table in the app, filtered on where userid is not blank. Set the Key field of the Sync table to be the userid.
Then on the Purchase orders table make a field called [Current User] with a formula of
User()
and make a relationship back to Employees Sync, and and lookup the badge # of the current user.
Then set a form rule that when the bade # is blank, change the badge # to that lookup, and uncheck the checkbox so it fires all the time.
