My app tracks miles for a challenge. It imports user name and goal and alphabetizes via a query from a data sheet. There’s a third column for miles which is entered from the app by user.
Problem: how do I keep the miles with the correct user when new data is added? Currently, when a new name is added the NAME and GOAL columns are re-alphabetized. But the MILES data doesn’t stay with its owner.
Thanks for any help.