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.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Formula to determine which checkbox is checked and return text value
Archive User
09-19-2017 19:08
I thought this would be simple, but I have failed. I am looking for a way to determine which of 20 ...
QuickBaseCoach Dev./Training
09-19-2017 19:13
Try this List(",", IF([Checkbox 1],"Checkbox 1", IF([Checkbox 2],"Checkbox 2", IF([Checkbox 3],"Checkbox ...
Archive User
09-19-2017 19:38
That was the ticket. Cheers!
1.
Formula to determine which checkbox is checked and return text value
0
Like
Archive User
Posted 09-19-2017 19:08
Reply
Reply Privately
Options Dropdown
I thought this would be simple, but I have failed.
I am looking for a way to determine which of 20 formula-check boxes is checked and return a text value based on which box is true. This is to find what current task a project is in. I have tried the IF/& statement but it would throw errors or the output was incorrect. I looked at the API_DoQuery, but not sure how to make it perform the task I want (lack of API knowledge).
Any thoughts for the community.
2.
RE: Formula to determine which checkbox is checked and return text value
0
Like
QuickBaseCoach Dev./Training
Posted 09-19-2017 19:13
Reply
Reply Privately
Options Dropdown
Try this
List(",",
IF([Checkbox 1],"Checkbox 1",
IF([Checkbox 2],"Checkbox 2",
IF([Checkbox 3],"Checkbox 3",
..
IF([Checkbox 20],"Checkbox 20")
3.
RE: Formula to determine which checkbox is checked and return text value
0
Like
Archive User
Posted 09-19-2017 19:38
Reply
Reply Privately
Options Dropdown
That was the ticket.
Cheers!
×
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