How can I insert/update multiple line items in SharePoint list using InfoPath form

Question

I am an newbie in SharePoint and part of finance team. I have been tasked with creating a SP site which has the following view (example):

    countries: 
<checkbox>    India
<checkbox>    china
<checkbox>    Pakistan
<checkbox>    Shri Lanka

Record names: 1. ABC 2. XYZ 3. qwerty 4. bla bla

[Submit Button]

Now the requirement is if i select 2 countries then a total of 8 line items should be created (2 countries X 4 records). If I select 4 countries, a total of 16 records should be created in SP list (4 countries X 4 records). How can i achieve this using Infopath and SP list.

I could not find anybody in my function who can guide me on this to reaching out to the Codeproject community for help. I will really be grateful for any help/guidance/pointers towards a solution.

Answer 1

If you promote those fields into SharePoint columns, you can check their status within an SPD Workflow. You can promote these fields by going into InfoPath and selecting File -> Form Options -> Property Promotion.

I'm assuming by your tag that you have SharePoint Designer to use. If not, don't use that tag, since it's a program not "SharePoint Design" in general. In your workflow, You can check for the checkboxes and create list items based on it. How to create a workflow in SPD. Here is a link that will show the basics on Logical Operators in SharePoint.

Essentially, create an action to check the promoted checkbox fields, and then use the "create item in this list" based on how many checkboxes say yes. If you've never used an SPD workflow before, I recommend doing some research on it before you begin. It's easy to use and intuitive, but I'm restricted to only two links so I cant give you more things to look at.