hi ! i did a form where my users site complete the result between two fottball team , and i want to showing them a view based on result : win draw or lose , the points of that teams . For example : Team no 1 vs Team no 2 ends up 2-1 for team no 1 . Team no 1 will have 3 points and the team no 2, 0 points. In the second match the score is 0-0 , and team no 1 will have 4 points and the team no 2 , 1 point. and so on . This is my form :
https://creator.zoho.com/adiman/rezultate/form-perma/Rezulate_inregistrate/ and this is the view
https://creator.zoho.com/adiman/rezultate/view-perma/Rezulate_inregistrate_View/ . it is necessary a formula ? if goal for is higher than goal against ( 2 > 1 = 3 for team no 1, 1<2 = 3 points for team no 2 , 0=0 2=2 means 1 point for each team, ). a formula that know the report : < > or = between goal for and goal against.