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 thought I could do it with the “find record” action, but there doesn’t seem to be a way to specify a following action if nothing is found.
However, depending on what you’re trying to accomplish, you might be able to create a link to your 2nd table from the 1st table (for example, using the email address as the primary column in the 2nd table), and then simply use an automation to “copy and paste” the email address from the original field in the 1st table to the linked record field in the 1st table. That would have the effect of either linking to the existing record in the 2nd table, or creating a new record in the 2nd table if it doesn’t already exist.