Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
7 years ago

IF formula help

I have a table called "Contacts" and it has a checkbox field called "Form".  I have a related table called "Companies" and it has a Formula Checkbox field called "Contact form".  I need help creating a formula that does the following:

If any contact (from the related company) has the "Form" field checked then mark the "Contact Form" checkbox as checked.
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    No problem

    In the relationship where 1 company has many contacts make s summary count of the # of contacts with a form checked.

    Then on the companies record make a formula checkbox field

    [# of contacts with Form checked] > 0)