(about 3 years ago) by adianteapps
With adiante apps you can create an app for your team. If you make an app of this kind, one of the tasks you will have to perform is to keep updated the results and the classification. In this article you'll learn how to easily do this.
We are going to use two things. The first one is a Google Docs spreadsheet template that our team has prepared for you. We'll keep the classification updated by changing the number of matches won, lost and drawn. The second thing we'll use is a "Customized content" module.
Create your own template copy.
The first thing we'll do is to create a copy of the template. Open this link:
and in the menu file select "Make a copy":
Note that you will need to have a gmail account.
Customize the content.
Next thing we'll do is to change the contents of the file. At the bottom you'll see three tabs. Click on the one labeled "English" and modify the names of the teams. Then change the columns W (matches won), D (matches drawn) and L (matches lost) with the actual results of the league.
Modify only the columns Team, W, D and L
Do not change the columns P (matches played) and Pts (Points) as they are calculated automatically.
If you need to add more teams, copy the last team row and continue modifying the values of the columns. By using this method, the columns P and Pts will be updated automatically.
Once you have introduced the dates of all the teams, click on the small arrow next to the F columnand select sort Z->A. This will update the classification according to the number of points each team has.
Also, note that on the "Config" sheet you can modify the points given to each result (win, lost, drawn).
Update your app
Cool! now there is only one step left. Open in a new tab adianteapps.com and add the "customized content" module if you haven't done it already. Go back to the spreadsheet and select all the columns with data. Then copy them (pressing Control+C) and paste them in the customized content module editor (pressing Contro+V).
Et Voilà! This is the result in your phone:
Every week, after all matches have finished, update the W,D, and L columns, sort them again Z->A, and copy-paste the table in your customized content module.
Then don't forget to send a push notification to your supporters to inform them about the team results and the updated classification list.
Yeah! That easy...
Well, now is your turn, you can start building the app of your team and add to it the classification of the league.
We hope this tutorial was useful, if you have any doutb or something to add, don't hesitate to contact us through our social networks.