I would like to do the following.
I have one form http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
And there I can select the date of training and a trainer.
The values that are saved to the database are
ploegid = 40
training = date
trainer = Luc De Hert
When I hit the submit button it goes to http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Aanwezigheid_RE
But I need to have this form displaying the following
All players that are in team with ploegid = 40 (comes out table lx59p_spelers)
An Vandeperre
Anja Moyson
Dirk Bonné
Dirk De Waele
Dorien Vandevoort
Els Brioen
Guido Verlinden
Ive Van Cleemput
Jef De Bie
Jef Vanherck
Karlien Vandevoort
Luc De Hert
Marc Maurice
Nancy Henderickx
Paul Costermans
Stefan Bovyn
Walter Audoor
and then next to it following options
aanwezig
gekwetst
afwezig
afwezig (onverwittigd)
ziek
This values are coming from table lx59p_trainingsopties
Then the form must look like this (overall checkboxes)
aanwezig gekwetst afwezig afwezig (onverwittigd) ziek
An Vandeperre checkbox checkbox
Anja Moyson checkbox
Dirk Bonné
Dirk De Waele
Dorien Vandevoort
Els Brioen
Guido Verlinden
Ive Van Cleemput
Jef De Bie
Jef Vanherck
Karlien Vandevoort
Luc De Hert
Marc Maurice
Nancy Henderickx
Paul Costermans
Stefan Bovyn
Walter Audoor
When all is filled in it must save this data to table lx59p_chronoengine_chronoforms_datatable_Aanwezigheid
The fields in this table are
ploeg (this value must be the same as the value in http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
in this example 40
training data filled in in http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
naam (example An Vandeperre)
opties (aanwezig)
How is this possible?
I have one form http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
And there I can select the date of training and a trainer.
The values that are saved to the database are
ploegid = 40
training = date
trainer = Luc De Hert
When I hit the submit button it goes to http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Aanwezigheid_RE
But I need to have this form displaying the following
All players that are in team with ploegid = 40 (comes out table lx59p_spelers)
An Vandeperre
Anja Moyson
Dirk Bonné
Dirk De Waele
Dorien Vandevoort
Els Brioen
Guido Verlinden
Ive Van Cleemput
Jef De Bie
Jef Vanherck
Karlien Vandevoort
Luc De Hert
Marc Maurice
Nancy Henderickx
Paul Costermans
Stefan Bovyn
Walter Audoor
and then next to it following options
aanwezig
gekwetst
afwezig
afwezig (onverwittigd)
ziek
This values are coming from table lx59p_trainingsopties
Then the form must look like this (overall checkboxes)
aanwezig gekwetst afwezig afwezig (onverwittigd) ziek
An Vandeperre checkbox checkbox
Anja Moyson checkbox
Dirk Bonné
Dirk De Waele
Dorien Vandevoort
Els Brioen
Guido Verlinden
Ive Van Cleemput
Jef De Bie
Jef Vanherck
Karlien Vandevoort
Luc De Hert
Marc Maurice
Nancy Henderickx
Paul Costermans
Stefan Bovyn
Walter Audoor
When all is filled in it must save this data to table lx59p_chronoengine_chronoforms_datatable_Aanwezigheid
The fields in this table are
ploeg (this value must be the same as the value in http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
in this example 40
training data filled in in http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Training_toevoegen_RC
naam (example An Vandeperre)
opties (aanwezig)
How is this possible?