🔦 Feature: MultiSelect can read possible values based on what exists in the Datasource

[sai-sy]

Please confirm if feature request does NOT exist already ?

• I confirm there is no existing issue for this

Describe the usecase for the feature

Currently MutliSelect can't reflect options that it hasn't been told exist. If Sai has the tags:one,two,three stored as a comma separated string in the database, but NocoDB only has been told that the options one and two exist then the field will appear as one,two.

This creates an increased opportunity for data dissonance as any API's or services that access the DB directly don't have their data reflected on the front end

Suggested Solution

MultiSelect should reflect exactly what is in the field, but when giving a GUI user options to add, it should do a scan (maybe on page load) for what available options there are.

Additional Context

No response

[dstala]

@sai-sy Need more details here. Multi-select is statically configured & can't be sourced from another field. You proposing to source information for multi-select options from a different field?

[dstala]

related - typecast support during import

[dstala]

NocoDB now supports a configurable option during file import to auto create missing options. Please check it out if that suffice for this requirement