Table with Multiselect Field write to a HTML table
I have Zap that I use to grab data from Kintone app using a webhook as a trigger (from Zapier). This Kintone app has a table in it that a user fills out. In that table is a field that is Multiselect, so the user can select more than one item. That table can multiple records and each record could have multiple items selected in the Multiselect field.
This is an example:
In my Zap I call that data to write it to an Exchange email using HTML body. When I use
I use the Line Itemizer to format the data so that I can build a table in the HTML body of the email BUT everything looks great until I get to the Disposal Reasons (Multiselect Field) because of the comma it separates that field wrong. I the example below the Disposal Reason for the 1st record should be “Cannot Test/Recert” and “Expired” then for record 2 of the same table it should be “Slow Mover” and “Small Qty”. The problem is the comma. Because it separates by the comma to take each Disposal Reason and add to the existing record but adds new lines. See my snapshot of email below. I’ve been playing around with formatting but I cannot get it to work. So in short, Cannot Test/Recert and Expired should be in one table record and Small Qty and Slow Mover should be in the 2nd record of the same table, see above snapshot of the Kintone record. Any help would be greatly appreciated. Thank you.
Page 1 / 1
Hi @ENUSA
Depends on how the data is formatted that is returned from the Zap step, then how your other following Zap steps are configured.
Post more screenshots showing how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings.
Hi Troy thanks for the reply. I am newer to Zapier. I have been using it successfully for about 6 months. Built a bunch of Zaps for work but this is the first time I had to build a zap and email with Multiselect fields inside a table that can have multiple records. I’ve been playing with formatting and placement but I just cant seem to get it right, What is messing me up is how Zapier knows to split everything else into the correct record but these multiselects get messed up.
This is the first formatting I do. Takes the data and gets into “table records” (if that makes sense)
This is the output. It is wrong the Expired should be with the Cannot Test/Recert. Ideally I want to put a <br> in-between the 2 so that it lines up nicely in my HTML table in the email. I was testing that with formatting using text and replacing the comma with <br> would work great if I can just get the proper data in the right records. I removed that step for now.
Then I do this next formatting to get the Output Text.
The results look like this because of the 1st format
Then I “finalize” it with the last format to get the desired output to place into my email body.
This is the result
Then I add the Output to my email body
But this is what I get
I made some changes but then it wont separate at all and I get a result where all 4 reasons are put together and then put in both table records This snapshot below is a different attempt that failed.
Hi there @ENUSA,
I just came across your post here and wanted to check in here to see how you’re getting on. Were you able to resolve the issue that you’re running into here?
Please do let us know if you’re still in need of some help on this at all - happy to assist further!
HI @ken.a
I haven't been able to figure out how to keep the multiselect items with the correct record in the table. They either merge all together or they separate each multiselect into its own item. I did a work around that works for my team but I would like to figure out how to do this. The system seems to know how it is broken out for the table but I cant get them to correctly display. When they show up in the raw data from Kintone all the items are bunched together, a,b,c,1,2,3 where they should look like a,b,c and 1,2,3. That comma between c and 1 seems to throw it off when I use formatter. Thanks.
Hi @ENUSA,
I’m so sorry for the delayed response here.
This seems to be a fairly complicated setup since it involves HTML to create a table I believe this would require a more personal help. I would recommend reaching out to one of our Zapier Experts here: https://zapier.com/experts
