Set fields to indicate action

I would use a (read-only) text field with red text that says something like "NOTE: This file does NOT need to be submitted" and a script to make it visible when any of those fields is set to No. If you let us know the names of those fields I could help you with the code to do that.

You can set an alert, something like this as validate script of that field:

if(event.value == "No")
app.alert("You do not need to submit this file",3);