I am constructing a simple DT to collect data using DTedit, in a table like this:
| DAY | SHOP | CHEAP_PROD | EXP_PROD |
|---|---|---|---|
| day1 | shop1 | prod1_1, prod1_2 | prod1_4, prod1_5 |
| day1 | shop2 | prod2_1, prod2_3 | prod2_4, prod2_5 |
| day1 | shop3 | prod3_2, prod3_4 | prod3_3, prod3_6 |
| day4 | shop1 | prod1_2, prod1_5 | prod1_1, prod1_9 |
So, on a given DAY, a SHOP is visited and the CHEAP or EXPensive PRODucts are recorded.
There is a second (aux) table available, stating the available PRODucts for each shop:
| SHOP | PRODUCTS |
|---|---|
| shop1 | prod1_1, prod1_2,prod1_3,prod1_4 |
| shop2 | prod2_1, prod2_2,prod2_3,prod2_5 |
| shop3 | prod3_1, prod3_2,prod3_3,prod3_6 |
So, ideally, whenever a new entry window is called, the choices for the EXP_PROD and CHEAP_PROD columns should be selectInput(..., multiple = TRUE), and the choices should depend on the SHOP selected for this given entry (ie retrieved from the 2nd Table).
Is this possible??
thank you!