How to send data to Google Sheets using an HTML form 

First, when u create an account, you link a database to create an API for this spreadsheet. You don't even had to give editor allowance on the link to this work After you link you sheet on your dashboard, you will receive an API link, this link you add on inside you action=" " attribute on the form, together with the method="post" Using this link, the form will send the gathered data to your API :)

Oh, and to clarify, your first row, the one which have the column names, needs to have all the characters in lowercase (and without spaces too I think) Then you add the name="columnName" inside all your inputs, so that the SheetDB API knows which data to put inside each column Otherwise, if u don't follow these steps, you'll get the error "bad data format"

I have the same question as you, I see you wrote a comment 4 months ago so.

@@uriwoongjjangg_0405 did you figiure it out?

@@chotepongtangton1280 did you figure it out?

location.reload() - use this code in a success part

🙏🙏🙏🙏🙏

Hi, check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wb8j0xPY-w4.html&ab_channel=SheetDB

bbbb

Google Spreadsheet is not the best place to store images. You can store URLs to images, but you can't store files in a spreadsheet.

Hi, can you share the code? Here you have a working example: codepen.io/sheetdb/pen/VwPpJqx

same problem

same here

dude put the javascript below the html form and it will work

They will, as long as you leave only the CREATE (POST) permission marked in the API settings. We recommend doing that while using the HTML Form.

Ok Sir.. Thank you Sir for this information...😊

Hi, you can use our html snippet: docs.sheetdb.io/#our-handlebars-snippet

@@sheetdb thanks! Will try yo see how it works since I am a noob 😁😁

DisplayValues

Hi, sure. Here is an exampe using radio input: codepen.io/sheetdb/pen/zYEXwgO You can also use dropdown: developer.mozilla.org/en-US/docs/Web/HTML/Element/select Or checkbox: developer.mozilla.org/en-US/docs/Web/HTML/Element/input/checkbox

@@sheetdb thank you for your quick reply. this is wonderful. I needed an example so i can test myself and you made my day!!! Great video and thanks for your help!!! Liked and subscribed!!!

@@ajjalt2276 Okay, here is the example on both dropdown and checkbox: codepen.io/sheetdb/pen/LYOLvqv You can check the API at sheetdb.io/api/v1/jepsgwzvxcpaf

@@sheetdb how can i send values to different sheets

@@xayotmamajonov3336 You have to connect each sheet with their own API, simply creating one for each sheet on the SheetDB dashboard. And using the API link in the forms of the respective sheets.

You need to login to SheetDB and press the Create new button.

@@sheetdb thx bruda. I've successfully made one