inter-dependent pulldowns in excelr cells

[pi-at-git]

Hello! You describe how to create pulldown menus in cells. In my use case I'd like to create a table with a single row where the available choices in a pulldown of cell B1 depend on the actual selection in a pulldown in cell A1. Intention is to replace multiple selectize-items with a single ecxelr item.

More concrete:

• assume pulldown in cell A1 contains choices c("A001", "A002", "A003")
• while nothing is selected from cell A1, the pulldown in cell B1 is empty
• upon selection of "A001" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B001", "B002", "B003")
• upon selection of "A002" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B004", "B005")
• upon selection of "A003" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B006", "B007", "B008", "B009")

I made some attempts with excelr but my outcome so far looks quite complicated. Do you happen to have some advice for this?