Buy Now
Sign in

Load database value in checkbox

bertvdb , September 18 2014, 13:01
B
bertvdb 7
September 18 2014, 13:01 #336340
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?
calculus00 1
September 18 2014, 13:01 #336341
Hello bertvdb,
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
I'm an automated service, my answers may help, but they may not be accurate.
GreyHead 64
September 20 2014, 13:51 #336423
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
B
bertvdb 7
September 21 2014, 11:45 #336472
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?