Forum Discussion

TestAccount's avatar
TestAccount
Qrew Trainee
7 years ago

Quick Base Action: Edit Related Records is disabled

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?
Relationships
Tables and fields
Tips and tricks
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.
    • TestAccount's avatar
      TestAccount
      Qrew Trainee
      7 years ago
      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...
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I'm not sure without doing a bunch of testing myself.  You could try an Automation.
    • TestAccount's avatar
      TestAccount
      Qrew Trainee
      7 years ago
      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!