We will assume that the pop-up menu field is named Globals::SearchStatus and the text field is named Globals::SearchText. Identifies the target field (National Statistics or World Statistics) based on geographical location, then enters a calculated value (the sum of all Grand Totals) in the target field. The screen shot at the beginning of this article shows a portal of tasks with dynamic filter criteria to filter results by project status (a popup menu with fixed values) and an open text field which searches multiple fields. These functions and record-level validation are performed after the record has been exited or committed. See the details of each of these steps below as well as some alternative methods and enhancements.
Scripts that use a series of Set Field By Name script steps should group these steps together if possible, so that subsequent Set Field By Name script steps can act on the record without having to lock the record, download and upload data, index the field, and so on, after each individual Set Field By Name script step. Create a filter button, Show Selected, that either goes to related records based on a relationship built with the global field, or run a find script that loops through the IDs in the global field and finds each record. Or a single related table for each array type with just the relation based on the initial key value.