Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to see if a record exists in another table with criteria from columns in another table?

Topic Labels: Admin Data Formulas Sync
1245 1
cancel
Showing results for 
Search instead for 
Did you mean: 
cnussbaum
4 - Data Explorer
4 - Data Explorer

I have three columns in Table A:

  • a person's name (lookup of Table B)
  • a person's role (lookup of Table C)
  • a posted message (lookup of Table D)

For some reason, my posted message column blanked out (Don't ask. I have no idea how.) So, I'd like to see if there is a way I can reconnect the lookup of Table D automatically without using an API. Or is there a way I can build another column in Table A that will return the record I need to reconnect (based on the matching criteria of name (table B) + role (table C))?

1 Reply 1

What's the primary field value of Table D?  If it's "name (table B) + role (table C)", you could try creating a formula field that outputs that text and pasting that value into a linked field to Table D?

Could you provide some screenshots of the relevant tables?