Where the form store new value

[spadaal]

Hello I have a basic app that track miles, i have the input with date and a dropdown with building on from and to with a option to enter a new location , the question is when people enter the new location where this info is store? i have a user that miss type a location and need to change it .

 thank you 

[Ferret]

The Dropdown is an Enum field with 'auto-complete other values' checked, correct? If that is the case, the value resides only on the record it was entered. The dropdown is just showing a list of unique values that have been inputted into that field in all the other records, along with the value list you 'hard-coded' in the field's settings. 

Changing the record's building to the proper value should remove the errant value from the list after the app syncs.

https://support.google.com/appsheet/answer/10107878?hl=en&ref_topic=10102053