Getting exact number of results from Google Sheets and displaying them

(Yun) #1

According to the ss above, I’m trying to display the “items” that a particular user’s response path (“Metadata”) have in a message.

How can I only display the exact number of “results” according to the ss using Bot - New Message?

The following is how I structure the message:

Here are your pending order(s):

Item #1
{{search_metadata.results_+_gsx:item}}
Details: {{search_metadata.results_+_gsx:details}}

Total Amount: {{search_metadata.results_+_gsx:total}}
---------------------------------------------------------

Item #2
{{search_metadata.results_+_gsx:item 2}}
Details: {{search_metadata.results_+_gsx:details 2}}

Total Amount: {{search_metadata.results_+_gsx:total 2}}
-----------------------------------------------------------

Item #3
{{search_metadata.results_+_gsx:item 3}}
Details: {{search_metadata.results_+_gsx:details 3}}

Total Amount: {{search_metadata.results_+_gsx:total    3}}

As per above, how can I show 4 “items” if there are 4 results from the ss instead of 3?

(Kellsey Shaw) #2

Hi Yun,

You can use the Magic Repeat function from our Collections Outputs to list items rather than using a number to reference which one :thumbsup: