Content plugin - Save foreign id

[mariluzrm]

Hello everyone.
I am using the Fabrik content plugin. I have an article with a form and a list (this list is a 1: N relationship of the form record). When adding a new record to this list, it adds it perfectly to the database (using Add + default Save button), but as an external id it puts 0 instead of the foreign id (id of the form's record). How can I get it to be filled out correctly?
Thanks in advance.

 

[troester]

How do you set the recordID of the form in the article?

You can use "Default" with eval enabled in your foreign key element to fetch the recordID of the related form (e.g. from the URL).

 

[mariluzrm]

Hello.

The article is:

{fabrik view=form id=1 rowid=[param1]}

{fabrik view=list id=2 invent___IDESTR=[param1]}}

But when I add a new record in the list, when I'm in form (empty form to fill data), I have lost de invent___IDESTR (foreign ID) (I've tried to use php form plugin, and take this field with $formModel->getElementData, and then $formModel->updateFormData, but invent___IDESTR is cero, because it is a new record and foreign key is empty).

I can't do it. I am very new to Fabrik.

I don't understand how to do:

You can use "Default" with eval enabled in your foreign key element to fetch the recordID of the related form (e.g. from the URL).

Thanks

 

[troester]

Sure, {fabrik view=list id=2 invent___IDESTR=[param1]} (only one } ) will filter the list with invent___IDESTR=[param1]
and the param1 won't be passed automatically to list links.

If invent___IDESTR is your foreign key element which you want to preset in the new record do
http://fabrikar.com/forums/index.php?wiki/calculate-a-default-value/#get-the-element-s-filter-value

 

[mariluzrm]

Hi.

I have chosen element_calc to the field INVENT___IDESTR and I have written in Calculation (Is it OK?):

return FabrikHelperElement::filterValue(INVENT___IDESTR);

And this message appears:

Update field structure for `IDESTR` from INT(4) to TEXT.

with this in Calculation:

return (int)FabrikHelperElement::filterValue(INVENT___IDESTR);

But It's appears the same message:

Update field structure for `IDESTR` from INT(4) to TEXT.

Or is it correct instead?

return FabrikHelperElement::filterValue(param1);


Thanks

 

[troester]

I have chosen element_calc to the field INVENT___IDESTR and I have written in Calculation (Is it OK?

NO! The foreign key should be a field (or maybe databasejoin) element and you should set the element Default.

Get the element's filter value (top)
Say you filtered a list on an element, then went to add in a new record. Wouldn't it be great if the filtered element's value matched the selected filter? To achieve this enter the following in the element's default field:
PHP:
return FabrikHelperElement::filterValue(8);

Replace the 8 in the above example with your element's id.

http://fabrikar.com/forums/index.php?wiki/calculate-a-default-value/#get-the-element-s-filter-value

 

[mariluzrm]

Sorry, but I'm in trouble ...
When you talk about "element Default", what do you mean? It is not enough to put in the element that is the foreign key (INVENT___IDESTR) :

• Plugin=field
• EVAL=yes
• Default (php code)= return FabrikHelperElement::filterValue(41); //id element INVENT___IDESTR =41

Or I need to create a additional "element Default" (I don't know what it is) to pass the INVENT___IDESTR value and later assign that value in the form (new record) using php form plugin???

I don't get it. Please help!!!

 

[troester]

• Plugin=field
• EVAL=yes
• Default (php code)= return FabrikHelperElement::filterValue(41); //id element INVENT___IDESTR =41

Yes, this is what the WIKI says.

 

[mariluzrm]

Hello.

It doesn't work for me, when I create the new registry it keeps putting the foreign key with the value 0, is it necessary to do something else?

I have debugged with eclipse and the function filterValue returns False

Also, again the message is displayed:
Update field structure for `IDESTR` from INT(4) to TEXT.

Thanks in advance.

 

[troester]

Ok, it seems filterValue doesn't do in content plugin.

You can add a custum Add link in list settings and append the param there, something like (use your Add link)
index.php?Itemid=112&option=com_fabrik&view=form&formid=70&rowid=&param2={param2}

and then fetch the URL param in the default eval (only working if the user has Add access for this element)

$myapp = JFactory::getApplication();
$param = $myapp->input->get('param2','');
return $param;