Jump to content

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

Recommended Posts

  • Replies 5
  • Views 566
  • Created
  • Last Reply
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

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!

 

Link to comment

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.

Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.

Link to comment

Archived

This topic is now archived and is closed to further replies.


×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.