The map gets the entries from a Google Spreadsheet. It seems like the current code requires certain columns to be in a specific order, and that it does not support the format of the form results sheets. @tlacoyodefrijol created a new sheet by hand to match what the app understands. We need to update map.js to just look for the required columns regardless of their position so we can use the form results sheet directly.
Also ideally not rely on the imported sheet being the 4th in the spreadsheet :octopus:
The map gets the entries from a Google Spreadsheet. It seems like the current code requires certain columns to be in a specific order, and that it does not support the format of the form results sheets. @tlacoyodefrijol created a new sheet by hand to match what the app understands. We need to update map.js to just look for the required columns regardless of their position so we can use the form results sheet directly.
Also ideally not rely on the imported sheet being the 4th in the spreadsheet :octopus: