Get available items in a select field (non-gray items)

[#1]

I'm trying to find a function, that would give me the available items in a select field. I can get the number of possible items (non-gray) using GetPossibleCount(fieldname), but not the actual values.

I'm not interested in the grayed out items, just the ones that I can actually select.

I'm not sure there is a way to achieve that, or is there?

[Mark_Little]

Hi,

I may be missing what you want, as GetPossibleCount() does that.

Mark

[tamilarasu · Accepted solution]

Hi Matthias,

Try,

Concat([Waybill Date],',') - output will be comma separated text.

[#4]

[#5]

Hi Tamil

Awesome, that is excatly what I was looking for. I needed to add a distinct to only get every value once, but this works:

=Concat(Distinct FieldName,',')

I get: Completed,Maintenance,Scheduled

Thank you very much.

@Mark, Ramanjaneyulu

Thanks for your answers. I was looking for the actual values, and not the number of values. I guess my question wasn't very precise.