Lookup with a multiple select

Hello,

I hope you are fine.

I need to do a lookup on a linked table to get multiple selections saved in the linked table.

I can’t do it using the Lookup type maybe a formula one?

Hello @ozzz, the lookup type should work in your case :thinking:
Maybe we’re missing some details, could you please share some further explanations on what are you trying to do?

Hey @ozzz,

Would also like to hear more about what you’re looking to accomplish, as Olga asked above. However, in the meantime, I would recommend that you take a look at the Personal Health Template, which has links to tables as well as the lookup function in the formula field.

Not 100% sure, but something tells me this might be what you’re looking to accomplish. Give it a glance and let us know.

Hello,

I have a table with multiple choices.

This table is link to another table.

I would like this other table to display the multiple choices from the first table.

It doesn’t seem to be possible.m right now as the multiple choices filed doesn’t appear in the rollout field menu.

I changed my multiple choices by table.

But just so you know

Hmm… not entirely sure what you mean by “rollout field menu” here. Are you referring to a “rollup” field instead? And if so, are you importing from Airtable by chance?

If you could provide some screenshots or GIFs, that might help us out. :slight_smile:

Hey @ozzz, you’re right — unfortunately, the Lookup field doesn’t support Multiple Select field type yet. As well as the formula field function ‘Lookup’, they both only support the Single Select field type.

Let me check with the development team if we can get this feature done. I’ll get back to you with the news shortly :blush:

Hello @hiram, I guess @ozzz meant that when you use the Lookup field type it rolls you out tables and fields that you can link, and in this case, it doesn’t show fields that have Multiple Select, because Baserow doesn’t support looking up the Multiple Select field type yet.

2 Likes