Advertisement
Guest User

Untitled

a guest
May 24th, 2015
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. function onFormSubmit() {
  2. var ss = SpreadsheetApp.openById("1m8EC7xwqBZ7CUgDiePvjXqOLGmYwsuGcV6iDdi9X7Yc").getSheetByName("Experimental")
  3.  
  4. var form = FormApp.openById("1YwyKiAKIo4wH8vMdDWNKiuukYHM5dMn7zchz27JMRaU")
  5. var Responses = form.getResponses()
  6.  
  7. var row = Number(Responses[0])
  8. var WhatHappen = Responses[1]
  9. var WhichPlayer = Responses[2]
  10. var WhichHolding = Responses[3]
  11.  
  12. var Question1 = "New province owner"
  13.  
  14. if (Responses[1] == Question1)
  15. {
  16. var column = 3
  17. ss.getRange(row, column).setValue(WhichPlayer);
  18. }
  19. if (Responses[1] == "Add holding")
  20. {
  21. if (Responses[3] == "Capital")
  22. {
  23. if (Responses[2] == "Player1")
  24. var column = 4
  25. }
  26. if (Responses[3] == "Castle")
  27. {
  28. if (Responses[2] == "Player1")
  29. var column = 5
  30. }
  31. if (Responses[3] == "Guild")
  32. {
  33. if (Responses[2] == "Player1")
  34. var column = 6
  35. }
  36. if (Responses[3] == "Sawmill")
  37. {
  38. if (Responses[2] == "Player1")
  39. var column = 7
  40. }
  41. if (Responses[3] == "Mine")
  42. {
  43. if (Responses[2] == "Player1")
  44. var column = 8
  45. }
  46. if (Responses[3] == "Chantry")
  47. {
  48. if (Responses[2] == "Player1")
  49. var column = 9
  50. }
  51. if (Responses[3] == "Armory")
  52. {
  53. if (Responses[2] == "Player1")
  54. var column = 10
  55. }
  56. if (Responses[3] == "Shipyard")
  57. {
  58. if (Responses[2] == "Player1")
  59. var column = 11
  60. }
  61. var ExistingHoldings = ss.getRange(row, column).getValue()
  62. ss.getRange(row, column).setValue(toString(ExistingHoldings+1))
  63. }
  64. if (Responses[1] == "Subtract holding")
  65. {
  66.  
  67. }
  68.  
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement