Hi all, I would like to create a dropdown li...

(Faustin Ngassa) #1

Hi all,

I would like to create a dropdown list of names that is pre-populated with names from a worksheet table column Staff[fullName] but also allows Other Values with the option to AutoComplete. Those other values should not be saved in the Staff table.

Is that possible? I tried the Enum with Valid_if but for obvious reasons, I only get the list of rows from Staff table with no option to add other values

Thanks!

(Aleksi Alkio) #2

Unfortunately that option is not available. The closest option is the ref field, but it will save those values into the table. What is the reason you don’t want to do that? Would it be possible to save these new values with a variable so you would know if the value is original or not.

(Faustin Ngassa) #3

I have a list of regular customers that are in the database and one off walk-ins.

For the one off walk-ins, I just need to enter the name for that one transaction.

(Aleksi Alkio) #4

Then you would need to arrange two different fields. One for regular customers and an additional “Walk-Ins” field.