I'm trying to convert a spreadsheet to an infopath form that eventually submits to a sharepoint list.
Here's my current problem.
I've created a drop down menu, with 5 options, each option has a corresponding task to be carried out. I want that corresponding task to be prepopulated in the next colum called "Action"
I'd like the form to be self contained as the template could be comepleted off line and submitted later.
Kind regards,
Martin