How to add values of Table column to Single Select widget for dropdown list

[rui]

Hi ,
I want to select value throught dropdown list, and data values are get from table column.
How to add values of Table column to Single Select widget for dropdown list.

[thorsten.langner]

Hi @rui,

you could make a Querie of all table values (no filters) and sort on any column you want. Than make a Table aggregation of type “unique” and choose this one as datasource for the options.’

Keep in Mind, that queries are always limited to 1000 entries and the aggregation is applied after the querie.

[rui]

Hi @thorsten.langner, Thank you for your support, I have successfully solved this problem.