I have an editable table in my app (table A), and I am using the
valueOptions property to have an auto-completion of a column (“Column name)” based on all possible entries of a second table B joined with the columns of table A on “Column name”.
Right now, the user can select all entries of “Column Name”, but can also enter free text in the cell.
Is there any way to constrain the input of “Column Name” so that only options from the matched column can be selected, and no free text can be entered? Ideally, the “Save button” ought to be grayed out when free text is entered in this column, and text option not belonging to the dropdown is entered.