Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Does that give us a hint??? Of course it does! 

  • So I take the text 
  • Paste it into Google Translate which seems to format the Chinese characters nicely, and strips out all the HTML, check that the word make sense, then paste that back into Form Assembly 
  • 超声部  / Ultrasound Dept.
  • I then delete that field from the Prefill Mapping and create it again. 
  • YAY it works!

So, what was the answer? 

  • The prefill is mapping the exact text from Salesforce "Ultrasound Dept." to the option in on the prefill mapping that says "Ultrasound Dept." in the "Correspond to..." side. 
  • It then looks for the value in the "These form choices" side and tries to find that in the HTML that is produced by the form - in this case it was trying to find "超声部  / Ultrasound Dept."
  • It could not find that between the <label></label> tags because the label says in HTML language "<span class="onechoice"><span style="font-size: 10.0pt;font-family:&quot;MS Gothic&quot;;mso-bidi-font-family:&quot;MS Gothic&quot;;color:black; mso-ansi-language:EN-AU;mso-fareast-language:EN-US;mso-bidi-language:AR-SA" lang="EN-US">超声部</span></span>&nbsp; /&nbsp;<span style="font-size: 14.688px; line-height: 22.032px;">Ultrasound Dept.</span>"
  • And that is never going to match in anyone's language. 

NOW to go and replace EVERY chinese value in every selection in my Form Assembly Form and get this form working!