Merging data into checkboxes
I'm fairly certain I know the answer to this, but thought I should double check just in case.
I have a PDF form that I've built for the purpose of merging in data from Salesforce. The original paper form is mandated by an outside agency, so I don't have any flexibility on the field types -- I just want to be able to pull the data from the same fields out of Salesforce into the PDF form so I can print it. There are a handful of fields that are "mark all that apply" type checkboxes. In our Salesforce system, these fields are multi-select picklists. I know that the Export Value needs to be set to the correct field value (or, really, the API value) in order to check it...but I'm running into a wall when it comes to fields that have multiple values selected.
Is it possible to set a checkbox to import on a partial match?
In other words, if I have a field for Languages Spoken and have checkboxes for English, Spanish, French, and Mandarin...and a person's selection in Salesforce is both English and Mandarin (which exports from Salesforce as "English; Mandarin")...is there a way to set the English checkbox to essentially look for "includes English", the Spanish for "includes Spanish", etc? Simply setting the Export Value on the English checkbox to "English" won't work, as the exported value from Salesforce is "English; Mandarin".
Am I completely out of luck here?