Calculated Field - User Entry

Question

We user Acrobat with merge functions from a database. We concatenate "City, State Postal Code" with a Custom calculation script. In some records, we have a 'Bad Address Flag', which leaves these data fields empty in the merge process.

Our users would like to type in a City State Postal Code into the Text Field. But, because the field has a formula using 'event.value = ***", the manually entered information gets over-written when the user tabs out of the field.

My question is : is there are different command than 'event.value' which will allow the retention of the manually entered information ... or ... is there a way to wrap my custom calucation script in an IF THEN logic that will take the merge data if it is available, or retain the manual info, if merge info is not available?

Thanks,

Mike

try67 · Accepted Answer

There is, but it's tricky. The way to do it is to look at the source of the calculation (via event.source.name). If it's one of the fields whose values you're combining ("City", "State", etc.) then proceed with the calculation. If not, do nothing. This will allow the user to enter a custom value, and won't overwrite it the next time the value of another field is changed.

Nesa Nurani · Answer

Don't know your exact code but try something like this if you want manually enter when field is empty:if(event.value == ""){event.rc = false;}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded