Can you use a Quick Base Action to modify a parent record?

  • 1
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Photo of slloydavant

slloydavant

  • 80 Points 75 badge 2x thumb

Posted 8 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Are you asking if you can modify the record that triggered the Action?  Or are you saying that you are saying that a child gets modified or added and you want to modify the Parent.

Either is possible.

The "trick" is to create a Report Link field to identify the records to be edited.  When the action asks for related records to be edited in the setup, it in fact does not mean related records.  They just use those words.  They really mean "the records defined by this report link field.

So you can either modify the record you are on by setting up a Report link field to map from the [Record ID#] right back to the same App, same table and field for the [Record ID#] field or else if this were a case of needing to edit the Parent triggered by an child entry, then make a Report Link field to match [Related Parent] to Record ID# of the Parent. 
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Keep in mind, that this does not work when 'adding' a record.  Only edits.

Reason being is the [Record ID#] doesn't exist when adding, and the action is triggered, thus the circular referenced report link is 'null'.
Photo of slloydavant

slloydavant

  • 80 Points 75 badge 2x thumb
Got it, thanks.