Forum Discussion

abhireddy's avatar
abhireddy
Qrew Trainee
7 years ago

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

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.
App builders
Ask about Quickbase functionality
NotificationsEmail
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.