Word Order System: Close Order only if 2 conditions are met.

Word Order System: Close Order only if 2 conditions are met.

I created a basic Work Order system which I use to keep track of my projects. The WO system has a STATUS field which allows me to set the status of each project to any of the following:

o In Progress
o Awaits Approval
o On Hold
o Needs Invoice
o Invoiced
o Closed

It also has another field called "CAPTIONS NEEDED?" which I use to remind myself of this additional service which *must* be done for every project. The options for this field are:

o No Captions Needed
o Yes
o Done

I need to add functionality to this WO System so that if I change the STATUS field to "Closed" it will allow me to submit the form only if the CAPTIONS field is set to "Done" or "No Captions Needed". If it's set to "Yes", it should not allow me to submit.

Is this Possible?

Kindly, keep in mind that I'm a beginner to Zoho Creator so please be clear.

Thanks much!