The Dynamic Redirect URL using Airtable automation lets you generate a link that always stays the same while controlling the destination URL from a field in Airtable. This makes it easy to update or change where users are redirected without sharing new links.
You can also add a lookup page to this automation to first have users find the appropriate record based on fields you define. Once the record is looked up, the redirect to the URL stored within that record takes place.