Revolunet.github.io Website Review

sometimes you need a solid platform where people can collaborate in real-time and input data in a structured, reusable way. depending on your needs and planning, google spreadsheet can be helpful in such cases, specially if you dont have time or ressources to create a of course, a tailored-made admin interface can be “better”, but well, google spreadsheet is here, instantly available, battle-tested, powerful, very flexible and as we’ll see below, you can even extends the ui. also note the powerful google data apis gives you full access to your data in various ways and there many other ways to exploit yout docu*ents data (create executable apis, publish the feeds, embed spreadsheet…) the main issues for me yet are the google apps scripts disastrous developer experience, but i’ll give you some tips to reduce the pain this example use react, because it’s sooo 2015, but you’d better use what makes you happy :) these are hosted ja*ascript files that execute on the server-side, in the google infrastructure, and have access to various google apis and in the case of spreadsheets, these scripts can open custom isolated modals or sidebars, which can host random client-side ja*ascript inside an iframe, get data from your docs and send back results to them. so in this example, we’ll add a multi-selection widget to our spreadsheet, which will help our users create many-to-many relations this is a major pain in the @$$. when you want to script your docu*ents, you must use that editor which lacks all the basics. there are ways to use your preferred editor and git, but it’s for a later article. we’ll reduce the code needed here to the minimum : just some glue between our docu*ents and our react widgets. from here, you can add .gs scripts (server-side ja*ascript) and .html templates which are your custom modals or sidebars and where you can interpolate some values from your docs, using old-school php-like tags. the code from your html files cannot talk directly to the docu*ents but can execute functions from your .gs files.