Solved

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

Posted on 2004-08-03
6
212 Views
Last Modified: 2013-12-18
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?

Example:

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.
0
Comment
Question by:barbotte
  • 2
  • 2
  • 2
6 Comments
 
LVL 9

Expert Comment

by:HappyFunBall
ID: 11706821
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"
0
 

Author Comment

by:barbotte
ID: 11706917
???

Just under the line
SELECT Form = "MyForm";
0
 
LVL 9

Accepted Solution

by:
HappyFunBall earned 50 total points
ID: 11706927
Ok, yes

Change the formula to this:

SELECT Form = "MyForm" & TheStatus != "Not Yet Assigned"
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:barbotte
ID: 11706973
Thank you for the fast answers!
0
 
LVL 19

Expert Comment

by:RanjeetRain
ID: 11706995
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"

0
 
LVL 19

Expert Comment

by:RanjeetRain
ID: 11707015
Oops! Sorry. I left this open while commenting in the other thread. All well :)
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now