👍 I'm relatively new to Google Sheets, and here's what I want to do. Create a spreadsheet for a large coin and currency collection. Use a form to input the data which saves it to a spreadsheet. I think I'll need it to be a CRUD spreadsheet, which means I need a host. I'm hoping I can use localhost, but need to know how to set it up and run it on Windows 11. So, I'll input and change all data through a form. Also, I want to use a custom SKU to make input easier. Am I dreaming or can this be done? 🤔
Hey! You can absolutely do this - and to boost, you don't even need a localhost since everything will run on the cloud. First, create a Google Form that will capture all your data. Include fields that you need like Name, Year, Country, Condition, Custom SKU etc. Second, link the Form to a Google Sheet. This is super simple: Just go to the responses tab in the Google Form and click the green Spreadsheet button. For the CRUD, you don't need a host, just do it all from the spreadsheet: Create: New entries come from the Google Form Read: Reads directly from the spreadsheet. Update: Just go to the correct row in the Google Sheet and update the field directly. Alternatively, create an Update form. Delete: Just delete the right row from the spreadsheet. For the Update and Delete sections, if you're sharing this amongst a bunch of people then it's not wise to give everyone access directly to the spreadsheet. In this case there's a few different options. The easiest one is to add an extra field to the Google Form to specify whether the entry is a New Entry or an Update. For this to work, though, the user would need to know what they're updating so they'd need at least view-only access to the spreadsheet with a custom clickable link to the pre-filled Form. Here's an example Form: docs.google.com/forms/d/e/1FAIpQLSdbPzwGHZNEktAigiafwlwPYDQi6Ynq0sGIhwvZa54qi6JHSA/viewform And corresponding spreadsheet: docs.google.com/spreadsheets/d/e/2PACX-1vQpQzpo1Ijs93Srmqq9xQxKbDYGbiMIn6DrM9CsjVqvirHiV11ODP3EgEz1Uz1pHmEURHc-c7OBTVmo/pubhtml
👍 *Thank you so much* for your reply and help! ❤ Sadly, I have managed to corrupt / ruin the example files. I've tried and tried to figure out if I could fix them without success. Thus, I'm so sorry to ask you for more help, but could you please reset (whatever) them to their original form, so I can hopefully make copies in case I corrupt them again? Again, my sincere apologies... 😥
@@4funrc11 All reset for you :) I'd recommend copying the Google Form so you have one in your Drive. Then in the connected Google Sheet, use the formulas you see in this Sheet (I've highlighted them in orange): docs.google.com/spreadsheets/d/1jC8Y8HtkXAN0KLiunei1J5TJ7k0WV7boDuyIh6LZl_A/copy You'll just need to change the Form IDs in the formulas to match your Google Form
This was such a nice refresher on Google Sheets, I use it weekly but sometimes you forget what's possible!
Never thought that my Year 13 calc teacher would still be making videos about Google Sheets productivity
I wish I could make more but there's only so much time in the week!
Thank you for this video!
Glad it was helpful!
👍 I'm relatively new to Google Sheets, and here's what I want to do.
Create a spreadsheet for a large coin and currency collection.
Use a form to input the data which saves it to a spreadsheet.
I think I'll need it to be a CRUD spreadsheet, which means I need a host.
I'm hoping I can use localhost, but need to know how to set it up and run it on Windows 11.
So, I'll input and change all data through a form.
Also, I want to use a custom SKU to make input easier.
Am I dreaming or can this be done? 🤔
Hey! You can absolutely do this - and to boost, you don't even need a localhost since everything will run on the cloud.
First, create a Google Form that will capture all your data. Include fields that you need like Name, Year, Country, Condition, Custom SKU etc.
Second, link the Form to a Google Sheet. This is super simple: Just go to the responses tab in the Google Form and click the green Spreadsheet button.
For the CRUD, you don't need a host, just do it all from the spreadsheet:
Create: New entries come from the Google Form
Read: Reads directly from the spreadsheet.
Update: Just go to the correct row in the Google Sheet and update the field directly. Alternatively, create an Update form.
Delete: Just delete the right row from the spreadsheet.
For the Update and Delete sections, if you're sharing this amongst a bunch of people then it's not wise to give everyone access directly to the spreadsheet. In this case there's a few different options. The easiest one is to add an extra field to the Google Form to specify whether the entry is a New Entry or an Update. For this to work, though, the user would need to know what they're updating so they'd need at least view-only access to the spreadsheet with a custom clickable link to the pre-filled Form.
Here's an example Form: docs.google.com/forms/d/e/1FAIpQLSdbPzwGHZNEktAigiafwlwPYDQi6Ynq0sGIhwvZa54qi6JHSA/viewform
And corresponding spreadsheet: docs.google.com/spreadsheets/d/e/2PACX-1vQpQzpo1Ijs93Srmqq9xQxKbDYGbiMIn6DrM9CsjVqvirHiV11ODP3EgEz1Uz1pHmEURHc-c7OBTVmo/pubhtml
👍 *Thank you so much* for your reply and help! ❤
Sadly, I have managed to corrupt / ruin the example files. I've tried and tried to figure out if I could fix them without success.
Thus, I'm so sorry to ask you for more help, but could you please reset (whatever) them to their original form, so I can hopefully make copies in case I corrupt them again?
Again, my sincere apologies... 😥
@@4funrc11 All reset for you :)
I'd recommend copying the Google Form so you have one in your Drive. Then in the connected Google Sheet, use the formulas you see in this Sheet (I've highlighted them in orange): docs.google.com/spreadsheets/d/1jC8Y8HtkXAN0KLiunei1J5TJ7k0WV7boDuyIh6LZl_A/copy
You'll just need to change the Form IDs in the formulas to match your Google Form