So I have a little project Im working on currently, Currently im using the Zendesk Beta and im trying to utilize the “Assignee” which is email addresses. I want to have a formula that can replace the email address that’s in the assignee to another table that has my employees names (also includes their email) so I can have a formula that replaces the data with that name instead of an email (I know you cant edit Sync Sources thought this would be best bet type of solution). Any help would be awesome im fairly new to AirTable still learning some of its tricks and features.
you can try adding a Link field connected to your Table 2, then use an Automation triggered when an email address in the Sync Table changes and set it to Find Records in Table 2 that match the email field in your Synced Table. Then use the resulting list of matching record ids to link the corresponding employees with an Update Record step.