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)
If you build a multi-page form (either using separate pages in one form, or separate forms) then you can pass data between them using the Multi Page or Data to Session & Session to Data actions. That should let you do all of this OK.
Bob
ChronoForms technical support If you'd like to buy me a coffee or two, thank you very much
Ok Bob that seems to work Now i have made this http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Aanwezigheid_RE but I need to now how I can make this with values out of my database I have a table called lx59p-spelers with value An Vandeperre, Anja Moyson, ...and also table lx59p_trainingopties (where the values are aanwezig/gekwetst/afwezig/afwezig(onverwittigd) and ziek.
But how can i make a checkbox group with all the values of this 2 tables?
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'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How to load record data from a database table into your form
P.S: I'm just an automated service
If you build a multi-page form (either using separate pages in one form, or separate forms) then you can pass data between them using the Multi Page or Data to Session & Session to Data actions. That should let you do all of this OK.
Bob
If you'd like to buy me a coffee or two, thank you very much
Now i have made this
http://bravoc.be/index.php?option=com_chronoforms5&chronoform=Aanwezigheid_RE
but I need to now how I can make this with values out of my database
I have a table called lx59p-spelers with value An Vandeperre, Anja Moyson, ...and also table lx59p_trainingopties (where the values are aanwezig/gekwetst/afwezig/afwezig(onverwittigd) and ziek.
But how can i make a checkbox group with all the values of this 2 tables?