Extract an email address from the body of an email

Morgan Daly June 11, 2023

Hello.

As I cannot work out how to make a single Jira form publicly accessible I am looking at using a Google form for ticket submission.

The problem is that the form gets submitted as the owner of the form not as the ticket submitter. I can send the email address of the submitter in the body of the email. I am wondering if there is a way to extract the email address from the body of an email and use the address to invite them to our Jira project and assign them as the reporter?

Thanks
Morgs

3 answers

1 accepted

2 votes
Answer accepted
Morgan Daly June 11, 2023

Essentially, what I am trying to do is extract the email address from the body and use it to "Add new customer" before assigning the new customer as the "Reporter".

I am getting stuck on the "Reporter" part now as this component does not allow me to use smart text values.

Any ideas?

Thanks
Morgs

Screenshot 2023-06-12 at 12.35.34 pm.png

Curt Holley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 11, 2023

You can add smart values in the reporter field. type it and transmit (hit enter)


Morgan Daly June 11, 2023

Thank you.

I did finally work this out however, I think it took me so long because I was trying to do this and maybe my value was too long.

In the end I created a variable and then I was able to use the variable.

Thanks again.
Morgs

Like Curt Holley likes this
0 votes
Morgan Daly June 11, 2023

All good. It was easy in the end to extract the email from the description content.

 

{{issue.description.substringAfter("Form submitter email: ")}}

0 votes
Curt Holley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 11, 2023

Hi @Morgan Daly 
Welcome to the community!

To help us try and answer your question, some more questions.

  1. Are you using Jira Cloud, or...?
  2. What kind of project are we talking about JSM? JSW? JWM?
  3. Are you currently using a google form or you are considering that as a next step?
  4. Can you show us your automation rule and any errors from the audit log? 

As without this info, it is hard to picture your exact scenario.

Morgan Daly June 11, 2023

Hi Curt.

- Cloud

- JSM

- Google form with Google script to format the body nicely.

-- Would prefer to just be able to surface a Jira form, publicly.

I think I am on the right track now with {{issue.description.substringAfter("Form submitter email: ")}} - I just didn't think it was going to be built in and this easy.

Thanks
Morgs

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events