AppGini Community Forums

Hi, I've been looking for a 'Multi select dropdown' option to use data from another table. Only from one table.

Is there a solution for this as yet?

I've seen it can be manually added from the 'Option List' but I do require it dynamic from another table > field. Please let me know if possible or via a paid plugin?

Regards,

Hi,

maybe this helps you as a starting point.

https://bigprof.com/blog/appgini/a-work ... gini-apps/

Hi, thanks I had seen that. I'm not sure how this can help though. For example, let's say I have a field in a table called 'Items' and I can add new 'items' from Appgini, then in another table I link the 'Items' into a select field. It will only let me select one 'Item' - rather than multiple. So are we talking the same thing here. Thanks.

Well, where is your problem?

You use your 'items' from your second table and populate the "firsttable.multiselectfield.csv" file on insert/update/delete from your second table. The tags table in the blog is your second table and the tag field is your items field.

In your first table your create the multiselectfield not as lookup field, but as option list.

If you add to code to an existing installation you should either update an existing record in the second table, or create the "firsttable.multiselectfield.csv" manually with all options.

As written in the Blog there is some addtional work to do in order to keep data consistend.