TOPIC:

Hallo zusammen,
ich hole mir über SelectList aus meiner Joomlatabelle :"Orte", die ID des Ortes und den Namen des Ortes, (z.B. 1;Köln) lasse mir mit SelectList nur den Namen anzeigen und speicher allerdings die ID ab. Muss so sein.

Jetzt brauche ich aber noch in einem Feld in meinem Formular, nennen wir es mal "geheim", auch den Ortsnamen.
Ich habe folgenden Code:

$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
//Abfrage Ort
$db->setQuery('Select id,value From xy_towns ');

$result = $db->loadrowlist(); //load the result from the query
$test = "0;Bitte wählen Sie den Ort aus;0\n";

for ($i = 0; $i < count($result); $i++)
{
$test .= "0;".$db->loadColumn(1)[$i].";".$db->loadColumn(0)[$i]."\n";
}
function ff_setSelectList($name, $value)
{
global $ff_processor;
for ($r = 0; $r < $ff_processor->rowcount; $r++)
{
$row =& $ff_processor->rows[$r];
if ($row->name==$name)
$row->data2 = $value;
unset($row);
}
}
ff_setSelectList('ObjektOrt', $test);

Es wird also in meinem SelectList Feld "ObjektOrt" nur der Name angezeigt und die ID gespeichert. Soweit alles gut.
Wie bekomme ich jetzt den Namen des Ortes in mein Feld "geheim" gespeichert???

Hello,

I hope that we can continue in English since we're a bit low on German speaking staff at the moment.

To achieve what you want navigate to Advanced options of the select list element. Then in the Actionscript tab, set Type to Custom and Action to Change.
In the code area bellow paste the following code:NOTE: In the code above replace every instance of selectlistname with the Name of the select list element.
Also, replace secretfiledname with the Name of the secret field that you want to paste the name of the city to.

Let me know whether you have managed to set this for your form and whether it works as you wanted.
If you have more questions, feel free to ask.

Regards,

Mihaela

Many thanks for the help,
Unfortunately it does not work.
And it is no longer possible to switch to the second page of the form by clicking "next".

Hello again,

It should work if you have your form's textfield and select list Names (not Titles) correctly inserted in the provided code
I assume there is an error in your code which is not allowing you to go to the next page.

Please send me the Actionscript code from the select list element so I can take a look. Also, could you send me a link to your form so I can check whether there are some errors in the console.

Regards,

Mihaela

I am currently working locally and unfortunately can not send a link.
Here is the code of the action script:
function ff_ObjektOrt_action(element, action)
{
var a = JQuery("[name = \ "ff_nm_ObjektOrt [] \ " ] option:selected").text();
ff_getElementByName('geheim').value = a;
}

These are the error messages on the console:

Leerer String an getElementById() übergeben.
jquery.min.js:2:24932
[Mitteilungsdetails anzeigen/ausblenden] ReferenceError: ff_ObjektOrt_action is not defined[Weitere Informationen] immobilie-zum-tausch-anbieten.html:1:1
Leerer String an getElementById() übergeben.
jquery.min.js:2:24932
[Mitteilungsdetails anzeigen/ausblenden] ReferenceError: ff_validate_nextpage is not defined[Weitere Informationen] immobilie-zum-tausch-anbieten.html:1:1
Leerer String an getElementById() übergeben.