Return value instead of label

[bencsikzoli]

Hi,

I'm new to php and to everything in overall. I'm still learning the processes but I need to go on due to work.

I have a table with cascading dropdown to get the ID and display the name as label. In another field with calc I want to get back the value and display the label but with a simple if statement I can get back the label as value into my database.

Can you help me out how to change the code?

if ('{matches___set_a}' > '{matches___set_x}') {
return '{matches___player_a}';
}
elseif ('{matches___set_x}' > '{matches___set_a}') {
return '{matches___player_x}';
}
else return '';

Thanks,
Zoltan

 

[lousyfool]

Hi,

Append "_raw" to your placeholders: http://fabrikar.com/forums/index.php?wiki/placeholders/#raw-values

 

[bencsikzoli]

Perfect, this is what I was looking for.

Another question.
I have a value in the database and I want to set another field where I display another value which is not stored in that table.

Eg.
Table 1 has the followings:
competition ID + Name

And I want to display the type of the competition which it stored in table 2.

Thanks again,

 

[lousyfool]

Another question.

= usually a new thread.

Anyway, you want to join the two tables. For this, table 2 must have a foreign key element, which in your case would be the primary key of table 1 = competition ID.

If all this is new to you, please study the Wiki, e.g. http://fabrikar.com/forums/index.php?wiki/joining-list-and-form-data/ and else.