Edit module does not have validation tab

🧩 Low-Code Development
#1

I have a module with 4 fields id1, id2, name, address. a record is unique when it is distinct combination is id1 and id2 together.
i am trying to set this up and

  1. i dont see a validation tab, i only see unique values tab
  2. though i add id1 and id2 both under unique contraint #1 it still looks for uniqueness in id1 and id2 separately.
    please let me know how i can get around this.
#2

Since this is a more complex case I suggest you handle this using workflows. Where you can do extensive validation.

What to do in the workflow:

  1. Check if there exists a record with the same combination of ids (use a record list with a prefilter to determine that)
  2. Raise an error or save based on if value is not distinct
#3

Same issue, there is no validation tab in create/edit module page. I have to maintain unique records based on selected fields in the module

#4

Validation tab was renamed to Unique Values, I guess it wasn’t updated in the docs. You can do what you said in there.

1 Like
#5

image
image982×291 21.6 KB

When trying this, it is still checking unique values for a field individually.
But i am trying for unique (Personal User, Tenant) combined tuples.
(version=2023.9.8).

#6

For such cases, you need a workflow. With a beforeUpdate/Create trigger and check it there.