Can someone please explain what "AutoComplete...

AppSheet AppSheet Q&A
1

Can someone please explain what “AutoCompleteOtherValues” does exactly?

I’m using it in an ENUM column with a Suggested_Values and AllowOtherValues.

It seems to offer an additional list of cached values, but I’m not sure if this is correct and if so, what would cause the cache values to disappear.

https://help.appsheet.com/ux/dropdowns-in-forms/dropdown-from-simple-list-of-values

says:

You can enable the “AutoCompleteOtherValues” option to make it easier for the user to choose from the set of previously entered values. This option can help ensure all entries are submitted in the same way, thereby avoiding typos.

Which is a bit vague.

1 Like
2

@Simon_Robinson It looks at the previously entered values in that column and includes them in the list of options.

3

@tony Hi Tony.

But for how long?

Forever, until the next sync, until the cache is cleared…

TIA

4

@Simon_Robinson It’s generating that list of options by looking at the values in that column. So for as long as those other values are in the column.