Map Data
- Robert Avery
Validate the document, enter request parameters, and refresh mapped data
VALIDATION
The validation function is used to analyze a cell or cell range to see if the data meets specified criteria. After clicking on the validation button, shown as an exclamation point inside a red triangle, a pop-up screen will appear, in which you may input the validation criteria, including the allowed values, error title, error text, info title, info text. After inputting the criteria, click on the apply validation button at the bottom of the screen.
ENTER REQUEST PARAMETERS
When you select the Enter Request Parameters button, a screen will appear stating the parameter values requested by the server.
SET CONDITION AND FORMAT
This function allows you to apply format changes to cells meeting specified data types. The format options include borders, border colors, background colors, typeface colors, strike outs, and alignments. The screen will include example text featuring the format alterations. For example, you could have a red background applied to cells with negative integers.