Allowing Free Text in Ref Column using ValidIf

Dear Experts,

I am having a State/City/Area setup in Address table which I am referencing in another table using ValidIf and it works fine. User selects State from the dropdown and then the City field shows up, selects City and the Area field shows up. All of the fields provide a dropdown for the user with the values from Address table.

My requirement is rather than showing the values in dropdown in the State field, user is required to enter the state name and with that the City dropdown comes and then the Area dropdown.

Is there a way, free text or numeric id can be allowed in a Ref field (Enum) using ValidIf with the referenced values from State column in this case (from Address table) being not visible to user?

Thanks!

Solved Solved
0 4 459
  • UX
1 ACCEPTED SOLUTION

The difficulty comes if you want to keep the data validation (force user to type a state name that actually exists in the table). I just tested this as I was curious. I figured specifying a more complex expression for valid_if that does about the same thing, but in a different way, would make the dropdown disappear, but still give validation. I was correct, but Iโ€™m not sure where exactly the line is drawn.

This still shows a drop-down of values

IN( [_THISROW].[state] , address[state] )

This does not, but does provide validation

COUNT( SELECT( address[state] , [state] = [_THISROW].[state] ) ) = 1

View solution in original post

4 REPLIES 4
Top Labels in this Space