Click tracking on external URL links

I am using simple URL field as a result in List Block. I would love to update AirTable with record each time an item is clicked and also need the user’s browser to continue to the external link in a new window. This way I could quickly pull a report of all urls clicked and filter accordingly in AirTable.

Could I use a variant of this or is there a simpler way ? Redirect to external links after record update through action button - #9 by matthieu_chateau

I assume I could pass the external URL to a webhook and use Make or Zapier to update a table and then redirect the browser - but I would prefer not to add more potential points of failure if possible.