Can a checkbox synchronise between two tables?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
Can I create a checkbox in two related tables that updates whether it is checked in either of the two tables (synchronised). e.g., I have a job table and and report table, the job table is the parent table.
On the report table is a checkbox called "accepted", if "accepted is checked on the report table (child) I would like it to also check the "accepted" checkbox in the job table and visa versa if it is checked from the job table.
Photo of Chris

Chris

  • 22 Points
  • unsure

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
While this can be done with Actions, I suggest using formuals will be an easier setup.

You can have a summary field to count the # of reports which are completed.  The have a field on the Project called [Checkbox Status] to show as a calculated checkbox 

[# of reports completed] > 0 or [Project checkmark]=true

Then on the child record, similarly you can lookup [Checkbox Status] to the Reports table and have a formula field called [Report Status] like

[checkbox status lookup] = true or [Reports checkbox] = true