Cents on DB how to show in money?

I have a column "price" datatype INT I'm storing my prices in cents, eg: 1658460 My form looks like this:

Forms\Components\TextInput::make('price')
  ->mask(fn (Forms\Components\TextInput\Mask $mask) => $mask->money(prefix: '£', thousandsSeparator: ',', decimalPlaces: 2, isSigned: false))
  ->required(),

Forms\Components\TextInput::make('price')
  ->mask(fn (Forms\Components\TextInput\Mask $mask) => $mask->money(prefix: '£', thousandsSeparator: ',', decimalPlaces: 2, isSigned: false))
  ->required(),

How can I have my form show £16,584.60 and not £1,658,460.00, somewhere I need to divide the price by 100, where/how? Thanks.

Solution:

The solution here https://filamentphp.com/docs/2.x/admin/resources/viewing-records#customizing-data-before-filling-the-form...

Filament

Viewing records - Resources - Admin Panel - Filament

The elegant TALL stack admin panel for Laravel artisans.

Jump to solution

1 Reply

Solution

Pablo Torres•17mo ago

The solution here https://filamentphp.com/docs/2.x/admin/resources/viewing-records#customizing-data-before-filling-the-form

Filament

Viewing records - Resources - Admin Panel - Filament

The elegant TALL stack admin panel for Laravel artisans.

Gaming

Programming

Cents on DB how to show in money?