Simplest Solution for Child Record Checkbox?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have the following tables:

Users < Machines

A field in the machine record is manually checked when a machine is getting replaced.

I want a User field to show a check if one of their machines is getting replaced.

The solution I thought of is to create two fields in the User's table:

  • summary field that totals # of machines checked for replacement
  • a formula checkbox that is checked of the above summary field has a value greater than one

Or is there a simpler solution?

Thank you!

Photo of Amber

Amber

  • 590 Points 500 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,548 Points 50k badge 2x thumb
That is indeed the simplest solution.
The checkbox field would be checked if the # of Machines being replaced is > 0