Solved

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

Posted on 2004-08-03
6
214 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

772 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