Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onFormSubmit() {
- var ss = SpreadsheetApp.openById("1m8EC7xwqBZ7CUgDiePvjXqOLGmYwsuGcV6iDdi9X7Yc").getSheetByName("Experimental")
- var form = FormApp.openById("1YwyKiAKIo4wH8vMdDWNKiuukYHM5dMn7zchz27JMRaU")
- var Responses = form.getResponses()
- var row = Number(Responses[0])
- var WhatHappen = Responses[1]
- var WhichPlayer = Responses[2]
- var WhichHolding = Responses[3]
- var Question1 = "New province owner"
- if (Responses[1] == Question1)
- {
- var column = 3
- ss.getRange(row, column).setValue(WhichPlayer);
- }
- if (Responses[1] == "Add holding")
- {
- if (Responses[3] == "Capital")
- {
- if (Responses[2] == "Player1")
- var column = 4
- }
- if (Responses[3] == "Castle")
- {
- if (Responses[2] == "Player1")
- var column = 5
- }
- if (Responses[3] == "Guild")
- {
- if (Responses[2] == "Player1")
- var column = 6
- }
- if (Responses[3] == "Sawmill")
- {
- if (Responses[2] == "Player1")
- var column = 7
- }
- if (Responses[3] == "Mine")
- {
- if (Responses[2] == "Player1")
- var column = 8
- }
- if (Responses[3] == "Chantry")
- {
- if (Responses[2] == "Player1")
- var column = 9
- }
- if (Responses[3] == "Armory")
- {
- if (Responses[2] == "Player1")
- var column = 10
- }
- if (Responses[3] == "Shipyard")
- {
- if (Responses[2] == "Player1")
- var column = 11
- }
- var ExistingHoldings = ss.getRange(row, column).getValue()
- ss.getRange(row, column).setValue(toString(ExistingHoldings+1))
- }
- if (Responses[1] == "Subtract holding")
- {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement