2 Newletter block questions

I have Newletter block questions:

#1. With the "Storage" --> "Additional Storage" --> "Google Drive" is it possible to save the spreadsheet in a specific folder? For Instance, I would like to save the spreadsheet in the folder "NL" with a spreadsheet name of "NewsLetter". How can I do this?

#2. Is it possible to change the name of the fields which are saved in the spreadsheet? I have two form fields in my Newsletter block named "email requis" and "message optionnel". Can I have them stored in fields named "email required" and "optional message"? How can I do this?

Thanks,

You can sort the Google Sheet into whatever folder you need after it has been created by connecting the form to Google Drive. If you change the column titles in the Google Sheet, I believe that it will create new columns when data is added. You can always test this be creating a new form and connecting it then make the changes you want and see what happens when submitting a form.

Hey Ziggy,

Thanks for the tip for #1. I moved the spreadsheet to the folder I wanted and it got updated properly.

As for #2. I not sure what you're saying.

I have 2 pages for the newsletter signup, one in English and one in French . The spreadsheet columns are:

submitted on    
name    
email required
email requis    
optional message    
message optionnel    
   

The English page has form fields "email required" and "optional message".  And that's where the submitted info goes.

The French page has form fields "email requis" and "message optionnel".  And that's where the submitted info goes.

So how can I make the French page use the  "email required" and "optional message" columns without changing the form field names?

Thanks,

-Norm

2 minutes ago, ScooterNorm said:

So how can I make the French page use the  "email required" and "optional message" columns without changing the form field names?

You can't really, the only way would be to make the text the same, and then use CSS to change the text to French, which is generally a bit fiddly.

It would not be a problem to make the fields the same.

Can you help me with CSS code? I'm not an expert but I've done some stuff with CSS code.

Thanks,

It would involve hiding and replacing the titles on a specific form. You'll need to change the form fields to be in English and identical to the other form, and then we can replace them with code.

Yes I understand. Can you help me with what the CSS code would be?

Thanks,

-Norm

Can you share the page?

Here's the link to our page. https://brass-porpoise-7wff.squarespace.com/french/contact-new3

The current CSS code is:

<style>
.form-block .name .title {
    display: none;
}
</style>

<style>
button[aria-live="polite"] span.form-submit-button-label {
    font-size: 0 !important;
}
button[aria-live="polite"] span.form-submit-button-label:before {
    content: "Soumission";
    font-size: 16px !important;
}
</style>

We would like the following changes:

"First Name" to be "Prénom (requis)"
"Last Name" to be "Nom de famille (requis)"
"Email (required)" to be "E-mail (requis)"
"Subject (required)" to be "Sujet (requis)"
"Message (required)" to be "Message (requis)"

Thanks,

-Norm