Pull Data from employee data table based on current user

This is not an exact implementation plan, but an idea:

Imagine you have an [email] field.

Each employee logged into Quickbase has the same email as their employee info in the table with the [email] field matching.

Then you can use something like this formula in a formula - checkbox:

[Email] = UserToEmail(User())

To check if the match is there. If true, then set your field XYZ to equal the other record's XYZ.

Possibly you can use lookup fields or formulas to prepopulate the fields automatically or using form rules.