I have a list that is being generated of a list of teams ([‘Team1, Team 2,’, etc]).
I have this list splayed out in a Repeating Group in Column B, and in Column C I have a dropdown that allows a user to be able to change the value to another Team should they wish.
a) What I would like to do is be able to update the state of the list with the new inputs, and when a user hits ‘SAVE’, it overwrites the list entry in the database, by replacing the original value in the list (as opposed to appending it).
Does anyone know how to do this? I’ve experimented with states and also creating a default order entry in the database to ‘make changes to a thing’ - but it all comes down to not being able to overwrite a specific value in a list. Any help is much appreciated!