I have built an ecommerce restaurant ordering and delivery bot in Manychat and am having difficulty populating an “order summary” showing the items they’ve selected. I also have a zap set up to notify the restaurant once an order has been placed - trigger is Manychat tagged user and it sends them an email through Gmail and creates a new opportunity in HighLevel.

I can’t figure out how to remove the items they haven’t selected from the list. 

For example, if you gave them 10 different topping choices for a pizza and they only selected two, I’d like for there to be a list of only those 2. I found a workaround through Botmakers that sets the item name as a custom value and if it’s 0 or false (boolean), it will be a blank line. This solution is not good for large menus though or large lists of items. I also tried various text formatter steps through Zapier but none achieved the desired results. (Attached screenshots of what I’ve tried in Manychat that did not work)

I reached out to Zapier support who said that with a piece of custom code, I should be able to zap out all the data to a Google Sheet (all of the items along with the corresponding quantities, whether it’s 0 or not), then sort through that list to filter out the rows or lines that contain 0 quantity to produce a list of items within a cell that contains only what has been selected. I could then try to zap the contents of that cell back into Manychat as a custom field. If that’s not possible, I could at the very least use the contents of that cell to zap into an email and the opportunity in HL though.

So now I’m reaching out to all of you in hopes that someone has been through this situation before and knows how to solve it. Please let me know, much appreciated!