rdrop2 | Dropbox Interface from R | Cloud Storage library

I created the following flipped bar plot in ggplot2 (a coordinate flipped grouped bar plot in bright green) - which worked out just fine (Code 1).

However I tried to recreate the same plot structure with different data, basically copying and adapting the code from the first plot. Everything is fine, exept for the colour being grey instead of the desired green in the scale fill manual. I honestly can't figure out why it works in the first plot but not in the second. (Code 2)

CODE 1 (the working original plot)

I want to create a PNG image with a manually specified resolution in a deployed Shiny app. This PNG image should be saved in my Dropbox. For some reason, the deployed version of my Shiny app does not take the res argument within the png function into account.

Consider the following example:

I made a relatively elaborate Shiny app for my job that runs great locally. However, I am trying to host the app so that users who don't have R Studio downloaded can access it. I cannot get the app to run through shinyapps.io. It seems this is mostly related to the fact that it cannot find the files that are located on Dropbox. The app is based almost entirely on loading and writing files on Dropbox. I tried to change the file paths and use rdrop2 to load the files, but it changes the formatting of some things and would be pretty complicated to reconcile as far as I can tell. I'm very much a novice programmer and the thought of having to restructure the entire app is giving me a bit of anxiety and will certainly require a fair amount of effort. Does anyone know of a more "simple" way to modify files located on Dropbox through a shiny app hosted on shinyapps.io, preferably while still able to use the "openxlsx" package? Thank you very much in advance.

One workaround I thought might work but didn't was to make the file path to the Dropbox file specific to the user because anyone using the app should have access to Dropbox:

this.data <- as.data.frame(read.xlsx(paste("C:\Users\", Sys.info()[["user"]], "\Dropbox\rest of the file path", sep = "")))

I am making a shiny app that should download a .html file from dropbox and show it in said shiny app via a htmlOutput(). Furthermore, I have it running on a AWS EC2 t2.micro instance (with all the shiny server configurations based on this article). The problem is that my app works on localhost, shinyapps.io; but, it does not work on my EC2 instance. The app runs on Shiny Server (inside the EC2 instance).

Here is the source code (app.R):

I'm building a shiny application where I want to be able to show dynamically chosen pictures from my dropbox without having to download them. I'm using rdrop2 for most of it. Here's what I've got (shortened version).

The package rdrop2 was archived on 31/07/20 https://cran.r-project.org/web/packages/rdrop2/index.html

Is anyone aware of a good alternative to this package?

I am still relatively new at working in R shiny and I am trying to load several excel files into an R-shiny app. Part of the problem is that I need to be able to pull several files from a dropbox folder without specifying what the data file is called. So I need to be able to tell R to read in all the files from a dropbox folder. Also the files I am working with are in .xlsx format and I will need to read them into R as such.

I tried to do this first by using a folder on my computer desktop. I managed to get it to work using my local directory with the code below:

I am wroking on an shiny app as a volonteer trying to produce an app that would register all of the calls citizens have in the these times of a lockdown for a local Red Cross office. I have managed to get the entry form and to review the DT, but I need to the DT editable so I have included some code to do that.

All is working, except when I write the changes in some of the columns the app changes the column -1 (one to left), overwrites its previous entry in column -1 that I didn't wanted to edit and leaves the entry I actually wanted to edit in the column I wanted to edit (if that makes any sense). What am I doing wrong? I am pasting the code, datasets stored on Dropbox.