When you use select from another sheet, it opens up the whole sheet, even if you only need one or at most a few fields to select a record.
I would love to be able to select which fields to display on the listing page during a “select from other sheet” event and be able to make the “drop down” as small as possible.
What I am currently doing to circumvent this, is to duplicate the sheet. Then only display 1 to 3 columns just enough to identify the correct record for selection. It looks more professional and loads much faster during the selection process, though it is still way too large for a just a selection list or lookup table.
It works, but is neither elegant nor efficient. I would really appreciate this if you can look into this in future versions.
Kind regards and still loving Ragic!