I have a table that I'm using to capture multiple values to populate multi-value fields in Laserfiche. For each table column, I have a lookup that always is active and pointing to a SQL table that I've generated, which populates the drop-down list options for each column / added row. The one issue I'm running into, is that when using the table and lookup, I can actually type anything I want (something not in the drop-down), which is problematic for consistent input. For instance, we might have users choosing not to use the drop-down options and type something random.
Does anyone have an idea for limiting the table drop-down options (populated by SQL) as the only usable input and disabling the users ability to type whatever they want in the rows? Using a predefined drop-down list is not an option.
Or, would it be possible to insert some sort of JQuery that notifies the user that they have entered a value not found in the SQL database?