Closed evanwill closed 10 months ago
draft in branch modal-plus-url-option the complication is that published google sheet links have multiple "&" parameters in them, so when the full url is given as a parameter, those are split off as additional params of the initial link. So it works if there isn't any & in the link (for Sheets csv link you can do that by deleting the params and only using "output=csv" which will retrieve the first sheet). Other wise you would have to encode the url in the url--which makes sharing a link way more complex and unlikely
I changed the instructions for publishing a sheet to avoid & in the link it gives, and added a warning about having & in url . this keeps adding a link to share simple (even if it breaks in some usecases)
like:
https://collectionbuilder.github.io/collectionbuilder-sheets/setup/?sheet="https://docs.google.com/spreadsheets/d/e/2PACX-1vSn7AA-cbsXT3_nNUGftc1ab-CKXOJHMQCIENeR9NHElbyI9_qA99o0-HNZdG04v-M2_N21bUe_krQQ/pub?gid=0&single=true&output=csv"
read the parameter, load the metadata, reload the site with new metadata. allows shareable link with your metadata