I'd like to make a sort of calculator based on a grid, where the user checks different lines/columns and it will calculate some stuff based on what's checked. Perhaps I could do something in HTML/JavaScript but I think the Google Sheet environment is much better. However I don't know whether Google Sheet allows users to individually enter values without actually altering the sheet for other users.
How to allow users to enter some data in Google Sheet without actually modifying the content
google sheets
Related Topic
- Google-sheets – How to enter a date in Google Spreadsheet without hyphens or slashes
- Google-sheets – How to allow users to see and filter a data list without allowing them to edit the sheet
- Google-sheets – How to get data from a different sheet based one the adjacent sheet in Google Sheets
- Google-sheets – record the users within a Google sheet
- Google Sheets – How to Automatically Enter Sequential Numbers Without Using the Mouse
- Google-sheets – Google Form response is modifying a cell on another row of linked sheet
- Google-sheets – Mass-remove empty sheets in Google Spreadsheets
Best Answer
It is possible to give specific users permission to edit specific ranges. To do this, select a range, choose "protect range" from context menu, then click "set permissions". You will need to know the email addresses of the users, and with many users this is going to be a lot of hassle. Also, this doesn't look much like "online calculator".
To collect data from users that can't edit the sheet, one can use a Google form. This is great for letting them enter their data, but then you'll have a problem displaying the result of calculations back.
Conclusion: if you are building an online calculator, Google Sheets is not the right tool.