How do I direct the data coming in from a connected table to populate a related field on another?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I auto populate a table in the first application (Table 1) with data from a second application using QuickBase Connection.  I also have another table (Table 2) in the first application that is related to Table 1.  I need one of the fields that is being auto-populated to go into the related table instead of it's own field so the relationship is established.  Any suggestions?
Photo of Scott

Scott

  • 238 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
One option is to make the relationship in the new app a formula reference field.  Then just reference the value that is coming from the sync table to drive the relationship.

This is assuming both table 1 & 2 are mirrors of the original.

If not, you might have to look at the key fields in the corresponding tables.
Photo of Scott

Scott

  • 238 Points 100 badge 2x thumb
I did not know I could convert the Reference field into a formula!  Works great - thanks so much.