The community member's post describes an issue where repeated text in a column of a sheet used as a database is not displayed uniquely when dynamically shown in buttons. In the comments, another community member acknowledges the issue and tracks it on a GitHub repository. A third community member provides a solution using JavaScript to filter out duplicates and return a unique array.
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);
