how to show the mobile number with country code

I want to combine values of two table columns and show them in the one column. how do i acheive that?

Solution:

Build a virtual column if it's a list view?

TextColumn('full_number')->formatStateUsing(fn($record) => '+' . $record->area_code . $record->phone_number)

TextColumn('full_number')->formatStateUsing(fn($record) => '+' . $record->area_code . $record->phone_number)

...

4 Replies

D2RTECHOP•11mo ago

Basically need to concatenate both of them and prefix them with a + sign kindly help

justlasse•11mo ago

How are you storing them in the db or model?

Solution

toeknee•11mo ago

Build a virtual column if it's a list view?

TextColumn('full_number')->formatStateUsing(fn($record) => '+' . $record->area_code . $record->phone_number)

TextColumn('full_number')->formatStateUsing(fn($record) => '+' . $record->area_code . $record->phone_number)

D2RTECHOP•11mo ago

country code and mobile number are store differently in the db table this worked 🙂