Multiple Selection Reference Field

Hi,

Is it possible to have a reference field that allows multiple select?

For example, in my tasks table, I have a field for assigned to, which links to a staff table, and want to be able to select multiple staff.

Possible? Had a quick look around the editor and on the forums and couldn’t find much.

I’ve had a look through this but was unable to find the exact answer I was after, I found a sample app below, which does what I need, allows for an Enumlist where multiple entries from a referenced table can be selected by using a EnumList Type, Base type set to Ref and a section called Base Type Details where the referenced table is selected. However, I was unable to replicate this in my app, the Base Type Details is not visible in my view.

You have to save the app after selecting EnumList and setting the type to Ref, then you can set the base type table.

First set the Type to EnumList, then set Base Type to Ref. Then SAVE!

It will give an error because you couldn’t set the table before but now you can. See Referenced Table Name. It’s been like this as long as I’ve been using AppSheet. I don’t understand why they make it a two step process.

4 Likes

Thank you so much @Lucinda_Mason! That’s extremely helpful, I’ll try this tonight. Never considered saving the app to see if it allowed for me to complete this process. Thank you.

2 Likes

I am having one issue with this method. In my tasks view, I have three columns that reference my staff table, and these are ‘task by’ ‘assigned to’ and ‘completed by’.

I have attached images of each, for some reason. As I progress through the fields, I seem to loose an option each time. Can anyone suggest why this might be?

Hi @Lucinda_Mason,

Thank you for your solution.

Once that relationship is established using EnumList and Ref as the base how would go about (de)referencing it given the result for each record is a cell containing multiple related key values as text.

Using the Tasks to multiple Staff example from David2 how would you display related tasks for a given staff member? A virtual column on the Staff table with a select() against matching values in the column or something else?

RefRows complains about column types and I’m wondering how well supported this column / relationship type is within AppSheet.

1 Like

I notice on a few things in Appsheet, that you can’t complete a whole section in one ‘save’ - this example being perfect. We choose a ref base, save (knowing we’ll get an error), so that we can then see the next box needed to save without an error.
Are there any plans to remove these additional steps?

1 Like