Filtering, Grouping, and Sorting the CMIP7 Data Request | Scribe

Filtering, Grouping, and Sorting the CMIP7 Data Request

  • CMIP IPO |
  • 25 steps |
  • 2 minutes
  • AirtableAirtable
1
Navigate to <https://bit.ly/CMIP7-DReq-v1_1>

Filtering

2
To apply one or more filters to a table, click the 'Filter' button.
3
Click 'Add condition'
4
Choose which field you would like to apply the filter on
5
Here we have selected 'Lead theme'
6
Choose which type of logic you would like to apply
7
Here we have selected "has any of..."
8
Choose your condition to filter on. Here we need to select which lead theme(s) we want to filter the data by.
9
We have chosen to filter for Opportunities for which the review has been led by the Atmosphere theme.
10
Click anywhere on the screen to close the filter pop-up. You will now see only Opportunities which being led by the Atmosphere Author Team. These themes likely have a strong Atmospheric Science focus. Alternatively, they could be a cross-thematic Opportunity, such as the Rapid Evaluation Framework Opportunity.
information ordinal icon
Fields which have a filter condition applied to them will appear shaded in light green.
11
You might want to add additional filters. To do this, click the filter button again. As we already have a filter applied, the button will now be green.
12
We could add a conditional group for more complex logic. To do this click the 'Add condition group' option.
13
Click the '+' in the grey box which will appear.
14
We will now add the additional logic that as well as having 'Atmosphere' as the lead theme, the Opportunities must have **either** a data volume under 10 **or** have requested the Experiment Groups DECK **and** scenarios.**
15
16
To remove any filters, click on the green filter button
17
Click the trash can icon next to the condition you want to remove.

Grouping