Status change between related tables

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I have 3 tables A->B->C. I need the status field change of C to change the status field of B. 
Note: B and C have different status values that cannot change.
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb

Posted 11 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
Can you clarify which are the parents and which are the children.
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
B = parent C = Child
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
Well, you have two choices, I suppose.  The first is to do summary field of the # of children at various statuses and then use that in a formula to calculate the status of B.

But if you want a change done based on a change to "C", you can create an Actin to edit records.  But to do that you will need to set up a Report Link field on C which links one the Left side of the setup [Related B] to the field on B of [Record ID#].

Then you can set up an Action.
(Edited)
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
Thanks for the reply. I've tried both and neither seems to fire the change. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
So let's talk troubleshoot the Action.  Did you create the report link field?  If you put the Report link field on the C record, does it show a report of the single B to be updated?
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
I created the report link but it does not show the B record to be updated
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
How is the report link field configured - what field is on the left and what field is on the right?
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
C is on the left B on the right
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
May I have the names of the actual fields?
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
The record that you want to update in Sell sheets (B) is the Parent of (C).  The Parent of C will be [Related sell sheet], so that is the field that you need on the left side.  The right side is the record that you want that to match to which will be the [Record ID] field in Sell sheets.

So maker that adjustment and see if the Parent sell sheet record shows on the report link field on C.
Photo of Chad Brandmire

Chad Brandmire

  • 968 Points 500 badge 2x thumb
Sorry for the delayed response. 
Made the change and all appears to be working.
Thanks