If Calculation prompting input

460
3
08-20-2018 02:28 PM
TylerShelton1
New Contributor II

I'd like to create a field that prompts a text input or autofills based on the input of another field.

Is mailing address same as meeting address?

yes =  auto fill with meeting address field

no = prompt text input

Is anyone familiar with a calculation that will achieve this?

0 Kudos
3 Replies
BrandonArmstrong
Esri Regular Contributor

Hi Tyler,

Try something like   if(selected(${address_2}, 'yes'), ${address_entry}, '')

Example Attached

Brandon

0 Kudos
TylerShelton1
New Contributor II

Hi Brandon, 

That worked, but I'm running into an issue.

I am trying to hide the mailing address field input field unless prompted (in relevant column for address field: ${address_2} = 'no'). The calculation does not appear to work as long as the field is hidden. Any thoughts?

thanks

0 Kudos
BrandonArmstrong
Esri Regular Contributor

You can try something like the following...

If 'yes' is selected (meaning it is the same address), the value will not be stored but will display as a note for the user.  You will not need the address value as it will be the same as the initial address and there will be a value Y/N stored letting you know that it is the same address.  If 'no' is selected they will be prompted to enter their address.

Let me know if this works,

Brandon

0 Kudos