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 rec...
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!