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.
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);