Help with forms - change address to save into multiple google sheet cells

Site URL: https://www.megacreative.com.au/order

Hi all,

Hoping for some help. Is there a way to:

1. Have the address fields in the form block save into multiple cells in google sheets instead of merged into one cell? I.e. a separate cell for address 1, address 2, city, state/province, zip/postal code and country.

2. In the address form block change city to suburb. 

47 minutes ago, MegaCreative said:

Site URL: https://www.megacreative.com.au/order

Hi all,

Hoping for some help. Is there a way to:

1. Have the address fields in the form block save into multiple cells in google sheets instead of merged into one cell? I.e. a separate cell for address 1, address 2, city, state/province, zip/postal code and country.

2. In the address form block change city to suburb. 

Use css to change the form label

[x-autocompletetype="city"] + .caption-text {
  visibility: hidden;
}
[x-autocompletetype="city"] + .caption-text:after {
  visibility: visible;
  content: 'Suburb';
  position: absolute;
  left: 0;
}

Regarding to question 1, you can not change how the address submitted, so either you split the data use spreadsheet formula or use individual text fields to collect the values

Thank you! Where do i paste the css?

All good - I figured it out. 

Is it possible to remove 'address 2' field from the form? 

It can be removed visually from the form. But not from the data being stored.

Add the following to Design > Custom CSS.

.form-wrapper .field-list .address2 {

  display : none;
  
  }

This is for v7.1.

Let us know how it goes.