Repeated buttons from Sheets database
When using sheets as a database with the HTTP request the expectation is that repeated text in a column will be shown once when displayed dynamically in buttons. However this is not the case, the same text will show many times as it appears in rows.
3 Replies
That's a good point
Sorted on my side with
const provincesArray = {{provinces}};
const cleanedArray = provincesArray.filter(element => element || element === 0);
// Convert the array to a Set to remove duplicates
const uniqueSet = new Set(cleanedArray);
// Convert the Set back to an array
const uniqueArray = Array.from(uniqueSet);
return uniqueArray; // [1, 2, 3, 4, 5]