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

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
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.
Photo of abhi reddy

abhi reddy

  • 200 Points 100 badge 2x thumb
  • confused

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,308 Points 50k badge 2x thumb
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.