update on this one in case someone is also stuck, here is my progress:
I managed to create a separate API that collects lists (enumeration options) for each of my columns ! I no longer have to create duplicate lists! Yay... (I had to use the Xano metadata API, which I then had to use an External API request within the GET API - and finally for the API response I set the results to an array. //I am sure there is a simpler way but now I have one API that lists every option and then I use individual select items to "filter" the one I need for THAT dropdown menu...
What is a problem now is that sometimes it works and sometimes it does not...right now it does not work so you can see the "undefined" (select>option>"undefined"). I even made the darn thing Public to avoid the headache but still no-worky.
What I did was convert the form into a container and that is when all hell broke loose. Now, I cannot go back...
on the positive side, when it was working, I managed to get the nice drop-down options but when I wanted to assign them as variables, I could not... I saw somewhere also that there were similar questions so I thought I would share mine here as well. Maybe someone sees what I don't
.jpeg/public)