Table with Hidden Columns

I’m creating a element into an lightbox to allow the user select one in various register of one table. I’m look for:

  • avoid database access (for performance reason)
  • to turn the development easier, inserting all information that the page will need into the register of the element.
    My first idea was to use dropdrow element, but I didn’t be able to setup it correctly because I didn’t understand the difference between the superior part of configure window and the other (that is, when must I use ‘connect a list’ section and how ‘List values connect to’ must be used).

So I tryied to use the table and to hide the columns that I don’t want turn visible. But setting it up I realized that haven’t hidden column option or set up the width as zero.

Someone has similar request? Someone has any workarround / trick for it?
Someone can explaine me how configure dropbox elements?

Thanks.

Hey there,

I’m not exactly sure what you’re trying to do, but it seems to me you can accomplish it by clicking the Manage Table button and deleting the columns you want to “hide”.

Hi,
Please see details explanation on how to use dropdown here .

Settings up a dropdown, you use “connect dropdown options list” toggle to tell the dropdown to display a list of options that is taken from a collection.
Then, using “connect a dataset” you set the collection the values will be taken from and “list values connect to” you set the specific field in the collection that should be used to display the options,

Thanks.

What I need is:
A. Load varios fields from collection (dsUnit) to one element in the page (dropdown - preferencially - or table);
B. Show, to users, only 2 fields (image and id) allowing to select one register of the element;
C. When the user to click in selected register, the page must fill the respective text fields

I would like to avoid the secound access to the collection for performance reason (I believe that the memory usage by the element (dropdown or table) is more eficient than the collection access, mainly if the collection has a big number of registers and fields. Is it right?)

Thinking as excel spreadsheet:
I would fill the column A with the image, B with id, C with adress 1, D with adress 2
and I would hide the columns after the B column (C,D,E, F…)

The issue about the tables is that is impossible to setup the width as zero (0). The minimal value accepted is 10 what is unaccepted for users.

Please, let me know if now is better detailed and I wait for your reply.