I have a table which basically acts as a source of dropdown for one of the forms in my app.
Although, I want the user to select an existing value from the dropdown when filling the form, I also want them to add a new value if what they are looking for doesn’t exist.
I tried to add another text input and write it to the same column, but unfortunately it wouldn’t allow it.
Anyone has any idea as to how this can be done ?
You will see a warning that two components are writing to the same column, but it will still work. I’ve used that method a few times.
As @Jeff_Hager said, it will work writing to the same column, but could be confusing to the user if they see both components; and you need to answer the question, “Do I want to allow values that are not part of the choice component in the table?” In other words, do you want the random value they enter to be part of the choices for future entries? If not, then that will do. If you need those values to be available for future entries (and to standardize statistics and reports), then you may want to have a relation to the selection table based on the entry column, and in a custom action when writing/updating the row, also do a write to the selection table if the relation is empty (in other words, they entered a value not already in the selection list).
Here’s what @David_Gabler is explaining:
The tagline used to be “There’s an app for that”. Now, with @Robert_Petitto , the tagline is, “There’s a vid for that!”
I love it!