Prevent Duplicate Names in two different columns

pendu_jaat · 04-10-2020 06:10 AM

Hello

I am creating a travel request app, where users can request for travel from the authority in an organization. My form has two columns being [Name] with type Name and another column [Other Travellers] with type Enum List with addition.

The [Name] will be the name of the person who is traveling and [Other Travellers] will have the name of the people traveling with him to the same destination. I am trying to make a filter so that the input in [Name] can not be included in the [Other Travellers] or vice versa. If the same name is entered in [Name]and [Other Travellers], it should throw an error.

Please help me on this.

Suvrutt_Gurjar

Hi @pendu_jaat,

If it is for the same record that you are trying to prevent duplocation of names in two different columns as you have described , then in general, you may have an expression something like below in the Valid_if constraint of both the columns [Name] and [Other Travellers]

NOT(IN([Name],[Other Travellers]))

Steve_Tan

Hi,

How to prevent duplication of names if there are 3 or more different columns?

Steve

Like this:

ISBLANK(
  FILTER(
    "table",
    AND(
      ([column1] = [_THISROW].[column1]),
      ([column2] = [_THISROW].[column2]),
      ...,
      ([columnN] = [_THISROW].[columnN])
    )
  )
)

Suvrutt_Gurjar

You may also also refer following help articles , just in case you have yet to refer these

pendu_jaat

Thank You very much. SOLVED!