Load database value in checkbox

bertvdb 18 Sep, 2014
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?
GreyHead 20 Sep, 2014
Hi bertvdb,

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
bertvdb 21 Sep, 2014
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?
This topic is locked and no more replies can be posted.