_Astrid_
asked on
Display results of a checkbox set
I'm pretty new to FM and I am having trouble finding a clear way to display the results that I need. I have a table that has a field using checkboxes.
I need to be able to sort my results based on just one of the checkbox values selected. What's the best way to set this up? It seems fairly straight-forward but I haven't been able to find a solution that I can make work. Thank you so much for any help!
I need to be able to sort my results based on just one of the checkbox values selected. What's the best way to set this up? It seems fairly straight-forward but I haven't been able to find a solution that I can make work. Thank you so much for any help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are only searching for one checkbox value, you can just go into Find Mode, check the checkbox for the value you want to locate and then click Perform Find. Only records with that value checked will be returned. But perhaps I'm not following you...
This could also be scripted to perform the Find and then sort the results by whatever criteria you wish to see but that's probably a separate question, especially if you're new to scripting.
This could also be scripted to perform the Find and then sort the results by whatever criteria you wish to see but that's probably a separate question, especially if you're new to scripting.
ASKER
Thanks again, Will. I will go ahead and post a separate question regarding the scripting to automate the Find for the results I'm looking for.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for _Astrid_'s comment #a40711691
for the following reason:
Very helpful and excellent response time! Thank you!
Accepted answer: 0 points for _Astrid_'s comment #a40711691
for the following reason:
Very helpful and excellent response time! Thank you!
ASKER
Is it possible to hide or not include the records that do not have the specific value I am sorting for? Basically, I have a contact in one table with a set of checkboxes that are checked through different phases of analysis of the contact. I need to be able to sort based on one of those phases that are checked off and I'd like to return only records showing that particular phase.
Perhaps checkboxes are not the best option to handle that kind of search?