Hello,

I have created a check Request form in my system.  For some of our transactions we will deal with multiple transactions but I only want to have one button.  I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to create a nested if Statement (or open to other options) to fill the check Request field with the newest fee.  For example If Fee 5 is empty but Fee 4 is not then I want Fee 4 populated in the field.  If Fee 5, 4, and 3 are empty then I want Fee 2 to populate in the field.  And so on.  Appreciate any direction.

So far I created a nested if Statement but it only works for the first field then no longer works.