How can I correctly format the output coming to Mango Apps from Google forms?

Question

When taking selected columns from Google Forms into Mango Apps and creating a post all of the selected fields are being merged into one large paragraph with HTML formatting on it. I noticed the “Send Data” output from Forms is perfectly set but once it’s received by Mango they are all merged into the paragraph with the output even containing the HTML tags <p> </p>. Is there a way to filter the final output from Mango or is that a separate ZAP in itself?

. Is there a way to filter the final output from Mango or is that a separate ZAP in itself?

joshb · Answer

Hi @Lexthetech, you can use the Formatter by Zapier action as your step 2 to remove any html tags.

To find the Replace HTML option in the Formatter, follow these steps:

Click the Text option, then click the blue “Continue” button.
Click the “Transform” dropdown and find “Remove HTML Tags” option, then click the blue “Continue” button.
Input your text by clicking on the text field coming in from Google Forms (Sheets), then click the blue “Continue” button.
Click the blue “Test & Continue” button

However, I believe you would like to present the text in a better way, maybe with bullet points or some structure. Can you send a screenshot of the sample data shown in MongoDB’s action?

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded