how to create choices from table records?

[alvatindra]

I have a table xyz, there are records in that table.

Is there any option to get the values of one column of xyz table, as choices?

[schorsch]

Hi Tindra,

I'm not exactly sure what you want to do, so hopefully I hit the target 😉

Generally it is not possible to convert somehow an existing column of a table e.g. a string, date, boolean column and the content of this column in a choice list. Of course it is possible to create a new column with the same label than the existing and define the choices in it - but when there is any "logic" on the existing column/field (used in business rules, client scripts, data/ ui policies... etc.) this is not recommended, otherwise you have to change all this "logic- stuff"....

But when you only want to have the information how often an entry in a column occurs, you can do this very simple via the "group by" function in the table column. Open the list of the table, right click on the header of teh column you want to have the information and use "group by" in the context menu....

hopefully this helped...

best regards

Georg

[akashsrm100]

Hi tindra in which application/domain you have created your table??

thanks

[alvatindra]

In Global Application scope. I checked it.