I am deploying Google Sheets for backend online data collection. For geopoint and select multiple question types the responses latitude, longitude altitude and selected multiple values are stored in single column, separated by space.
From one of previous posts I knew that lat & long can be captured in 2 different columns with the use of calculate & selected-at in the calculation field.
On similar lines, is this possible with select_multiple question type. For 5 choices I will create 5 calculates with name of the choice & the response will be saved as Yes or No depending on the check box selection, using some if then functionality. This will create the Google sheet with no data cleaning, find replace etc.
Briefcase is capable of doing this for Aggegate & Central but can not be used for Google Sheets.
Briefcase also facilitates to create GeoJSON. Can a Google Sheet can be converted into GeoJSON from within Sheets?(out of scope for this forum, but still help is needed) or the only option is to download & get converted from Online convertors..
Thank you a lot.
Pune MH, IN.