Update custom field based on email domain

[Marc Mitchell]

We are running Jira Cloud and I'm looking to have a custom field update to a company name based on the users email domain. I've done some reading but unable to figure it out. Any advise would be helpful as I'm new to Jira.

Thanks,

[Kalyan Sattaluri]

Hello @Marc Mitchell 

Your question is too vague for us to give any constructive answers.

If an email address is  john@myexample.com, do you want to extract "myexample" and store it in a custom field which is Text field?

Or do you want to map "myexample" to some company name and do a lookup and put that name in your custom field?

Is the email already in a field somewhere or do you want to capture it at point of issue creation?

All of these details and any existing screenshot of rule / audit log are relevant to understand and suggest options.

Hope it helps. Thanks!

[Marc Mitchell]

Hi @Kalyan Sattaluri ,

This would be based off the Reporter field as it will already have the users email. There is a custom field I would like to have be auto populated with a company name based off the domain of the Reporter field.

All the users are going to be internal. Our company acquires others and then becomes a brand of the parent company.

I hope this provides some more details.

Thanks

[Kalyan Sattaluri]

Hello @Marc Mitchell 

{{reporter.emailAddress}} smart value gives you email address of the form - "john@myexample.com"

{{reporter.emailAddress.substringAfter("@")}} smart value gives you "myexample.com"

{{reporter.emailAddress.substringAfter("@").substringBefore(".")}} smart value gives you "myexample"

And so typically you just assign this value to the field where you want to store it.

 Depending on your trigger, for example, If you want to do this at the time of issue creation, you can have that as trigger and then you choose edit issue, select your field and assign the value.

Hope it helps. Thanks!