nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Recipient Email Address: Send Emails Tool

JaredPilbeam2

I'm attempting to send multiple emails, and they are four separate Email Settings because each one uses a query to grab a certain field and then sends to its corresponding recipient. The tool states that emails will be sent in the order listed. I'm finding that only the Recipient Email Address in the top one is being used, while the other Recipient Email Addresses are ignored. Has anyone seen this behavior?

Trouver plus de publications taguées avec

Accepted answers

JaredPilbeam2

Hi Don,

Thanks. I've since figured it out. Here are the full queries:

send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'parcel_or_pin_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'street_or_address_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'tax_related_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'zoning_or_flood_zone_question?'</SPAN>
send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'other'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

My feature layer is populated through Survey123. The fields in the layer are populated based off of the entries in the survey. So, for example a survey was just submitted about a 'parcel or pin question'. That field in the layer is in turn populated and once the send emails script runs it will run the query and an email will be sent to the corresponding department (or whoever I have as a recipient). I actually removed Or send_email = '""'.

If you have a question about it maybe I can help. By the way, it's a know bug that you can't send to multiple recipients with this tool: ENH-000116673 Provide the ability to enter multiple email addresses in the Recipient Email Address section when using t…

All comments

DonHubbard2

Hello Jared,

I'm glad you was able to get it working. I am setting up the "Send Emails" to send automatic replies for when they submit a report and when the issue is resolved, and I have been running into issues with sending to multiple recipients. It looks like I need to find a work-around.

JaredPilbeam2

Hi Don,

Thanks. I've since figured it out. Here are the full queries:

send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'parcel_or_pin_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'street_or_address_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'tax_related_question?'</SPAN>
send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'zoning_or_flood_zone_question?'</SPAN>
send_email <SPAN class="operator token">=</SPAN> <SPAN class="string token">'""'</SPAN> <SPAN class="operator token">Or</SPAN> send_email <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">And</SPAN> field_2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'other'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DonHubbard2

I am also in the process of getting this set up and having issues with getting the "Send Emails" to work correctly. I know very little about SQL, but if you look at your first SQL Query, "send_email IS NULL Or send_email = "''" A" (can't read what is past the "A"), then it updates the send_email field to "sent". When it gets to the next configuration, the send_email is already populated with "sent" and no longer Null or blank. I may be wrong, but try to leave the Field to Update and Sent Value blank until the last configuration.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.