How to build a table with cells depending on each other?

Tags: #<Tag:0x00007efc6cf6e450>
#1

Hi,

I’m trying to build a 4 columns Handsontable. The first is a date, the second, third and fourth are entities label:

  • date
  • formation
  • course
  • topic

The behavior I try to achieve is:

  • with date and formation already selected,
  • course is a dropdown containing all courses + topics filtered by the previously selected formation (using handsontable cell type is allowing me to show both course and topic)
  • when user select a row (course + topic) in the dropdown, the course cell is set with its label and the topic cell is set with its label

The two behaviors I struggle to make work are the data filtering in the course dropdown and the automatic topic cell filling. What would be the best approach?

#2

Hi @LucileDT

Can you please prepare a demo (preferably in jsfiddle) so we can visualize how it should look like? It looks like it’s a pretty custom case so that would help a lot.

#3

Hi @LucileDT do we have any updates on this report? Do you still need help with this topic?

#4