Fair enough, but if you are even worrying about SQL injection.... then you might be 8 years behind modern web standards.[/quote]
While I agree with you that an SQL database is a much smoother and more flexible option..
This allows you to write JS (without node.js) instead of PHP/Java/C-Derivative. Which is great for this simple purpose of just simply moving data back and forth. The major factor of why I'm considering this alternative is just purely the fact that it's free hosting. I don't have a purpose for a website outside of ROBLOX, and I don't see a point in paying ~5$ a month on top of BC costs.
Anyone interested, here is a chat log script [spoiler]
local hs = game:GetService("HttpService")
local hsEntry1 = ""
local hsEntry2 = ""
local hsKey = ""
local hsForm = ""
local hsHost = "https://docs.google.com/"
local function logSheet(var1, var2)
local hsLink = hsHost.."forms/d/"..hsForm.."/formResponse?entry."
-- Upload onto Google Sheets!
hs:PostAsync(hsLink, "", 2)
function onChatted(msg, recipient, speaker)
newPlayer.Chatted:connect(function(msg, recipient) onChatted(msg, recipient, newPlayer) end)
How would one go about updating a certain cell and not adding a new line?
Assuming we are maintaining a table, and the table consists of a name followed by a number, and is always ordered by name. When put into google sheets all of the current cells would just be replaced with the new values.
Does Google Sheets have automatic data organization for things like average, max, min, current position in rankings (a function of row after ordering, I suppose), highest/lowest n number of values, and the keys for these values. (e.g. who are the top 10 players, where is suchandsuch in the leaderboard, what is the average score, etc.)
There is no particular order to how params can be specified. You can put more entries after the end of the string, in the middle, or in the beginning- it doesn’t matter. All the params get sent to the server at the same time, so as long as its present the server won’t care what order it’s in.
Now I’m not entirely sure about the format of Google Sheets, but you should be able to copy and paste the one from either entries and have no problem.