|
|
|
![]() |
|
|||||||
|
||||||||
Scouting app for Android Phones, using SMS to populate a central Google Sheet for a team. Uses App Inventor for application, Twilio for SMS message data communication to the sheet.
To use this system, one will need to be technical savvy with the technologies used. It has been a long learning process for the team this year, and is working, but there is not an easy one click, everything works setup button.
The app is created in App Inventor ( Google account). The app collects data into variables, then creates a comma separated text string from the variables. Next, when the submit button is pressed, the text is sent to the Twilio number, which then calls the script that separates the string into values that are entered into the spreadsheet. There are three different sheets. The first sheet shows autonomous data, the second shows teleop data and third is descriptive data. This app uses SMS (phone texting on Android phone) to enter data. This was done due to lack of wifi or data signals at venues, and the rules restricting Bluetooth or other such signals to be utilized.
I am not the programmer for this app, but our team will be happy to answer questions, and take feedback.
InstructionsforTORCAerialAssistScoutApp.docx
Aerial_Assist_Scout_v6.aia
Aerial Scout Script version 6.txt
Aerial Assist Scout version 6 changes.txt
Aerial Assist Scout v6 Data.xlsx
23-02-2014 13:55
jawebsteWhen I run the google script I receive the following error:
TypeError: Cannot read property "parameter" from undefined. (line 5, file "Code")Dismiss
I think I am following the directions. This occurs during Step 3 at the top of page 3 of the instructions. My cell is dead a reply here is probably best. Thanks
24-02-2014 10:16
MasterEric|
When I run the google script I receive the following error:
TypeError: Cannot read property "parameter" from undefined. (line 5, file "Code")Dismiss I think I am following the directions. This occurs during Step 3 at the top of page 3 of the instructions. My cell is dead a reply here is probably best. Thanks |
24-02-2014 12:17
MasterEricPlease note the following:
*All buttons use a “long-click” to subtract, that way if a button is pressed accidentally it can be subtracted. The Assist button is a toggle.
*Data is submitted every time a goal is scored , the end cycle button is pressed or the submit button is pressed. When you view the data in the spreadsheet, there WILL BE duplicates. The “remove duplicate rows” Google script can be used in the autonomous data (sheet 1) and the robot description sheet(sheet 3). In the teleop data sheet that script will not work because of the timestamp. In that case, rows can be sorted by robot number, then cycle number. If there is multiple rows for one cycle then those extra rows can be removed. We may create a script for just removing rows where data is duplicated just in certain rows, but we have not done that yet.
26-02-2014 10:31
MasterEricGo to TORC website to download latest version of this app and the new and improved script file that will prevent duplicate data from being entered into the spreadsheet.
26-02-2014 12:30
tr6scottUpdated files are now posted here, please update if you have downloaded prior to 2014-02-26.
27-02-2014 08:14
MasterEric|
Please note the following:
*All buttons use a “long-click” to subtract, that way if a button is pressed accidentally it can be subtracted. The Assist button is a toggle. *Data is submitted every time a goal is scored , the end cycle button is pressed or the submit button is pressed. When you view the data in the spreadsheet, there WILL BE duplicates. The “remove duplicate rows” Google script can be used in the autonomous data (sheet 1) and the robot description sheet(sheet 3). In the teleop data sheet that script will not work because of the timestamp. In that case, rows can be sorted by robot number, then cycle number. If there is multiple rows for one cycle then those extra rows can be removed. We may create a script for just removing rows where data is duplicated just in certain rows, but we have not done that yet. |
27-02-2014 09:47
MasterEricUsers of this app will need to go in and change the events list to their own team's events. The "Choose Event" button is a list picker. Go to the properties and in the "ElementsFromString" property, type in events separated by a comma.
27-02-2014 09:59
MasterEricUp to version 5, this app separates the string by commas. We will fix this in the future but in the meantime don't use comma's in your comments or team number or match number. If you do, your data will not go into the expected places on the spreadsheet.
27-02-2014 15:02
Anthony4004Just installed v5 however the duplicates are still there, as well as differing duplicates.
https://docs.google.com/spreadsheet/...rive_web#gid=0
I believe that a tutorial video would be very helpful.
27-02-2014 15:24
MasterEric|
Just installed v5 however the duplicates are still there, as well as differing duplicates.
https://docs.google.com/spreadsheet/...rive_web#gid=0 I believe that a tutorial video would be very helpful. |
27-02-2014 15:32
MasterEric|
Just installed v5 however the duplicates are still there, as well as differing duplicates.
https://docs.google.com/spreadsheet/...rive_web#gid=0 I believe that a tutorial video would be very helpful. |
27-02-2014 15:43
Anthony4004Yes, I used all the new updates
27-02-2014 15:59
MasterEric
27-02-2014 22:01
MrRiedemanJACCOne of my students downloaded and set it up today. Looks pretty awesome! Thanks for sharing!!!!
28-02-2014 07:44
eddie12390It looks good, thanks for sharing
28-02-2014 08:00
MasterEric|
One of my students downloaded and set it up today. Looks pretty awesome! Thanks for sharing!!!!
|
01-03-2014 16:11
Hazmat2145Great work being done here.
I have the newest script.
I get a error on the phone.
'IO Error : unable to create GvHelper'
Any help would be greatly appropriated.
Thanks
Hazmat 2145
01-03-2014 16:48
MasterEric|
Great work being done here.
I have the newest script. I get a error on the phone. 'IO Error : unable to create GvHelper' Any help would be greatly appropriated. Thanks Hazmat 2145 |
01-03-2014 17:13
Hazmat2145Wow fast response. I did the compile again and get no error now.
The next issue i have
is when i submit i get a text message on my phone but no update on Google drive. I know i am close.
Thanks for the help
Hazmat 2145
02-03-2014 09:25
MasterEric|
Wow fast response. I did the compile again and get no error now.
The next issue i have is when i submit i get a text message on my phone but no update on Google drive. I know i am close. Thanks for the help Hazmat 2145 |
03-03-2014 16:51
Hazmat2145|
the things that need to be correct for the text to get to the spreadsheet are:
1. The spreadsheet ID in the script, check that that correct 2. The Twilio phone number in the App Inventor file needs to be the Twilio phone number 3. The script was run and permissions were allowed for the spreadsheet. In Twilio, there is a text message log. There, you can tell if your message got to Twilio from the app. If it did, you can see what the message is. It should be all your data separated by commas. If that is correct then it's an issue with the script not sending it to the spreadsheet properly. You need to figure out which part isn't working. |
04-03-2014 08:12
MasterEric|
The log Twillo for text messages is empty. Do i need to upgrade the Twillo account?
The spread sheet ID in the script is correct according to the number on my spread sheet The Twillo # in the app is changed to match the number i got. The script was run to give permission. I do get a message on my phone from Verizon every time i hit the send key in the app "5555555555 is a land-line# Reply Y to send all TXT messages to this # as voice messages for 0.25/msg" Thanks for the help. Hazmat 2145 |
08-03-2014 08:49
Hazmat2145Great news I no longer get the text message sent back to my phone. After changing the variable "initialize global phonenumber" to the correct Twillo # Twillo now gets the message. Now I have a Twillo message log but for ever message i get a error "Error: 11200 - HTTP retrieval failure" in Twillo.
Thanks,
Hazmat 2145
10-03-2014 21:24
MasterEric|
Great news I no longer get the text message sent back to my phone. After changing the variable "initialize global phonenumber" to the correct Twillo # Twillo now gets the message. Now I have a Twillo message log but for ever message i get a error "Error: 11200 - HTTP retrieval failure" in Twillo.
Thanks, Hazmat 2145 |
11-03-2014 11:26
eli2410I don't think anyone has asked this yet, but if they have, sorry for the repeat.
I know that with Google Forums, every time you submit an answer, it creates a new line. This messes up any formulas you have in the document. Does this happen here or not?
11-03-2014 12:19
tr6scottVersion 6 is posted.
Thanks to all the teams that have tried this, and given feedback, it is making it better!
Changes:
-moved the foul and technical foul buttons to the description area. During the match it's too hard to keep track of fouls (ref) and the bot. After the match when they are announced it can be tallied or entered into the comments area.can be added along with the other robot descriptive data in the checkboxes.
-the previous version used commas to separate the data into the columns of the spreadsheet. This version uses '~' (tilde) since it's too easy to enter a comma in the comments section, and end up with the data going into multiple columns.
-added an "End Match" button. This stops the clock, and sends the final match data to the spreadsheet
-timer glitch was fixed (timer was continuing until the start cycle was pressed again. It's easy to forget to start the cycle, so now it's done automatically). The timer RESETS and a new cycle is started as soon as a high or low goal is scored or the End Cycle button is pressed. The timer STOPS when the End Match button is pressed.
-when submit data is pressed, data is entered into the descriptive data spreadsheet sheet 3, and the comments data sheet 4
-if End match, goals and end cycle buttons nothing happens unless a cycle has been started.If the match is going, and those buttons are pressed it sends the cycle data to sheet 2 and starts a new cycle. End cycle also sends the data and starts a new match. End match sends the data but does not start a new match.
also
-fixed foul reset (was not resetting to 0), reset start position
-events are general (wk#, championship)
-changed "match time" label to "cycle time"
11-03-2014 16:49
MasterEricplease note: When setting up a new version of the script, you need to create a new project. Once you run, authorize and publish the script, you need to make a new app in Twilio with the url of the new script. Twilio caches the script url so this is the only way to get around Twilio using the old script.
11-03-2014 16:55
MasterEric|
I don't think anyone has asked this yet, but if they have, sorry for the repeat.
I know that with Google Forums, every time you submit an answer, it creates a new line. This messes up any formulas you have in the document. Does this happen here or not? |