when I submit the form, google drive url opens stating "you don't have access". What might be the issue? (the input from the user is appended to the sheets)
Thanks for this video, I made it and it works fine .. just a small feedback in Framer, the code editor and the code text looks not like yours in the videp anymore so it could be confusing for some peoples if they are not understanding the coding at all
This needs so much more attention. Really great work, and thank you for taking your time to explain this so well!! Framer really needs to work on their forms, as those paid options are awful and are only successful because of the lack of other options. I'd like to redirect to a thank you page instead of a printed out text message. Do you know the cleanest way to do that on submit?
Thanks! This was more than useful - this saved my project! Still I have a question if I can to redirect the final page not to page with the text but to some page of my site project, so it would be fancier. I hope you will find this question interesting and useful for others to explain :) Have a good day!
Great Tutorial! congrats! What about security? How could we make the endpoint more secure to only accept requests from the framer page and not any arbitrary person?
Loved it. Thank you so much for such clear tutorial. A recent client of mine asked for UTM parameters so they could fetch the channel the page loaded from. It is usually appended in the URL. Is there a way you can teach us that too. Thanks man, still absolutely appreciate your bits. True fan of your work and journey.
Is there a way to do it the other way around.. I use a financial api to retrieve stock data in a google sheet. It’s still a goal of me to present that one day in a beautiful way on a website. But don’t really know where to start? Would it be possible with Framer maybe?
Thank you for the tutorial. I was just thinking of a way to use google sheets to collect data. I have a question though, how do I go about redirecting users to a specific page after submitting?
Please try this code, and ensure that the "Back to Home" button on the success page opens in a new browser window. This is important to prevent the Google script from lingering in the URL after form submission: function doPost(e) { var row = [ e.parameter.first_name, e.parameter.last_name, e.parameter.email, e.parameter.package, e.parameter.message, ] var sheet = SpreadsheetApp.openById('1ThoJ8RQms37wooMNjgMihLj8j2P8EvUt0UCoe3ACcNc'); sheet.appendRow(row); // Create an HTML response with JavaScript for changing the URL var htmlOutput = HtmlService.createHtmlOutput('window.location.href = "numerical-months-147179.framer.app/thanks";'); return htmlOutput.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); }
What if I wanted to style something in Figma and use the code Figma gives me to use within Framer? Seems like first I need Figma to give me React code which I think can be done using Anima. I'm not sure. Trying to figure it out. Any tips?
Hi! Thank you very much! This worked amazing. I was wondering if there's a way to implement options in this script. Like for example, asking for the gender of a person, if they could select between a set of options. Also I would like to know if there's a way to make an input optional. Like if someone doesn't want to add their Name, if they could leave it blank without framer asking for an input. Thank you so much
Your tutorial was greatly appreciated. I was just brainstorming ways to utilize Google Sheets for data collection, and your guidance was right on point.
@@AMDesignAndDev I was watching your video to see if I could figure it out 😊. My assumption is I can use the pre-filled link to get the field entries and map it to the names in your form. Like, entry.2005620554=${name}. I guess I should work it out and get back to you. But since you went this direction I was like maybe this is better.
Thank you, would like to add data in google sheet, and also framer review input data and confirmation from user, also a framer confirmation redirect screen
I tried to do it but you will get an error message from CORS policy when trying to get an answers back from the Google Script and haven't been able to solve the issue. Tried setting CORS headers on doPost and doOptions but it won't work. Would be great to have some input from @AMDesignAndDev
Hi! Thank you for the tutorial! It was really helpful! But i keep getting this message "Script function not found: doGet" when i try to execute this function. i was wondering if you could help me. 😅
Bro!
You dropped the best video for Framer
Thanks a lot for this tutorial and Hats off to you!
This is a very important topic. Can you do more videos on all of the forms and the various ways to interact with the data.
when I submit the form, google drive url opens stating "you don't have access". What might be the issue? (the input from the user is appended to the sheets)
Thanks for this video, I made it and it works fine .. just a small feedback in Framer, the code editor and the code text looks not like yours in the videp anymore so it could be confusing for some peoples if they are not understanding the coding at all
This needs so much more attention. Really great work, and thank you for taking your time to explain this so well!! Framer really needs to work on their forms, as those paid options are awful and are only successful because of the lack of other options.
I'd like to redirect to a thank you page instead of a printed out text message. Do you know the cleanest way to do that on submit?
Just use a window redirect on your success function
@@AMDesignAndDev Thank you!
@@AMDesignAndDev can you explain this in detail?
Great AM design
How can I prevent it from going to another page?
Hey AM design, is there a way to redirect submit to an actual framer page like a "thank-you" page? what should I input instead of return?
Do you have the code snippet for the Framer part?
how about multistep forms how would they work/?
i dont want to redirect to another url after successful submission,what changes should be madein code?
Thank you for the clear and straightforward tutorial!
I have a question: are these steps similar when linking to Google Forms?
how can we do reverse? from google table to framer cms or something automaticly
Thanks! This was more than useful - this saved my project!
Still I have a question if I can to redirect the final page not to page with the text but to some page of my site project, so it would be fancier.
I hope you will find this question interesting and useful for others to explain :)
Have a good day!
Great Tutorial! congrats! What about security? How could we make the endpoint more secure to only accept requests from the framer page and not any arbitrary person?
Can we pull UTM parameters into the form? That’s a must for me.
Loved it. Thank you so much for such clear tutorial. A recent client of mine asked for UTM parameters so they could fetch the channel the page loaded from. It is usually appended in the URL. Is there a way you can teach us that too. Thanks man, still absolutely appreciate your bits. True fan of your work and journey.
Is there any way to fetch data other than "text" fields? like drop-down, tel, etc? since e.parameter records just one type ig
You know if is possible send data from Framer to Active Campaign?
Is there a way to do it the other way around.. I use a financial api to retrieve stock data in a google sheet. It’s still a goal of me to present that one day in a beautiful way on a website. But don’t really know where to start? Would it be possible with Framer maybe?
Thank you for the tutorial. I was just thinking of a way to use google sheets to collect data. I have a question though, how do I go about redirecting users to a specific page after submitting?
Same question, let's say we have a success page designed in Framer
Please try this code, and ensure that the "Back to Home" button on the success page opens in a new browser window. This is important to prevent the Google script from lingering in the URL after form submission:
function doPost(e) {
var row = [
e.parameter.first_name,
e.parameter.last_name,
e.parameter.email,
e.parameter.package,
e.parameter.message,
]
var sheet = SpreadsheetApp.openById('1ThoJ8RQms37wooMNjgMihLj8j2P8EvUt0UCoe3ACcNc');
sheet.appendRow(row);
// Create an HTML response with JavaScript for changing the URL
var htmlOutput = HtmlService.createHtmlOutput('window.location.href = "numerical-months-147179.framer.app/thanks";');
return htmlOutput.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}
@@dudleart please can you send me a video how to do it?
Never mind thank you for the code@@dudleart
what changes should I done when using dropdown and checkerbox?
loved it. Thank you, i have a problem, when form submited it was open permission to access google drive always. Any wrong with this?
You're amazing. Thank you so much!
Wow! Great video! I'm gonna try this, thanks
What if I wanted to style something in Figma and use the code Figma gives me to use within Framer?
Seems like first I need Figma to give me React code which I think can be done using Anima. I'm not sure. Trying to figure it out. Any tips?
if you want free use dualite plugin to get code, anima would be available on devmode only but it is not free
Hi! Thank you very much! This worked amazing.
I was wondering if there's a way to implement options in this script.
Like for example, asking for the gender of a person, if they could select between a set of options.
Also I would like to know if there's a way to make an input optional. Like if someone doesn't want to add their Name, if they could leave it blank without framer asking for an input.
Thank you so much
Obviously, just paste the code in this video and ask ChatGPT to do it and it would be able to show you how to do it.
Impressive work! How can we expand on the capabilities of these custom Framer forms even further?
Like any normal html form
This tutorial was indeed impressive!
Your tutorial was greatly appreciated. I was just brainstorming ways to utilize Google Sheets for data collection, and your guidance was right on point.
Thanks for the great tutorial!, Can you show how we can add an input field to upload a document like a PDF as well.
Thanks A lot Man
Thanks a lot you really saved me!
Hey, thank you for the great video. I want to receive response back in my website, hide the form and display the message. Can you help?
Great tutorial! How do we add a 'success snackbar' or 'success modal' when user click on the submit button?
Thank you!
Stop prevention on the submit button, and then just trigger custom component in the same file.
@@AMDesignAndDev Amazing! It would be great if you can make the video tutorial as well 😁
Hey thanks for this but I am getting this error
"Sorry, unable to open the file at present."
Same here
Have you found any solution for that?
great, thanks for sharing.
Nice tutorial. Is there an advantage to submitting this to Google Sheets rather than Google Forms?
How would you submit it to google forms? I don't know.
Google forms also outputs its results in sheets.
@@AMDesignAndDev I was watching your video to see if I could figure it out 😊. My assumption is I can use the pre-filled link to get the field entries and map it to the names in your form. Like, entry.2005620554=${name}. I guess I should work it out and get back to you. But since you went this direction I was like maybe this is better.
Thanks for the video it helps a lot, can you make one video to send data to whatsapp?
Framer and Zapier is that possible ?
And what others integrations available for framer ?
Thx thx thx
Did you manage to do it for Zapier or something else?
@@matheuswebmkt1 no 🤣
Thank you, would like to add data in google sheet, and also framer review input data and confirmation from user, also a framer confirmation redirect screen
All can be done, but will obviously need extra code.
I tried to do it but you will get an error message from CORS policy when trying to get an answers back from the Google Script and haven't been able to solve the issue. Tried setting CORS headers on doPost and doOptions but it won't work. Would be great to have some input from @AMDesignAndDev
Hi! Thank you for the tutorial! It was really helpful! But i keep getting this message "Script function not found: doGet" when i try to execute this function. i was wondering if you could help me. 😅
Do get for what? The function used here is doPost.
this is great and very well explained! how can we do it on multiple pages?
You can just use the same component and insert it in other pages, it would work.
Great info. Would have brought more value if you didn't rush through it.
not working for me
hey can you give framer code also
Great content but screen is hidden with your front cam video
there s no way to add a form id which makes it useless for google
Why? Can't you just have a hidden field with the form id in the form and send that to google.
Why you do this so complicated
:D The other channels are already doing simple stuff, why not do complicated :D
Bro we have 2024 the key ist make things easy to reach more audience 🙌
@@GermanLazarev good to know!
can you share the framer code with us please?