You are viewing limited content. For full access, please sign in.

Question

Question

Can we set values of multi-value fields in Repository to be unique

asked on April 5, 2018

Good morning,

I was wondering if there was a way to set the values of a multi-value field in Repository metadata to be unique. In the example below as you can see, I can set the value of "choice 1" twice.

 

TestDropDown.PNG
0 0

Replies

replied on April 5, 2018

No one has said anything yet so I will chime in - I've been trying to look for a way to do this for you, and so far I am not seeing any options. Interested in seeing if anyone comes up with anything else though. 

1 0
replied on October 29, 2018 Show version history

I'd use the built-in duplicate removal:

The first activity retrieves "Policy ID" the second writes the token back to "Policy ID" removing any duplicates. I'd consider removing blanks too:

#@RemoveDuplicates;RemoveEmptyItems@# (but not necessary if the UI, rather than the API, is used to edit the metadata.)

 

1 0
replied on April 5, 2018 Show version history

Thanks Valerie,

I was thinking that I could create a table where I would only allow the combination of Entry ID and TestDropDown value to be UNIQUE and then add a condition to trigger a Workflow when metadata change. This workflow then would try to INSERT all values from the entry and if successful, then it would DELETE the content and nothing happens, and if it tired to INSERT a duplicate combination, then it would catch the error and send me an email or something.

No the most elegant solution though :( but it works for now

 

TempTable.PNG
Condition.PNG
TempTable.PNG (20.35 KB)
Condition.PNG (22.48 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.