Employee Directory editable DT
Authors: @noveld
Affiliations:
Abstract: An application to easily look-up employee details. Within the application users can enter, edit and delete entries as well as upload and change their profile image. Entries are stored on the server using a SQL database.
Full Description: The table was made using the DT package. Shinyjs, shinyBS and shinyalert were used to make the different pop-ups. The SQL database was set-up and interacted with using the DBI and pool packages.
A .tar file with all deposited images as well as an excel file containing all entries can be downloaded using the Login (user: admin password: SHINY2020)
Note: The app is deployed on Shinyapps.io which does not support local file storage and therefore entries will reset after a while. It will run normally when you set up your own Shiny Server.
For a minimal example on how to integrate the Editable DataTable using SQL see the below post:
Table Type: interactive-Shiny
Submission Type: Other
Table: https://niels-van-der-velden.shinyapps.io/employee_directory_crud_app/
Repo: https://github.com/nvelden/Employee_Directory_CRUD
RStudio Cloud: https://rstudio.cloud/project/922601
DT package used: true
gt package used:
reactable package used:
flextable package used:
huxtable package used:
kableExtra package used:
Other packages:
.