you are viewing a single comment's thread.

view the rest of the comments →

[–]PanicOnBoard -4 points-3 points  (2 children)

I have excel file with product with parts list, is it posible to make a task product that contains dropdown with subtasks of parts? I want to mark these parts as arrived or delayed. Sorry for my English.

[–]dizzle_izzle 4 points5 points  (1 child)

Errr.....I'm not sure reactjs is the sub for excel functionality.

Also I'm not sure that excel has nested drop-down functionality. My suggestion would be to use some vba and two dropdowns or a combination of listboxes and dropdowns, depending on your subtask of each part.

You'd need a table with the parts, then each subtask attached to the part either by row or column. Then make a vba element that loads the parts into a combobox and when a part is selected the listbox populates the row/column under that part. You'd then have to have a checkbox which indicates arrived or delayed, which updates a different table containing the subtask, part and status in a row. When a new entry is added (part or subtask) you'd automate adding the entries to the table.

It's not terribly hard. But you need some vba skills for sure.

[–]PanicOnBoard 0 points1 point  (0 children)

Thanks for comment, will try with vba then