Solved: List from values in a row - Page 2

Soporte_Gestion · 08-19-2020 09:06 AM

Hello there!

I had a form with 3 columns [ID] [text] and [enumlist] both ([text] and [enumlist]) are blank and the enumlist allowed other values.
When I open this form and add some values in the [text] column with “,” separeted for each value, after save the form and reopen it is it posible to extract those values into the enumlist of this form?

What I´m trying to achieve is a sort of Cheklist with the values that are entered in the [text].

Marc_Dillon

One option could be to write a valid_if expression (for the user input in text column) to invalidate poorly formatted comma-separation.

AND(
    NOT( CONTAINS( [_This] , " , " ) ),
    NOT( CONTAINS( [_This] , " ," ) ),
    NOT( CONTAINS( [_This] , ", " ) )
    )

…or somesuch

View solution in original post