You can use our View Read-Only Airtable Field automation for this! Here's how:
Select the table and field you want to display
Copy and paste the Formula to a new formula or button field in Airtable.
Clicking the link generated by the formula, or the generated button, will now open the field with the value from that record. You can share these links with anybody, e.g. via email.