Forum Discussion

Qrew Member

2 years ago

Table Relationships and Checkboxes

Hello everyone! I was hoping that someone here could help me figure something out with my latest Quickbase App involving Table Relationships and Checkboxes. Thank you in advance! I hav...

MarkShnier__You

Qrew Legend

Stu, you have described your tables, but I'm not understanding what your specific question is.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

StuLamden1

Qrew Member

2 years ago

Mark,

Thank you for responding and my apologies for being unclear.

What I'm trying to accomplish is that each time I create a new record in the Employees Table and select the Asus USB Monitor checkbox and save, I want it to add a value of 1 to x for the Asus USB Monitor record in the Inventory Table.

If I create three records in the Employees Table and select the Asus USB Monitor checkbox and save, I want there to be a value of 3 in the x field associated with the Asus USB Monitor record in the Inventory Table.

If I uncheck the Asus USB Monitor checkbox in the Employees Table for one of the records I've previously saved, I want the Inventory Table to update so that the value is now 2 in the x field associated with the Asus USB Monitor record in the Inventory Table.

Thank you,

Stu

MarkShnier__You
Qrew Legend
2 years ago
OK. One Equipment has Many Employees.

I think all you need to do is to create a summary field on that Relationship to count the # of Employees with a filter to only include where Asus USB Monitor checkbox is checked.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- StuLamden1
  Qrew Member
  2 years ago
  Mark,
  
  Thank you for your response. I tried your suggestion, but I'm still running into an issue. The attached pdf provides a bit more detail if you don't mind taking a look.
  
  Stu
  
  ------------------------------
  Stu Lamden
  ------------------------------
  Community Help.pdf255 KB
  - MarkShnier__You
    Qrew Legend
    2 years ago
    Thx for the PDF.
    Can you try just totalling that ASUS USB Monitor qty field without the extra filter on that checkbox and let me know what happens?
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------