Solved: Customize System Text "There is already a row with... - Page 2

Swoopy · 12-27-2020 08:51 AM

Where in editor can I change the wording of “There is already a row with the key”?

Because I have not found this in UX > Localize > Customize System Text.

Steve

Sure, any column can be displayed in a form.

That makes sense. Given that, here are the two alternatives I see:

Add a column of type Show that displays the error message when the new’s key column duplicates that of an existing column.

OR
Configure the Valid If expressions of the (three?) other columns that are used to construct the key column value to produce an error.

Myself, I use approach (2).

Invalid value error expression for each of the key component columns (not the key column itself):

IFS(
  ISNOTBLANK(
    FILTER(
      "table",
      AND(
        ([key-column] = [_THISROW].[key-column]),
        ([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER])
      )
    )
  ),
    "duplicate value"
)

replacing table and key-column as appropriate.

Valid If for each of the key component columns:

ISBLANK(
  IFS(
    ISNOTBLANK(
      FILTER(
        "table",
        AND(
          ([key-column] = [_THISROW].[key-column]),
          ([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER])
        )
      )
    ),
      "duplicate value"
  )
)

View solution in original post

Customize System Text "There is already a row with the key"