Hello all,
I have some data filtered in a slice. How can I reference this slice, and send all the rows of data in the e-mail body?
My Slice Name is “Stock To Order”
The primary key field is called “ID”
“Item” Column Exists
“Last_Known_Order_Code” Column Exists
“To Order” Column Exists
<<SELECT(Stock To Order[ID],TRUE)>>
<<[Item]>>, <<[Last_Known_Order_Code]>>, <<[To Order]>>
<>
Errors
Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[Item]’ is invalid due to: Unable to find column ‘Item’.MORE INFO
Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[Last_Known_Order_Code]’ is invalid due to: Unable to find column ‘Last_Known_Order_Code’.MORE INFO
Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[To Order]’ is invalid due to: Unable to find column ‘To Order’.MORE INFO
Any advice? Sorry, I am a graphic artist, not really good at programming.
Hi,
Without seeing your app, I’m typing this blind, but looks like you need a “start” expression. The correct syntax (again, hypothetically) would be:
<<Start: SELECT(Stock To Order[ID],TRUE)>>
<<[Item]>>, <<[Last_Known_Order_Code]>>, <<[To Order]>>
<>
There are a ton of examples on this help page: https://help.appsheet.com/en/articles/961746-template-start-expressions
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |