Formula or tool to access common field information between two tables.
I cannot figure out how to make relationships or formulae to solve my present dilemma. It feels like there must be an obvious solution. Any ideas are appreciated.
If my table A has a an email address field
And my table B is synced with GMAIL to show me the connected emails with fields of TO, FROM, BODY....
Is there a formula I could use to show me if the FROM field in Table B matched one of the email addresses in Table A, and then if so, link it to that client?
I would be grateful for any matching tips.
I can build relationships, but this just gives me a drop down field so I can select from our hundreds of email addresses. I would like something that would match the fields.
THANKS!
If my table A has a an email address field
And my table B is synced with GMAIL to show me the connected emails with fields of TO, FROM, BODY....
Is there a formula I could use to show me if the FROM field in Table B matched one of the email addresses in Table A, and then if so, link it to that client?
I would be grateful for any matching tips.
I can build relationships, but this just gives me a drop down field so I can select from our hundreds of email addresses. I would like something that would match the fields.
THANKS!
