I have a from with a collection (min 0 - max 3) that is filled by a lookup after user enters their username.
1. They enter username, lookup fills 1 - 2 of the collection rows.
2. User clicks on Add and fills in info.
3. User then changes the username, a new lookup runs.
4. User then changes username back to theirs, the previously added row is still there and the values are blank. And because it's a required field it shows the input is not valid error.
Question: Is there a way to delete any rows added to the collection BEFORE the lookup runs? So that no matter how many times they change the username, or how many rows were filled via lookup, or added, it will always start as if the form was new?