Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi all,

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!

Hi @Richard-SK 

Good question.

Please post screenshots with how the data is formatted that you are trying to use.

You can try using the Formatter > Utilities > line items related actions

Here is a string with two test users (Kiara Likey and Joina Oiku):

["Kiara","Likey","tesdjb@sdj.com"]|["Joina","Oiku","iouna@sfds.com"]|["","",""]|["","",""]|["","",""]|["","",""]|["","",""]|["","",""]|["","",""]|["","",""]

Hi @Richard-SK 

Can you please post screenshots with how the data is returned from the Zap trigger step to make sure we context is clear, thanks.

Heya, @Richard-SK! I wanted to swing by and see how you were getting along with this. 🙂
I also wanted to share this blog article on ways to use Formatter.

Specifically the section on “Creating multiple line items” might be helpful!
Keep us posted! 🤗

Hey @Richard-SK!

I figured something out that works quite well, but it takes a bit of setup to get it working just right. Here’s a brief video (no audio) showing all the pieces. I add the people to a Google Sheet for simplicity’s sake, but it would similarly with talentLMS.

The code I use, I got from this awesome post: 

 

 

Hi all,

Thanks for checking in, I have put this a bit on hold for now and gone for a form where the customer will make one submission per person as it makes the process smoother when troubleshooting and lessens the risk of one error runining the entire submission. But I will definitetly check out the post you referred to Christina & Nick!
Thanks!

Ok, sounds good @Richard-SK!

If you use a form solution that provides a “submit another” link after the person submits the form, that’s not a bad user experience :)

Terms & Conditions