How to automate bringing in info from Table B to Table A based on matching records

This is probably a basic task but I’m not finding info on how to do this.
In Table A I have application info from applicants that are submitting through a form
In Table B I have info coming in from Paypal (via Zapier) of payments from applicants (their application fee)
How do I have each record in Table A reference each record in Table B, matching the records by the Email column, so that Table A automatically brings in the $ amount in Table B?

Thanks for any tips!

1 Like

i have the exact same issue

1 Like

I am also trying to do the same thing and can’t clearly see how to do this with linked records.