Skip to main content

Need AT to convert "Last Modified By" field to an email address

  • September 7, 2022
  • 3 replies
  • 42 views

I have an automation that will email a specific person when a record enters a view. The view is looking for a status change. Once the status has been changed a field is populated with the user that changed the status. As part of my automation, I’d like the person who changed the status to be CC’d on the email that will be sent.

How do I get the email of the AirTable user to auto-populate into an email field?

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 7, 2022

Welcome to the community, @Linda_Harring!

Amazingly, the email address is already embedded into that field! In your automation, just click on that field and choose “Display As Email”.


  • Author
  • New Participant
  • September 7, 2022

Welcome to the community, @Linda_Harring!

Amazingly, the email address is already embedded into that field! In your automation, just click on that field and choose “Display As Email”.


Thank you so very much! If it was a snake…


Forum|alt.badge.img+3
  • New Participant
  • July 14, 2023

Not sure whether Airtable has been updated since this solution was posted, but I don't see a "Display As Email" option when I click the field. I'm using a "Last Modified By" field to get the person who made the change, and when I select that field and "Email" in the automation & try to test, it says the To field is blank. Help!