I’m looking for a way to allow a list to be available in my form to facilitate its filling. In more details, the experience I would like to provide is:
User can start entering a text, a list of possible values appears below, filtered by the first letters written
If one of the values is convenient to the user, he can click on it to select it
The list of possible values will be defined by previous values already entered in the database
If no values match the text written, then the text can be validated as it is and will be added to the database
There’s no native component that does this. You might want to try:
Adding a joined list column to join all possible options in a comma-delimited string (or delimited by anything other than comma, if your strings can contain comma).
Add a Custom Component, tie the joined list column above to it, and the column where you want to store the output.
Prompt it to look at the joined list and display them as a dropdown, read and write the choice to the output column.
On adding, use a relation on lowercase format to check if the added value is in the database. If not, add an add row column to add it to your list of choices.