Hi, I have to put together an amateur football ranking list.
I have a list (club list) containing each "club" And its ranking values:
Club name (textfield),goal scored (textfield), goal conceded (textfield), match won( (textfield), matches lost (textfield), matches draw (textfield), points (calc)
One list containing matches (match_list):
Club1(dbjoin with club list),club2(dbjoin with club list), goals scored by club 1(textfield),goals scored by club 2(textfield), final result(yes/no)
I'd like to update the club_list when updating goals scored by club1(result1) and goals scored by club 2(result2) in table matches list (if final result=yes)
I believe it can be done, but I need some hint on how to start.
My "logic" would be something that is triggered on matches list submit, if final result = yes.
Here is what I believe should happen:
add result1 to club_list[club1][goal scored]
add result2 to club_list[club1][goal conceded]
do the same for club2 and compare result1 & result2 to determine if the match is won, lost or draw, and add 1 to the relative element in club_list[club]
Thank you
[edit: additional info added]
I have a list (club list) containing each "club" And its ranking values:
Club name (textfield),goal scored (textfield), goal conceded (textfield), match won( (textfield), matches lost (textfield), matches draw (textfield), points (calc)
One list containing matches (match_list):
Club1(dbjoin with club list),club2(dbjoin with club list), goals scored by club 1(textfield),goals scored by club 2(textfield), final result(yes/no)
I'd like to update the club_list when updating goals scored by club1(result1) and goals scored by club 2(result2) in table matches list (if final result=yes)
I believe it can be done, but I need some hint on how to start.
My "logic" would be something that is triggered on matches list submit, if final result = yes.
Here is what I believe should happen:
add result1 to club_list[club1][goal scored]
add result2 to club_list[club1][goal conceded]
do the same for club2 and compare result1 & result2 to determine if the match is won, lost or draw, and add 1 to the relative element in club_list[club]
Thank you
[edit: additional info added]
Last edited: