Hi, I have an Infopath form tied to a main list. In the form I have a dropdown that's populated with a name from a secondary list. I'm trying to add an icon (jpeg picture) to a column in the main list based on what's selected in the dropdown on the Infopath form. Is this possible WITHOUT coding? If so, how?
Main list/Infopath form:
Column 1: Name (populated dropdown from secondary list)
Column 2: Matching Icon (populated based on name selection)
Column 1: Name
Column 2: Icon
In InfoPath form, you will have to create secondary data connection to the Secondary list. Then create Rule on the Name drop down from Main list. Condition would be If Name="ABC", run Action: Set a Field's Value.
Select Field from Main Data Connection to be the Matching Icon. For Value, Insert Field or Group, Switch to Advanced View, select Secondary list as Data Connection. Select Icon from secondary list. Click on Filter Data and Add condition where Main Data Connection (Name) = secondary Data Connection (Name).
You might have to do follow this for each of the Name in Main list which is not the best design but depending on constraints, you might have to. Hope it helps.
Regards, Kapil ***Please mark answer as Helpful or Answered after consideration***
Thanks for the info. Kapil, your basis works, however I cannot select the icon field from the secondary list. All I can select from it is the ID and Name. I believe it's because the icon field isn't just a text field, it's a "hyperlink or picture" field.