Create dynamic columns in exporter

[iamaks1993]

Package

Panel builder

Package Version

3.2

How can we help you?

I want to create dynamic columns based on record relation. Eg. If i am exporting a data of users then i want to show First name, Last name etc then how many course he completed which will comes from relationship and i want to show all this in different columns.

I tried to access protected ?Model $record; from exporter in public static function getColumns() method but not succeed. Could you please help?

class AttendeeWithCourseExporter extends Exporter 
{

      public static function getColumns(): array
          {
      
              $columns = [
                  ExportColumn::make('id')
                      ->label(__('TN ID')),
                  ExportColumn::make('full_name')
                      ->label(__('Full name')),
                  ExportColumn::make('first_name')
                      ->label(__('First name')),
                  ExportColumn::make('last_name')
                      ->label(__('Last name')),
                  ExportColumn::make('birthday')
                      ->label(__('Date of Birth'))
                      ->getStateUsing(fn ($record) => $record->birthday?->format('d/m/Y')),
                  ExportColumn::make('birthplace')
                      ->label(__('Place of Birth')),
               
              ];
      
              $dynamic = [
                  ExportColumn::make('certificate_unlocked_at')
                      ->label(__('Date of issue'))
                      ->getStateUsing(fn ($record) => "Hellow"),
              ];
      
              return array_merge($columns, $dynamic);
          }
}

[Willy-Bueno]

Did you find any way to add dynamic columns?