Solved: Need Help Creating Workflow Template - Page 2

Brady_Lovell · 05-03-2019 06:58 AM

I’ve got a gSheet that contains a database of orders. In this table I have the column [Status]. Whenever [Status] contains the value “AVAILABLE”, i want to bring all of the orders that are AVAILABLE and contain only the columns [Pickup], [Delivery], [Farm], [Customer], and [Rate] to the gDoc so that I can attach it to a Workflow.

Basically I’m wanting my gDoc template to contain a 5 column table, showing all AVAILABLE orders in my system.

This is what I have so far…

<<If: [Status] = “AVAILABLE”>>

Pickup: <<LIST([Pickup])>>

<>

Phil

Try this:

<<Start: FILTER(Orders, [Status] = “AVAILABLE”)>>
Pickup: <<[Pickup]>>
Delivery: <<[Delivery]>>
Farm: <<[Farm]>>
Customer: <<[Customer]>>
Rate: <<[Rate]>>
<< End >>

View solution in original post