I get the ID number in the column and not the name

Yurikaso · 2023-10-08T23:46:32.096Z

I don't understand why I get a value in the select but not in the table.

D

DrByte•10/8/23, 11:48 PM

That's because your Edit form Select field is looking at the relationship, but your table is looking only at the ID column.

Y

YurikasoOP•10/8/23, 11:49 PM

Hello love again ! I'm new at this and I would like to learn

Y

YurikasoOP•10/8/23, 11:50 PM

How do I fix it? jeje

D

DrByte•10/8/23, 11:50 PM

Please post the code of your Form

Y

YurikasoOP•10/8/23, 11:53 PM

I added the database tables, but it's very simple really

Y

YurikasoOP•10/8/23, 11:57 PM

and the model, but I have no idea jejejej

D

DrByte•10/9/23, 12:00 AM

In your $table, instead of

::make('contacto_id')

::make('contacto_id')

::make('contacto_id')

::make('contacto_id') try

::make('contacto.nombre')

::make('contacto.nombre')

::make('contacto.nombre')

::make('contacto.nombre')

Y

YurikasoOP•10/9/23, 12:04 AM

does not work this error is displayed

Y

YurikasoOP•10/9/23, 12:05 AM

and this is how it appears in the database

D

DrByte•10/9/23, 12:09 AM

In your Ordenes model you might need to be specific about the HasMany relationship column names. Perhaps this:

    public function contacto(): HasMany
    {
        return $this->hasMany(Contactos::class, 'id', 'contactos_id');
    }

    public function contacto(): HasMany
    {
        return $this->hasMany(Contactos::class, 'id', 'contactos_id');
    }

    public function contacto(): HasMany
    {
        return $this->hasMany(Contactos::class, 'id', 'contactos_id');
    }

    public function contacto(): HasMany
    {
        return $this->hasMany(Contactos::class, 'id', 'contactos_id');
    }

Y

YurikasoOP•10/9/23, 12:14 AM

now comes out blank

D

DrByte•10/9/23, 12:17 AM

I don't think this is a Filament problem. It's with the relations you've set up in Laravel. I think you're not using the column names that Laravel expects as defaults, and therefore you need to manually specify the custom column names in your HasMany/BelongsTo/etc relations

D

DrByte•10/9/23, 12:17 AM

What's the schema for your Contactos table?

Y

YurikasoOP•10/9/23, 12:21 AM

Y

YurikasoOP•10/9/23, 12:22 AM

there are the db table, the model, and the resource

D

DrByte•10/9/23, 12:35 AM

Tip: in future, please post code in code tags, not as images. It's impossible to copy/paste your code from an image, which means it's not easy to test it out or to post it back to you with corrections. To post code you can use the same markdown syntax as for github etc: three backtick symbols on their own line, at the beginning of your code, and then after your code three more backtick symbols on their own line. You'll see in Discord that it'll immediately show you how it's treating it as code.
I think there's more explanation of this in the #

┊rules section.

D

DrByte•10/9/23, 12:35 AM

Now, that aside, lemme explain what Filament is doing, based on what you've posted so far:

D

DrByte•10/9/23, 12:36 AM

Explanation: Back in your first post you said that your table is showing the ID numbers. That's because your $table definition is directly displaying the

contacto_id

contacto_id

contacto_id

contacto_id,

vehiculo_id

vehiculo_id

vehiculo_id

vehiculo_id, and

servicio_id

servicio_id

servicio_id

servicio_id data from your

orderes

orderes

orderes

orderes table. It's just reading the table data directly and displaying it back to you.

D

DrByte•10/9/23, 12:37 AM

But you want it to display the name that's in the db table defined by the Model's relations.

D

DrByte•10/9/23, 12:39 AM

Your

orderes.contacto_id

orderes.contacto_id

orderes.contacto_id

orderes.contacto_id field corresponds to your

contactos.id

contactos.id

contactos.id

contactos.id field, so your Laravel relation inside the

Orderes

Orderes

Orderes

Orderes model must define a relationship.
I think the correct relationship here (in the Orderes model) should be BelongsTo, not HasMany

D

DrByte•10/9/23, 12:40 AM

So, in Orderes, you need:

    public function contacto(): BelongsTo
    {
        return $this->belongsTo(Contactos::class, 'contactos_id');
    }

    public function contacto(): BelongsTo
    {
        return $this->belongsTo(Contactos::class, 'contactos_id');
    }

    public function contacto(): BelongsTo
    {
        return $this->belongsTo(Contactos::class, 'contactos_id');
    }

    public function contacto(): BelongsTo
    {
        return $this->belongsTo(Contactos::class, 'contactos_id');
    }

D

DrByte•10/9/23, 12:41 AM

And then in your $table, instead of

contactos_id

contactos_id

contactos_id

contactos_id use

contacto.nombre

contacto.nombre

contacto.nombre

contacto.nombre so that it looks to the contactos table for the nombre column. ("contacto.nombre" means "look in the Orderes model for the contacto() relationship, which points to the Contactos table, and retrieve the "nombre" value based on the "contactos_id" from the orderes table)

YYurikaso I added the database tables, but it's very simple really

D

DrByte•10/9/23, 12:45 AM

I think it's just that you had the wrong relationship type defined.

Y

YurikasoOP•10/9/23, 12:50 AM

ok I'll try to fix it thank you very much

Y

YurikasoOP•10/9/23, 1:53 AM

´´ <?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Factories\HasFactory;

class Ordenes extends Model
{
use HasFactory;

protected $fillable = ['contacto_id', 'vehiculo_id', 'servicio_id', 'fecha', 'estado', 'comentario'];

public function contacto(): BelongsTo
{
return $this->belongsTo(Contactos::class);
}

public function servicio(): BelongsTo
{
return $this->belongsTo(Servicios::class);
}

public function vehiculo(): BelongsTo
{
return $this->belongsTo(Vehiculos::class);
}
}
´´

Y

YurikasoOP•10/9/23, 1:53 AM

there is the solution thanks

D

DrByte•10/9/23, 2:21 AM

Excellent!

Solution

D

DrByte•10/9/23, 2:23 AM

Can you also mark this thread as solved? Right-click on the post that is the "correct answer", and choose "Apps->MarkSolution".
That helps people know which posts are "done" vs which ones "still need help"

C

cheesegrits•10/10/23, 12:45 AM

Another thing I will add about screenshots of code is that some of us are old farts (OK, me, I'm an old fart) and I literally cannot read the code in screenshots, without opening the image in a browser and zooming in on it. Which I can't be arsed to do. So I don't help people who post screesnshots of code.

Ccheesegrits Another thing I will add about screenshots of code is that some of us are old fa...

D

DrByte•10/10/23, 12:48 AM

Oh Hugh, you're really still just 29 at heart!

I get the ID number in the column and not the name

Similar Threads

Similar Threads

Similar Threads