How can we achieve a list of value picker from a different screen not from the default selection drop down lists. Lets say we have a very simple database:
1.) Users (email, password)
2.) Items (name, article number)
3.) UserItems (user, item)
User 1:n UserItems
The user can buy items, these items are stored in the UserItem collection. He must choose the item from a huge list of 10.000 items. That is not practicable with the normal drop down selection from Adalo out of the box.
The user should go to a screen where he can search of an item, pick that item and the selected item should be returned to the UserItem screen.
At the moment I can only imagine to build an item collection with unique keys for every item. Is there a better way?