How to add line breaks between variables in a database field using Formatter by Zapier

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.