If Calculation prompting input

Question

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?

BrandonArmstrong · Answer

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

TylerShelton1 · Answer

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

BrandonArmstrong · Answer

Hi Tyler,

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

Example Attached

Brandon

Calculation_function.xlsx