Customize address_google Column and save values into multiple rows in DB

[sandeepchowdary7]

Hello guys,

Here is the form field I'm using in my project. so using Google Maps API and auto-filing the address. so now I would like to save these address values into multiple rows in the database. i.e. city -> city DB column, zipcode -> zipcode DB column, state -> state DB column etc.. Any inputs would be great. Thanks!

[
    'name' => 'address',
    'label' => 'Address',
    'type' => 'address_google',
    'tab' => 'Primary Details',
    'store_as_json' => true
]

[tabacitu]

Hey @sandeepchowdary7 ,

Personally I'd use a Laravel Mutator for that. In my Model I'd have something like:

public function setAddressAttribute($value) {
   $this->city = $value['city'];
   $this->street = $value['street'];
   // etc
}

Hope it helps!

[sandeepchowdary7]

Hello,

I was doing like this but no luck

//Controller

[
    'name' => 'address',
    'label' => 'Address',
    'type' => 'address_google',
    'tab' => 'Primary Details',
    'store_as_json' => true
]

//Model

 public function setStreetAttribute($value) {
      dd($value);
      $this->city = $value['city'];
      $this->state = $value['state'];
      // etc
  }

any help why it is not working in this case?

[sandeepchowdary7]

woked! Thanks!