Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 21, 2020 06:14 AM
I’m trying to send multi-line text through an airtable button via webhook to zapier.
Zapier is picking up the text as a single line with no line breaks. How would I send multi line text?
The text that is being sent across is of inconsistent length, so some records will longer and have more lines than others.
Any help greatly appreciated!
Solved! Go to Solution.
Jul 21, 2020 09:06 AM
My gut says that you need to encode your field data. Wrap all field references in ENCODE_URL_COMPONENT()
and see how that behaves.
Jul 21, 2020 08:19 AM
Could you share the relevant part of your script where you’re building the Zapier webhook call? I’m guessing your multi-line text is coming from a long text field. Is the rich text option active for that field?
Jul 21, 2020 08:40 AM
Heya @Justin_Barrett - the webhook url is “https://hooks.zapier.com/hooks/catch///?freestyle_time1=”&{25m Freestyle Time}&"&freestyle_time2="&{50m Freestyle Time}&"&desc="&{Latest Workout Text}
I starred out the unique webhook identifiers (just in case) but you get the drift.
The multi-line text is coming from a lookup. But I also tried it with a Long Text field with Rich Text active and it still spat out one line with no breaks.
Let me know if I’m getting something wrong?
Jul 21, 2020 09:06 AM
My gut says that you need to encode your field data. Wrap all field references in ENCODE_URL_COMPONENT()
and see how that behaves.
Jul 21, 2020 04:46 PM
That worked! Thanks @Justin_Barrett
Jul 21, 2020 04:56 PM
Ah except it appears I can’t wrap a lookup field reference in ENCODE_URL_COMPONENT() - the button that holds the webhook just greys out if I try to wrap a lookup field or formula field this way.
Any suggestions? Because I need to send the data from a lookup field.
Jul 21, 2020 07:21 PM
Lookup fields often return arrays, so you will probably need to force the lookup field’s output to a string by concatenating it with an empty string first. In the middle of the formula, that would become:
...ENCODE_URL_COMPONENT({Field Name} & "")...
Jul 21, 2020 09:38 PM
Perfecto! Legend @Justin_Barrett