In a view : hiding some records according to the value of a field

An easy one... at least, I guess!

Is there any way to hide some records (not a column, but records) according to the value of a field?


I've got the field "TheStatus" in a form, and if the value is "Not Yet Assigned", then I don't want to see those records.  But I want to see all the others.
Who is Participating?
HappyFunBallConnect With a Mentor Commented:
Ok, yes

Change the formula to this:

SELECT Form = "MyForm" & TheStatus != "Not Yet Assigned"
You just need to set your selection formula for the view to show only the documents you want.

The formula would be this in your example:

TheStatus != "Not Yet Assigned"
barbotteAuthor Commented:

Just under the line
SELECT Form = "MyForm";
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

barbotteAuthor Commented:
Thank you for the fast answers!
On the dot HFB. BUt, I would add something. THis would be better when combined with the Form slection formula (Otherwise barbotte will have to post another question) ;)

SELECT FORM = "Form_Name" & TheStatus != "Not Yet Assigned"

Oops! Sorry. I left this open while commenting in the other thread. All well :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.