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”>>