Restrict user not to select more than one field value from the straight table

[deemdinesh]

Hi Everyone,

There is a requirement where I need to restrict the user not to select more than one country from the straight table.

Anyone have any ideas how to resolve this?

[Or]

As far as I know, unfortunately, there is no way to restrict a field to be "No more than one selection". I am aware of two options here, basically:

1) Set the field to "Always one selected". This forces exactly one selection on the field, which means you can't select more than one but you also can't have the field with no selections at all. It probably doesn't match what you want here.

2) Use calculation conditions on your objects to avoid calculating the object if more than one value is selected. In this example, your calculation condition would be e.g. if(GetSelectedCount(Country)>1,0) and your display message for this condition would be e.g. "No more than one country may be selected when viewing this table".

Note that there is no difference insofar as where you make the selection - you could make it within the table, from a filter box, from the Selections scree, using Smart Search, etc - they all wind up with the same result.