This is a very long long-shot, but here goes. I'm working on a Shiny app using a relational database (SQL) that contains associative tables. (The Wikipedia page lists something like 16 synonyms for "associative tables".) For instance, one table might contain unique ID numbers (integer) and names of teachers, another might contain ID numbers and names of students, and the associative table might list student-teacher pairings, with each row containing two integer ID numbers (student and teacher).
I need to display the latter table in a way that is editable. The catch is that the user needs to see names, not integer IDs, but changes have to be recorded as IDs. The names should preferably be in the form of factors, not text, because the user is restricted to existing names (and because text inputs invite typos).
I can program this from scratch if necessary, but it would be great if someone knew of an existing package that provided this functionality.
@ismirsehregal Thanks for the links. I don't think rhandsontable will work, since I don't see any indication that it supports row filtering (and I'm not sure about sorting). I tried adding sorting and filtering to your DT example but failed (although I need to go back and make sure I set the options correctly). Unfortunately, in your DT example search is a bit spotty; it works for "static" columns but not for columns served up as drop-down lists. So a search for "Sample2" limits you to records with Sample2 or Sample20 in the "Sample" column, but a search for "Treated" does not remove any rows, I assume since it appears in the drop-down list in every row.
I'll dig into the DT example a bit more and see what I can do with it. Again, thanks.