How to add line breaks between variables in a database field using Formatter by Zapier
Good morning I need to create a line break between some variables that I insert in a field that I then send to my database.
In practice now it inserts something like: Line1Line2Line3Line4
I instead want it to be sent like this:
Line1 Line2 Line3 Line4
I'm trying to use Formatter by Zapier - Utilities - Line-item to text but then in Separator I don't know what to insert
This is how i add all fields in this filed Richieste, but it not work.
How i can solve it?
Page 1 / 1
Hello there,
You can try it like this and see if it works.
press shift+enter for separating them in lines and in Separator add “\n”
Hi @No_Stress,
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
hi
maybe i solved using shift+enter. I’m waiting the first lead for check it
Thank you for now
Hi @No_Stress,
No worries, just keep us on the loop so we can assist you further if needed. Thank you.
hi @jamm
it’s working now but in the facebook module i have some conditions, for example i ask if people want a package with flight, with train or only hotel. If they select with flght i ask from which airport the prefer If they select with train i ask from which city If they select “only hotel” i go to the next question. Now i have this situation
In the 3rd line i ask for trasportation method.
Is there a way to create a condition? For example: 1) If they want hotel + flight, I show which departure airport 2) If they want hotel + train, I show which departure city 3) If they want only hotel, I do not show departure airport or city
In the fourth line I display "Departure from" this means that I display which Airport or City the customer wants to depart from, but this also exits if they select "Hotel Only".
Can I somehow create a condition that shows the fourth line only if they search for a flight or train together with the hotel?
@JammerS
Yes, you can definitely do that, although it will become a little technical,
You can use “Path by Zapier” and add check condition on value of line 3 if for hotel + train hotel + flight hotel (fall back)
Add the the line items accordingly for each step, e.g want to show airport or train station or not.
hi @Mohammad_Shahzaib_Nawaz
i tryed so, now i test it and say the results
Thank you
maybe i made some wrong because in the first condition i added “if tipo di trasporto - text contain - Volo” add new mysql row etc etc in the second condition i added “if tipo di trasporto - text contain - Treno” add new mysql row etc etc in the third condition i added “if tipo di trasporto - text contain - Autobus” add new mysql row etc etc in the last condition (this you can see) i added: “if tipo di trasporto contain SOLO HOTEL, or NAVE or ALISCAFO” (it mean guest selected other option without train, flight or autobus”) add new mysql row etc etc
But when i receive a lead from facebook i receive this email from zapier: Error summary
MySQL
Required field "cliente id" (cliente_id) is missing. Required field "token" (token) is missing.
So maybe i have a problem in the conditions...
I’m back
this is my schema
This is the first case Volo + Hotel (Flight + Hotel)
This is the second case Treno + Hotel (Train + Hotel)
This is third case Autobus + Hotel
And this is the last case (Hotel without bus, train or flight) so if include “solo hotel” (only hotel), nave (ship) or aliscafo (hydrofoil)
But it not work because i receive email with this error: Error summary MySQL Required field "cliente id" (cliente_id) is missing. Required field "token" (token) is missing.
How i can solve it? maybe i have some error in the conditions...
Hi @No_Stress,
The error you're encountering in your Zapier setup likely stems from the "cliente id" and "token" fields not being correctly passed to the MySQL action. To resolve this, ensure these fields are correctly mapped in your actions, confirm your path conditions are passing the necessary data, and verify that the trigger supplies the required information. If issues persist, sharing screenshots of your setup—especially where the fields are mapped—can help identify the problem more precisely.
I hope this helps, and I look forward to your response.