Shiny Contest Submission: Table Editor Shiny App

shiny
21

WOW... @Jiena this is exactly what I am seeking for data entry fields.

Any suggestions for read/write data connectivity to Google Sheets?

I posted a previous message in another post reply.

Thank you.

22

Thanks! Maybe "googlesheets" R package can help! https://cran.r-project.org/web/packages/googlesheets/index.html

23

Thank you, have been reviewing that one: https://cran.r-project.org/web/packages/googlesheets/vignettes/basic-usage.html

Would you know how to set focus to a data table rows when the shiny app starts?

24

Thanks for this, new to the R / Shiny community and this will help with the current project at hand :smile:

25

Hi Jiena,
I have two questions
1, Is there anyway to upload a list with determined columns rather add one by one?
2, Can 1 column (for example Comments ) be automatically update base on conditions?
Thanks

26

I'd love to hear from you how "table editor app" handle 2 or more users editing the same object at the same time. Thank you for sharing this great app

27

Hello Jiena, thanks for posting your code!

I am trying to modify your code such that in the "edit" button, the fields are not simply numeric or text entry, but a dropdown from a predefined list. I see you loop through colnames, but could you have a dropdown list that is dependent on individual column names? Any help would be appreciated

28

Hi AliMans,

Sorry for my late reply. This is a very good suggestion. I just loop through colnames for current version and I will try to put this feature in in the next version. :slight_smile:

Thank you so much for your suggestions!

Best Regards,
Jiena

29

Hi Guimes,

Very good question! When two users edit the DT editor at the same time, the one who clicks "save" button faster will win because the Save button is to update the edited data.table to the backend. :slight_smile:

Best Regards,
Jiena