...
Each option in the spreadsheet is a list of data from another form with an option binder configuration. This tutorial will guide you step by step on configuring the Spreadsheet Form Element for this use case.
...
1) Enable the Handsontable instance
Enable the handsontable Handsontable instance to be interactable by pasting the following code into the html elements from form builder > spreadsheet configuration > UI > Custom Settings (JSON)' (See Figure 2)
...
Figure 2: Enable handsontable instance
...
2) Add a Javascript in the Custom HTML
Add a Custom HTML form element in the form and use the following Javascript code to dynamically adjusts the content of the "Continent" dropdown menu based on user edits in the table. It removes values from the dropdown if they are edited to be non-empty and adds them back if they are edited to be empty.
...