topic Re: Display the email address of the person who filled out a form in ArcGIS Survey123 Questions

Display the email address of the person who filled out a form

GDS — Mon, 26 Feb 2024 13:45:58 GMT

Hi everyone,

I'm using the pulldata("@property", 'email') function in a text "author" field to pull up the email address of the connected person. It works well when sending a new form. But when consulting an existing form or entering a new repetition on an existing geometry, I'd like to display the e-mail address of the person filling in the form and not the connected person.

Thanks for your help!

Re: Display the email address of the person who filled out a form

abureaux — Mon, 26 Feb 2024 15:44:04 GMT

"person filling out the form" can mean a few different things depending on environment.

If you mean the account of the person, you can potentially use the "username" or "email" type
Not all of my users have account, so I have what's essentially a dedicated "who is this?" field in most forms. In that case, I have them select from a CSV which contains emails and use pulldata() to get the email (and other employee data)

EDIT: If you don't see email (or maybe username also), update your Connect. I believe that email was a "newer" addition. Get Connect from the Microsoft Store so it auto-updates.

Re: Display the email address of the person who filled out a form

jcarlson — Mon, 26 Feb 2024 15:49:18 GMT

Do you mean you want the original email address to stay unchanged?

A calculated field in Survey123 that already has data in it (such as when editing an existing entry) should not overwrite the existing value unless the user clicks the icon to recalculate it.

Have you considered making a separate form for editing existing features? We do that a lot, where fields are calculated at initial collection, but then are considered read-only from that point on, so a separate form keeps uses from editing those fields.

Re: Display the email address of the person who filled out a form

abureaux — Mon, 26 Feb 2024 15:58:13 GMT

calculationMode=always may be set. So new username = updated calc?

If this is what's going on and @GDS really wants to minimize user interaction, I'd recommend setting up calculates. Probably something that users IF statements and pulldata("@property", 'mode') to store the username for a "new" submission in one field, and "edit" in a separate field.

Re: Display the email address of the person who filled out a form

GDS — Tue, 27 Feb 2024 07:51:42 GMT

Thanks for your answer. I tried that, but the problem is that it doesn't appear in the form. The aim is for the person consulting the survey to be able to see the email address of the person who filled in the form.

Re: Display the email address of the person who filled out a form

GDS — Tue, 27 Feb 2024 07:55:33 GMT

Thanks for your answer. Yes, because it is not possible to modify a survey that has been sent. Only to create a new survey, consult and enter a repetition on an existing geometry (but then it's a new survey). Currently, the person who, for example, consults a survey that has been sent, sees his or her own e-mail address appear, rather than that of the person who filled in the survey.

Re: Display the email address of the person who filled out a form

abureaux — Tue, 27 Feb 2024 16:10:42 GMT

Data collected in the "username" or "email" field is hidden by default (seems like a deficiency that it requires a "label").

You can show it by referencing that field. You can also make the display field dynamically appear. Try something like:

Re: Display the email address of the person who filled out a form

GDS — Thu, 29 Feb 2024 12:24:13 GMT

That's perfect! It works exactly as I wished! Thank you very much for your help.