I would like to send a link in an email that, when clicked, changes the status of a specific record. Is this possible?

I’m collecting name and email (and other data) from a form, entering it into Table A. Using a “new record” trigger on Table A, I want to create a new record in Table B using name and email, but only if a record doesn’t exist yet. Is this possible? I ...