Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
IF formula help
Mark Comish
09-06-2018 19:02
I have a table called "Contacts" and it has a checkbox field called "Form". I have a related table called ...
QuickBaseCoach Dev./Training
09-06-2018 19:12
No problem In the relationship where 1 company has many contacts make s summary count of the # of ...
Mark Comish
09-06-2018 19:27
Perfect! Thank you!
1.
IF formula help
1
Like
Mark Comish
Posted 09-06-2018 19:02
Reply
Reply Privately
Options Dropdown
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.
2.
RE: IF formula help
0
Like
QuickBaseCoach Dev./Training
Posted 09-06-2018 19:12
Reply
Reply Privately
Options Dropdown
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)
3.
RE: IF formula help
0
Like
Mark Comish
Posted 09-06-2018 19:27
Reply
Reply Privately
Options Dropdown
Perfect! Thank you!
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic