Level 75
In laravel there have been post and replies of how to do it. So maybe you could get a few ideas of how it's done in laravel and or eloquent. I suspect then it would work for nova.
Dec 4, 2018
11
Level 36
Populate Select field from database
Is it possible to get data from the dabase and populate a select field with them?
Whatever i tried so far, it didn't work, ie i do get the data but Nova doesn't exept them, it doesn't like the format or whatever. I'm pretty clueless right now.
Just wanted to ask whether it's possible at all before posting a snippet for possible help from you guys.
Level 36
No problem with 'pure' Laravel, @jlrdw just Nova seems not to like me in that case
Level 75
Link what you need to a laravel routine. Nova was meant as an admin panel to sit on top of Laravel, so just use the two together as needed.
In other words don't try to do everything in nova, that's not the intent of Nova.
Also see https://laracasts.com/series/laravel-nova-mastery/episodes/3
Nova uses laravel resources, nova is a front to have actions to do certain things with laravel models, etc.
Level 36
i guess i found it out meanwhile
Level 2
@frezno can you share your solution? I try to do something similar.
Level 36
sure thing, @vlachos - you have to use pluck() for collecting the data.
Level 2
I use this package https://novapackages.com/packages/epartment/nova-dependency-container and try to find a solution. I want when i choose a value from top, populate prefill data to nested field. I try pluck()
Level 36
i don't use any package, @vlachos so i'm not sure whether that's the same approach the package guys use.
Anyways it should look somewhat like this:
Select::make('User')->options(\App\User::pluck('name', 'id'))
8 likes
Level 21
This is a great reply! I too searched for this a while back and @frezno post was spot on.
Level 9
Laravel 6 with Nova 2 seems to require a slightly different approach.
Using a model Type, I had to do the following to get the Select menu to populate with the values from the table:
Select::make('Type')->options(function () {
return array_filter(Element::pluck('name', 'id')->toArray());
}),
1 like
Level 7
@patgilmour worked. Thanks!
Please or to participate in this conversation.