How to auto fill Google form with multi drop list from google sheet data
I have two table data with one-to-many relationship:
- department (D1 , D2, D3...)
- class (C1, C2, C3...) In google form, i have 2 drop list for 2 object. I want when user select one department on drop list 1, drop list 2 will auto fill all class of department on drop list 1. Please help me, many thank