Hi, Jose

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

In the Data tab, the values that we predefine, are values for filtering, and editing.

They are not going to determine how many values will be pulled in the cells.

You can see more details about this on this documentation page;

in the Foreign keys in advanced filter section:

So, I am not sure I understood what you mean.

Can you please elaborate a bit more,

do you mean for the filtering values for this column;

or the actual values in the cells?

Thank you

Hi, Jose 

You are correct.  It depends on exactly what you need to do.

If you need editing as , for example - multiselectbox,  where we can add multiple values together in a cell;

in that case, that is not possible with foreign key column.

-

I will show both examples, first of editing a Manual table with multiselectbox, without a foreign key column.

If I had a table like this :

And if we wanted to use a multiselectbox for editing the first row of column "Column one":

Then we would be able to choose multiple available values, and add them together in same cell during editing:

-

But, if we use a column configured as a foreign key, in that case  we are limited to only choosing a Single-value selectbox , since the options are limited with respect to what the remote table contains,

as it is pointed out on the documentation.

-

So, the only workaround I can see, for your use-case;

if you have the other table that will hold all the available languages;

but also if you add a "combination of languages" in a cell;  it will be considered as one "value".

For example - 

here I made a random text table,  and added a column "Languages",

then I created some combination of values :

If I now make a new table, and connect a column to this one, as foreign key;

-

Then, if I edit, or add new row, in that foreign key column - it will load all the possible values from the original table column ( only available as a single-value selectbox) :

-

So, there might be a workaround like this - but I am not sure if that will be ideal for your use-case.

Let me know if that makes sense, I hope it helps.

Thank you

Hi, Jose 

I can completely understand what you mean;

for that kind of use-case when there are so many possible values, it is not a good workaround.

I did my best to try to come up with any alternate solution - but at the moment, as you can see,

since it is not possible to use multiple value selectbox for foreign key columns;

we can't change that logic currently.

-

Please don't hesitate to open new tickets for any new/unrelated questions, and we will answer as quick as possible.

-

If you'd like to see a solution for what you need in the future, you can make a suggestion for our developers.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.