(Multiple) Select from other sheet?


#1

Is there a way to make a MULTIPLE SELECT from other sheet?
Thanks,
Germán


#2

You will need to use subtable fields to achieve it.


#3

Thanks for your answer Amy, I will ask for it as new feature request. It seems important to me.


#4

Is there a workaround? Maybe use a subtable field that is populated by the other sheet using link & load?


#6

That’s what I suggested in the previous reply.


#7

Ok, yes, and thank you for that instruction :slight_smile:
Still, I am wondering if link and load is the best way of populating the subtable with values from the other sheet?


#8

It would depend on your initial needs. (with an actual example.)
Feel free to share detailed information regarding what you would like to achieve so we can point you out to the right direction.


#9

Hi,

We just release this “multiple select form other sheet” feature. Now when you set the field type as “Select from other sheet”, you can find the “Multiple select” check box (in the Design mode):

Please note that we don’t support “loaded fields (loading corresponding values)” when you multiple select form other sheet. Hence, if you’ve already created a link and load relationship and then change the linked field to “Multiple select” type, the system will remove the link for those loaded fields .(the grey line in the link manager will be removed, but the field values which have been loaded from the source sheet will not be deleted).


#10

Such a great news. It saves so much trouble.


#11

Great feature! But this voids the Dynamic filter - the conditional selection which worked for the single select from another sheet does not work in the multiple select mode.

Now the select drop down includes all the records from the other sheet, while i need it to show just the filtered ones.

Please add the dynamic filter to the multiple select from another sheet. Thanks!