Discussions

Expand all | Collapse all

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

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

    Posted 05-25-2018 18:21
    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?


  • 2.  RE: How do I direct the data coming in from a connected table to populate a related field on another?

    Posted 05-25-2018 18:27
    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.


  • 3.  RE: How do I direct the data coming in from a connected table to populate a related field on another?

    Posted 05-25-2018 19:20
    I did not know I could convert the Reference field into a formula!  Works great - thanks so much.