I am new to Zoho creator, and am hitting a wall with my know how, and was wondering if someone might be able to help me.  

I have a form called Graphics which has a LOOKUP FIELD called Scene in a Form also called Scene.  In the view called 'Graphics_Worklist_Shooting_Order" that I show this lookup field, I have it display a RELATED field, called DATE from the Form Scene.

What I am trying to do is set a criteria on Graphics_Worklist_Shooting_Order where I only show dates from today into the future.  Meaning if a date has passed, the record is not displayed.  

Additionally, I would like to have a Conditional formatting where if the date is null, then the view will list it as UNSCHEDULED.  

I hope that I have provided enough information, and that I have explained myself clearly.  

Thanks in advance.