I have 2 tables that are divided into 2:
1. A table of all the leads.
2. A table of people who paid.
I want to create a column that will check in table 1 whether a certain email of a record appears in table 2 and if so - to add a V in this column.
How can this be done?
I tried the option of linking but it only connects the leads for me and doesn't do a check on all of them.
Thank you. Attach photos.