Thanks. I’m aware of automations but not what i need in this case. Was hoping there was some way in which to extract the email address. I can get the email address in PowerBI via the Airtable API, it’s a part of the user item (name, id, email address). Would have thought you could get it via a formula in AT as well.
Formula cannot directly extract the email address from a collaborator field. If you know all the names of the collaborators and their email addresses in advance, you can hardcode them into a formula to make the conversion. However, if the user changes names or email addresses, the formula will no longer work. If you add a new user that the formula doesn’t know about, the formula won’t show it.
What do you need the email addresses for?
If this is a one-time extraction, you could use scripting to get the email addresses.