What it the limitation when using form logic to show dropdown lists?
We have a case where a form is being used by managers to enter info about their direct reports. In the sheet, there is one column of direct reports for every manager. When the manager selects their name in the form, logic causes a new field with all their direct reports to appear as a dropdown.
We have a little over 100 managers and columns of direct reports, and the form logic seems to cap out at maybe 65? This has caused us to have one field for managers with names A-L and a second from M-Z, it makes the form a little clunky.
What limitation is driving that, and is there a better work-around?