I'm will be grateful if you could help me figure out a solution for a below case.
In one of our templates, we need to get from our customer information about Billing country and if it's an EU member VAT ID. Both fields need to have a write-back enabled to the salesforce (opportunityid>accountid>billingcountry or VAT ID).
Dropdown lists don't enable write back to SF Meanwhile with the custom field the problem is that exact rule cannot be created simply because there are too many possible entries (28 EU members). I have also tried to play with data validation so that the Country field can be filled in only in a given format (Capital letters) however still a number of possible entries is too big to successfully create conditional logic.
While using radio buttons or dropdown list (EU member? with options "yes" and "no") we "trust" customers that they will select it properly which is not always the case... The process is 100% automated so that if there is wrong information on the form signed, then wrong information will be on the invoice which we cannot afford. We don't want to engage signers to verify if the selection is correct.
Does anyone have a similar problem? What's the solution you're using in cases when there are several values that need to trigger a field to pop up?