Quick Base Discussions

Expand all | Collapse all

Populating data based on conditional relationship from two different applications in another table

  • 1.  Populating data based on conditional relationship from two different applications in another table

    Posted 06-11-2018 19:25
    I have two different applications in which one application has a form with data picker fields.

    Ex: Application A has two different set of tables in one table i have customer information aligned to  FID,and in another table I have issues aligned to FID(In both the applications FID is common). But in Application B's data picker form customer data & issues data should get populated by selecting FID once.

    How Can I create a condition where user selects an FID in B's form then data from A's tables should get populated.

    Can anyone help me to figure this out.

    Thank you,
    Abhi.


  • 2.  RE: Populating data based on conditional relationship from two different applications in another table

    Posted 06-11-2018 19:31
    Have you tried  a form rule

    when Multiple conditions are true
    when [Related Customer 1] not  (blank)
    when [Related Customer 2] is  (blank)

    Change [Related Customer 2 to the value in the field [Related Customer 1]

    and uncheck the checkbox at the bottom to make it fire all the time.