Forum Academy Marketplace Showcase Pricing Features

Update bubble database value with unique url - webhook

I would like to:

  1. Trigger an email that contains a url link behind a button
  2. if the button is clicked (and therefore the url opened) I would like to update a specific database record in bubble

i.e. the same flow as an email verification, but for other database fields. How can I do that?
Alternatively, it would be ok if the url link opened a form/button where the user could select if they want to confirm the action, which would then update the specific database record.

The user shouldn’t need to be logged in to do this in either scenario.

Thanks