Record Level Access based on partial field match

[GWBjr 0]

I would like a user to have access to records where their email (after the @) partially matches a field in the table  called website. For example John@excel.com has access to records that have websites equaling www.excel.com. How can I accomplish this? 

[Vitalikssssss 54]

Hi @GWBjr,

You may need to utilize Formula field in table where you store user information (auth. table) in order to sub struct domain name and add global domain.

You can use the following expression in the Formula field:

'www.' + Substring([@field:Email], (Charindex('@', [@field:Email])), Len([@field:Email]))

Finally, you can use this field in Record-Level-Security in order to accomplish your workflow.

Regards,

vitalikssssss

 

 

[GWBjr 0]

2 hours ago, Vitalikssssss said:

Hi @GWBjr,

You may need to utilize Formula field in table where you store user information (auth. table) in order to sub struct domain name and add global domain.

You can use the following expression in the Formula field:

'www.' + Substring([@field:Email], (Charindex('@', [@field:Email])), Len([@field:Email]))

Finally, you can use this field in Record-Level-Security in order to accomplish your workflow.

Regards,

vitalikssssss

 

 

Excellent but the formula result includes the "@", how can the formula eliminate that?

[Vitalikssssss 54]

@GWBjr

Try this expression:

'www.' + Substring([@field:Email], ((Charindex('@', [@field:Email]))+1), Len([@field:Email]))

Regards,

vitalikssssss

[GWBjr 0]

23 minutes ago, Vitalikssssss said:

@GWBjr

Try this expression:

'www.' + Substring([@field:Email], ((Charindex('@', [@field:Email]))+1), Len([@field:Email]))

Regards,

vitalikssssss

Perfect. Thank you