Using Simple Lists to store emails address for approval but not being able to use the same email twice, help.

[DeejayBrown]

Hi,

Sorry if this is the wrong place to put this, I hope someone can help with this. We are trying to set up a self service option that allows our customers to log access to BI Reports through Hornbill, all of the report approve don't have Hornbill accounts so the request gets sent as an external authorisation node with their emails in a simple list with the name of the report they approve in the display that the customer sees. This works perfectly but the issue I have is some people approve access to a selection of reports and you can't have the same value for one option has anyone had to do something like this and if so what work around did you use? 

Thanks for any help you can give.

[James Ainsworth]

Hi @DeejayBrown

Is there a reason why you wouldn't have these approvers in Hornbill as Basic Users or Contacts (if they are external to your business)? 

 

[James Ainsworth]

5 hours ago, DeejayBrown said:

you can't have the same value for one option

Do you have an example or screen shot of where you are trying to set this up or have it displayed?

[James Ainsworth]

Is this the type of setup that you are trying to do?  And you are getting an error when entering in the same email twice?

 

If that's the case, the Value field is a unique key for the simple list and you can't have duplicate values.  Let me know if I'm on the right track and from there we can see if there is another way to approach this.

[DeejayBrown]

17 hours ago, James Ainsworth said:

Is this the type of setup that you are trying to do?  And you are getting an error when entering in the same email twice?

 

If that's the case, the Value field is a unique key for the simple list and you can't have duplicate values.  Let me know if I'm on the right track and from there we can see if there is another way to approach this.

Hi James.

 

Yes that is exactly the way it looks, I tried to put a number after or before the email address in the value field to make it unique but that stops the BPM being able to read the email address.

 

Thank You

Deejay Brown

[Martyn Houghton]

@DeejayBrown

You could look to add a different prefix character to the Value column and then in the BPM use the String Utilities node to trim the first character off the Value column giving you the unaltered email address to then us in the Authorisation BPM node.

Cheers

Martyn

[DeejayBrown]

@Martyn Houghton

Hi, what String Utilities node should I be looking to use? I had a look at the Trim option but that only Trims whitespace, should I be using the Regex Substring one?

Thanks

Deejay

[Martyn Houghton]

@DeejayBrown

We use the Substring option. Leaving the To entry empty returns the remainder of the string.

Cheers

Martyn

[DeejayBrown]

Not sure if I am doing something wrong but not able to get it to work.

 

 

Thanks

Deejay

 

 

[Martyn Houghton]

@DeejayBrown

The sting counter starts from zero, so if you want the string from the second character you need to enter 1 as the start position.

With anything like this I tend to add in a debug timeline node to output the result value/string created to make sure it is doing what you expect it to do.

Cheers

Martyn