When I use a lookup table to reference an e-mail address, url, or phone number in another table, I would like those fields to act as active e-mail addresses, urls & phone numbers when they are displayed in the lookup table. Currently the lookup table formats them as text, so if I want to e-mail a group of people from a particular set of lookup fields, I have to hand copy all of the e-mail addresses. Or, if I want to text someone from a particular lookup field, I have to hand copy the phone number.
What happens if you create a new formula field which just displays the desired lookup field text? This may offer some formatting options or might recognize the specific format.
Formulas won’t recognize emails as emails (clickable action items). Also, Its really inconvenient for users to have to use a separate formula field for what could be many lookup fields.
Ideally, Lookups should either recognize formatting of displayed values, inherit the formatting of the original field from the linked table, or have their own formatting options to let users specify whether displayed values should be clickable emails, phone numbers, urls, etc.
YES. EXACTLY. PLEASE. I’m stumbling across this issue yet again and it’s making me nuts. I use AirTable to manage contacts across multiple projects. So I have a master table of names/phone numbers and then link those names to various project tables. So if I’m on my phone and I’m trying to call or e-mail someone working on a project, there’s no active link to call them from the project table. I have to either navigate back to the contact table or copy and paste their phone/e-mail address. Also: the various blocks which interact with e-mail addresses, urls, etc DO NOT WORK on the lookup fields. So if I need to e-mail or SMS everyone on my project team, I can’t use the pro-feature block (which AirTable is charging me for) to do it.