Hi everyone - maybe this is simple and I am just not getting it, but I could use a little advice.
Table 1 - has name/email address/other data related to user engagement in a learning platform
Table 2 - Workday pull that shows their business unit, ID, location, etc
What I am looking to do is take data from Table 2 and link it to a user in Table 1 so it shows their engagement with the platform as well as their business unit information so I can then filter and look at which business unit is the most engaged.
Both tables have an email field, so I figured that would be the easiest to match, but for the life of me I cannot get it to match up. Can AirTable auto-match across sheets and load up the data, or do I have to pull the record manually by doing a Link on the email field, typing in each persons email address, and a lookup on the other fields?
Thanks in advance for any help.