Use relationship from one column to another column

[rubensrocha]

I have the following situation: I need to use the value of a relationship that belongs to one column to format the value of another column.

Builder:

public function builder(): Builder
    {
        return Deposit::where('user_id', auth()->id())->with('currency');
    }

Relationship column:

Column::make("Currency", "currency.code")
                ->sortable()
                ->searchable(),

Column I need to format:

Column::make("TXID", "tx_id")
                ->sortable()
                ->searchable()
                ->format(function($value, $row, Column $column) {
                    if(isset($value)){
                        return '<a href="'.custom_function_here(XXXX, $value).'" target="_blank">'.$value.'</a>';
                    }
                })

Where is XXXX, I need to get the relationship value from currency->url.

How do I get the value of this relationship to be able to format this column?

[rubensrocha]

I found a solution:

public function builder(): Builder
    {
        return Deposit::where('user_id', auth()->id())->with('currency')->select('currency.url as url');
    }

Column::make("TXID", "tx_id")
                ->sortable()
                ->searchable()
                ->format(function($value, $row, Column $column) {
                    if(isset($value)){
                        return '<a href="'.custom_function_here($row['url'], $value).'" target="_blank">'.$value.'</a>';
                    }
                })