I have a form that keeps record of submitted requests. I also have a sign-off by administrator field that has a "work in progress" "pending" "completed" that is filled out once an administrator see the form and attempts to take an action on the request.
Anyway I want to be able to filter through requests that have been submitted that has no sign-off status because when requests are added we need a way of searching the filters for those that have been added but not signed-off. There is no option for this.
I am trying to see if I can set the field action (status) replace null return with "new" in the field after the user has submitted their request. So from null to new --- then now I should be able to filter this by selecting the "new" status that has been added by the script code. Any ideas on how to set this up?
This is what I have...I know I am way off because it is not working.
if((input.Status == null)) {
Status:ui.add("new");
}