Sorting data from Google Sheets to Google Slides

How To
1

What are you trying to achieve?

Hi all!
I´m adding some data from Google Sheets to Google slides, and this works well. But I´m having problems sorting the data. I have a Search Rows module connected to an Array Aggregator, and then I added 3 fields in the Google Slides module to update a template. Data should be sorted (descending) by one of those fields, if numbers have two digits it works well, but if any of them has only one digit the sorting is wrong as it considers 8 as 9 as 90, 8 as 80, etc.
I appreciate your help! thanks!!

Steps taken so far

I tried changing the type of data but it does not work. I send screenshots of Search Rows module, the filter, Google Slides entry, and the results.

Screenshots: scenario setup, module configuration, errors

GoogleSlides_input.png
GoogleSlides_input.png816×340 32.6 KB

Results.png
Results.png336×838 58.4 KB

Filter.png
Filter.png1022×932 76 KB

SearchRows_module_Sorting.png
SearchRows_module_Sorting.png966×1386 86.9 KB

2

I solved it changing the data type of the respective column in the original Google sheet from Number automatic to Number number.

2 Likes
3

Hi @Ceci_D_Ang :wave:

Hope you’re doing great! Just wanted to take a moment to appreciate you for coming back and sharing your solution—it can be really helpful for other Makers.

Wishing you a wonderful weekend!

3 Likes