Hi, I am quite new with the more sophistical functions of CF. I have a quite simple problem, I am sure. I want to edit an record form the dababase, earlier filled by a CF-form. I made an application form for a membership, storage of the data goes in a table. So far so good. Later this membership has to be approved by his or her employee. So I want to let the employee open another form, populated with all the fields of the first one, plus a new field like 'Agreed' or something.
I suppose I need DB record Loader in On Load to populate the second form. In params what do I fill in in DB Field and Request Param? The record I would like to open could be identified by a field called 'Naam'. And what is then the url the employee has to use to get the correct form?
Paul.
I suppose I need DB record Loader in On Load to populate the second form. In params what do I fill in in DB Field and Request Param? The record I would like to open could be identified by a field called 'Naam'. And what is then the url the employee has to use to get the correct form?
Paul.
Hi Paul,
The DB Field would be Naam if that is the exact name of the the database column. The Request Param is the name of the parameter that will be used to identify the Naam. Let's say you choose uname, and 'Paul' is a valid entry in the Naam column of the table. Then a url including &uname=Paul would identify this record. So your full url might look like
Note that it's often easier to use the id or cf_if column of the table rather than a name column as names may contain characters, like spaces, that are not allowed in URLs and so need to be URLencoded before they can be used.
Please see this FAQ for more info.
Bob
The DB Field would be Naam if that is the exact name of the the database column. The Request Param is the name of the parameter that will be used to identify the Naam. Let's say you choose uname, and 'Paul' is a valid entry in the Naam column of the table. Then a url including &uname=Paul would identify this record. So your full url might look like
http://example.com/index.php?option=com_chronoforms&chronoform=my_form&uname=PaulNote that it's often easier to use the id or cf_if column of the table rather than a name column as names may contain characters, like spaces, that are not allowed in URLs and so need to be URLencoded before they can be used.
Please see this FAQ for more info.
Bob
This topic is locked and no more replies can be posted.
