Script to check whether fields have values, and then add field name to custom dialog
I'm trying to write a script that will act as a final check before moving our data to the next stage in the process. I want it to check several fields on one table to make sure that they all have data in them, and if one or several do not have the required info, to put the name of those fields in a custom dialog box. So far I have used IF functions and the custom message box, so the box appears when there is a field that is blank, and the box reads:
"The following required field is missing data. Please fill in data before starting order. "
But I want it to show which fields are blank below that. Is there a way to do this? Which scripts and/or calculations should I use?