I want to give some of our clients a simple way to add (up to 20) users in our LMS (talentLMS) themselves.
So my thinking was to create a form where they could add first name, last name and email of the users they would like to add. My first try was to create a Google form but it’s not a great user experience to have to fill out 3*20 fields in a Google Form. So I tried Jotform and liked the “table input” form element. However, the output data when inserted into a Google Sheet via Zapier comes as a long string. I’m currently struggling to parse that data into separate rows using Zapier formatter and a formula in Google Sheet but struggling a bit with both.
So if anyone has any tips of achieving what I’m after I’m all ears!