"If Then, or Else..."

[em-admin]

Im trying to achieve the outcome in a MIDDLE of a flow:

- if Calendly field 1 is NOT blank, then return "HELLO" text + Calendly field 1 value + Calendly field 2 value + send to a row/cell in Google Sheets

- if Calendly field 1 IS blank, then return Calendly field 2 value only + send to row/cell in Google Sheets

I looked up for guidelines about using Router but:

- it says Router cannot be added in a middle of a flow, needs to be last step... what's a point of having Router as a last step if we cant apply returned data to following steps?

and I cant even figure how to achieve the outcome with the Router anyway... can you help?

thanks

 

[Supreme]

Hey @em-admin

In that case, we recommend you use the Default Value action step which will pass a predefined value when some fields are not filled from the API response.

 

[em-admin]

sorry let me give more details

- if Calendly field 1 is NOT blank, then return "HELLO" text + Calendly field 1 value + Calendly field 2 value + send to a row/cell in Google Sheets

- if Calendly field 1 IS blank, then return Calendly field 2 value only + send to row/cell in Google Sheets

once again, the step is in a middle of a flow, so Router doesn't seem to work. how do I achieve these outcomes?

 

[ArshilAhmad]

Please check out the router of this workflow to understand how it's supposed to be set up to achieve your use case.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[em-admin]

this isnt helpful! why are you ignoring the point that I said this actions needs to happen in THE MIDDLE of the flow? your Router example does not let me add any following steps!

here, I created this flow

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

step 1: Calendly
step 2: whatever needs to happen there
step 3: Google Sheets

in Message field we need to achieve:

- IF "Res5 Resource Questions And Answers 0 Answer" field is NOT blank, return, "VERIFIED CLIENT: Res5 Resource Questions And Answers 0 Answer"

- IF "Res5 Resource Questions And Answers 1 Question" field is ALSO not blank, return, "VERIFIED CLIENT: Res5 Resource Questions And Answers 0 Answer | MESSAGE: Res5 Resource Questions And Answers 1 Question"

- IF "Res5 Resource Questions And Answers 0 Answer" field is BLANK but "Res5 Resource Questions And Answers 1 Question" is NOT blank, return, MESSAGE: Res5 Resource Questions And Answers 1 Question"

- IF both fields are BLANK, return nothing

how do we achieve this outcome?

 

[ArshilAhmad]

Please check out this workflow, its Router conditions, and the Google Sheets action steps in all the routes.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[em-admin]

super helpful and appreciated!