Adding Brands a User can see? eg. tags from database saved as pivot table

The feature is: A User can see only certain Brands and this is specified by Laravel Nova.

User UserBrand (pivot table) Brand

How would you use Laravel Nova to multi-select and edit a Users relationship to Brands?

Anyone have any suitable suggestions?

This package allows you to add multi-select fields to Laravel Nova: https://github.com/optimistdigital/nova-multiselect-field

However, it saves the data as JSON data. Is there any way to use the database to utilize the Pivot table and save the data accordingly or is that unreasonable?

bobbybouwmann

6 years ago

Level 88

First of all, you say a user can only belong to one brand. You don't really need a many-to-many relationship here, s one-to-many would do just fine.

Since you have a many-to-many relationship, this package should help you out to manage it in Nova: https://novapackages.com/packages/everestmx/nova-belongs-to-many-field

joshsalway

6 years ago

Level 21

Thanks @bobbybouwmann for the advice.

joshsalway

6 years ago

Level 21

With this package. It saves it as a JSON data into a Text, String or VarChar.

In order to keep the database the same.

This package saves the data like this:

| ID | user_id | brand_id | |----|:-------:|---------:| | 1 | 1 | [1,2] |

However, I need to save the data like so:

| ID | user_id | brand_id | |----|:-------:|---------:| | 1 | 1 | 1 | | 2 | 1 | 2 |

Any suggestions on how to do so?

Please or to participate in this conversation.