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.
