At Boston Scientific, we are adding a customization to the validation of the importable spreadsheet to hook into business rules that are currently checked upon Create and Edit.
Example rules include:
Number field shall only allow the following special character: dash & underscore (_).
Namefield shall only allow these symbols: Hyphen , Comma (,), Underline (_), Left parenthesis ((), Right parenthesis ()), Plus sign (+), Forward slash mark (/), Pound sign (#), Period (.), Dollar sign ($), Exclamation mark (!), Asterisk (*), Single quote ('), Space ( ).
The Quantity field is required when the value of the Usage field is Primary or Alternate.
The Find Number field is required when the value of the Usage field is Primary or Alternate
Temperature or Handling Condition field - "Blank" is not a valid value