Hi everyone,
Need some assistance please! I was able to find this discussion and it's definitely close to what I'm looking for, but I need to close a few gaps.
https://answers.laserfiche.com/questions/70305/For-Each-Row-Not-Completing-First-Iteration
- Have a field with multiple account numbers
- Have a custom query that doesn't appear to be written correctly to check all account numbers OR they forgot to include the "each row" piece to make sure everything was evaluated.
- Need to confirm that each account number entered is a valid account number
- If it's not, I would "like" to add a text box/post it note/highlight the field with the error. They can enter up to 50 account numbers and it would be horrible to figure out which one was wrong with nothing to reference.
SQL is not my strongest suit, but pictures are really helpful for me:-) I've attached the current query and "think" I'm going to need to do a Repeat or For each Row activity to ensure that all account numbers are checked before moving on in the workflow.
Any help is appreciated.
Thanks!
Toyia