Quick Base Action: Edit Related Records is disabled

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Given two tables with a parent-table relationship, I'd like to create an action that updates a parent field when a child record changes.  I tried to use a QB Action for this, but the "edit related records" option is disabled.  How does one enable it?
Photo of Test Account

Test Account

  • 180 Points 100 badge 2x thumb
  • ANNOYED

Posted 2 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
One option is to use an Automation.

The second option is to create a areport Link field on your child table to match

Related parent on the left

With the Record ID If the parent on the right.

Once you have a report link field the edit related record will not be greed out.
Photo of Test Account

Test Account

  • 180 Points 100 badge 2x thumb
HHhmmm....interesting...
I created a report link and used an automation to update a parent field...it seems to work for adding/modifying a child record...but fails when deleting a child record...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I'm not sure without doing a bunch of testing myself.  You could try an Automation.
Photo of Test Account

Test Account

  • 180 Points 100 badge 2x thumb
Ah...figured out the "issue" with deletion...the date formatting granularity limits the GUI to minutes -- running a query to view the data in date epoch format shows the deletion is working....thanks!