...
Before creating a View, open a record from that tab. For example, if creating a View under Flight Legs, open a Flight Leg to use as a reference and identify what fields are required to use as a filter
Navigate to the Tab and click Create New View (screenshot 1)
Name the List View (screenshot 2)
| Expand | ||
|---|---|---|
| ||
 
|
Step 2: Specify Filter Criteria
...
Apply the appropriate Filters to the View. The best way to start is to think of what information you do not want to see (screenshot 4)
E.G. Flight Legs that are currently in the Planning stage or those that are Cancelled. So the below filter is applied: Leg Status not = Planning or Cancelled (screenshot 4. 1)
Next, filter out the information required (screenshot 4. 2 - 4. 3)
E.G. All Flight Legs Dispatch by ExecuJet UK Ltd. Company X Flight Legs that take off in the next 7 days. The screenshot below shows how to apply these filters:
Note: For a list of all relative Date Values that can be applied to Views & Reports please click here:
https://help.salesforce.com/HTViewHelpDoc?id=custom_dates.htm&language=en_US
Finally, in this example, we want to see those Flight Legs that do not have a PIC OR SIC OR Cabin assigned to them. The screenshot below demonstrates this. The Blank Value shows that we want to see results where the PIC, SIC or Cabin 1 name = Blank (screenshot 3. 4)
In order to show OR logic, change the filter logic to look like the below. OR Statements must always be defined using ( and ). If your View has only AND statements, then you don't need to use the filter logic at all (screenshot 4. 5)
| Expand | ||
|---|---|---|
| ||
  |
Step 3: Select fields to Display
Select the Fields you want to be displayed on the report (screenshot 5)
| Expand | ||
|---|---|---|
| ||
  |
Step 4: Restrict Visibility
...
Click Save
| Expand | ||
|---|---|---|
| ||
  |