I have a form that is being completed by dept personnel for each employee. The form displays employee name and current disaster role. They have the ability to request a role change and then select the dept review status (approved no changes, revision requested, employee terminated)…
All records that are marked “revision requested” hit a report and sliced view that we use to review and make changes.
However, it seems some records had requested changes but the wrong dept status option was selected and we missed those changes.
The dept review status is a dropdown. Is there a way to set a valid if statement for this field? If the requested change field is not blank I don’t want them to be able to select anything but revision requested.
Or is this better handled through a workflow where I change the status if the field is not blank?
I’d rather have it done before the form is saved but would like some advice. Thanks