First post here, so hopefully it will be a great start!
So I have a personal project that I’ve been trying to accomplish using Shiny, which I’ve been learning for the past month or so.
My end goal is to replicate the Trudeaumetre for my country, but I’m in the stage where I have 1084 government proposals (after text-mining) and I need to collaborate with hopefully dozens of people (possibly simultaneous) in order to individually check if each has been done/in process/discarded.
I have a .csv file with 1084 rows and 6 columns. I’d like to make a temporary website/app where people could filter columns to select rows with empty fields, fill them in, submit the entry to the current database, update it and make that row unavailable for other users as the 1st stage is to get the whole table filled in and only then to validate answers.
I’ve done most of this locally apart from updating the database part and then deploy it.
My question is: Given that my Shiny app would be published online, when the user updates the table in question, how could I then retrieve this new table after all of this user input? And can multiple users work on the same shiny app simultaneously? These questions make me unsure on how to deploy this [i.e. which platform] or even if Shiny is the right way to do this.