check multiple columns to avoid duplicates

[BenjaminJ]

Hello,

First, thank you to all this community where we learn a lot.
My English is very bad, I will try to be as clear as possible.

Despite my research on the forum, I did not find what I needed.

I'm working on an application to assign employees to shifts per day with role (CI PSP 1, CS ...). I need the form to report that there is a duplicate. For that I think to go through Valid_if, but I can't make him understand that he must check all the columns (CS, CI PSP 1, PSE 2 PSP 1, ...) despite all the indications I have could find on the forum.

Can you accompany me?

Thanks 🙂

[SkrOYC]

There are multiple ways. My 2$ are that Valid_If for a column doesn't mean that it has to check content from that column, you could check any column from that row.
Another thing is that you could use an extra column as a pseudo id, something that I'm doing on all my tables lately.

If you have problems, come back for help

[BenjaminJ]

Can you tell me more or with a concrete example? because I have difficulty visualizing what it can give. Before posting this message I made several unsuccessful attempts.

Thanks

[SkrOYC]

---

@BenjaminJ wrote:

several unsuccessful attempts

---

Show us some so we can focus on exactly what you need to understand

[BenjaminJ]

Hello,

Finally, I found a solution and the problem was due to the visualization interface. thank you for your availability