Calculation Element Problem with Calc on Save Option

[mygunfriday]

I'm sure I had my Calculation Elements working before, but now they won't pick up {tablename___elementname} data from other fields on the form on a New Form submit.

It works if I've already submitted data and return to the form and save again, but I thought I could access the newly created element values in the calculation element and save those as well in a New Form submission.

Can someone set me straight on this?

Cheers,

Jeremy

[peamak]

Can you show us your code to see if there's something obviously wrong?

When you say "now they won't pick up......": what happened exactly before "now", did you update Fabrik?

[mygunfriday]

Can you show us your code to see if there's something obviously wrong?

When you say "now they won't pick up......": what happened exactly before "now", did you update Fabrik?
__________________
-- tom

Hi Tom,

I've attached one actual sample where the query works fine if I use it with no save selected (results show in the table for all records), but fails to display on new if yes is selected (no result in table).

I did a simpler sample with just a "return '{tablename___elementname};'" from the same table which again works (displays in the table) if no save is selected, but fails to save a value if yes is selected.

I've attached some screenshots of my settings used.

I had been working on a complicated form that will have multiple forms pointing to the same table, I noticed this wasn't working as I expected, but didn't realize it had also stopped working in other forms I'd already completed and tested. I did a Fabrik update yesterday to see if that would help, but no luck.

Aside from that, I'm running on a Rochen server and I had some problem with accessing the email templates I'd made in Joomla articles because of the access level setting in Joomla - I don't know that I've changed anything else, but I may have done something...

I should mention that while Save is on yes, this also doesn't work on a new record or an edit of an existing record at this time, though I'm sure yesterday, it was working if I did an edit.

Any help would be much appreciated...

Jeremy

[peamak]

I'm not sure to understand why it's not working as you want but I just want to clarify something:
The option is "Calc on Save only: Yes/No" not "Save: Yes/No". I know the difference sounds trivial but still, it's different

[mygunfriday]

To clarify:

If I choose: Calc on Save = No, then it works as expected
If I choose: Cac on Save = Yes, then it does not work

[rob]

have you tried setting you code to output some debug information, somehting like:

PHP Code:

$db->setQuery('your query here');
echo $db->getQuery();
echo '<pre>';
print_r$(_POST);
exit; 


are you sure the datbase join element whose data you are getting is visible and editable by the user?

[mygunfriday]

Hi Rob,

I tried the debug code sample (screenshot attached). The form doesn't do anything on posting, it just posts as usual, with the calculation field empty.

are you sure the datbase join element whose data you are getting is visible and editable by the user?

In the example, the city is a dbase join field selected by the user in the same form. The lookup in the calculation uses the _raw value from this selection to pull another bit of field data from the city table. So it is both visible and editable by the user.

I would have thought that the form itself would have access to all the data, even if I was hiding a field to lookup some data related to the user and using this hidden data to add another looked up value in a hidden field - is this not the case?

- Jeremy

	_raw In addition to the normal placeholders of {tablename___elementname} you can also use {tablename___elementname_raw} This is useful, for elements which have the concept of a 'label' and a 'value' (like dropdowns, database join elements, checkboxes, etc) the {tablename___elementname} will contain the 'label'. The {tablename___elementname_raw} will contain the 'value'.

[rob]

The form doesn't do anything on posting, it just posts as usual, with the calculation field empty.

Are you sure you are editing the element which is associated with the form? I tested this and adding the exit; will definately stop the validation code and show any output you have echo'd out.

[mygunfriday]

Hi Rob,

I double checked this, and I thought maybe the code had an error and was being ignored - so I rewrote it to something simpler. It now fails to display the form and displays a blank screen.

Now using this code:

$query = "SELECT tax_rate FROM cities WHERE id = 1";
$db->setQuery($query);
echo $db->getQuery();
echo '<pre>';
print_r($_POST);
exit;

So still not working as expected....

- Jeremy

[rob]

you would needd

$db =& JFactory::getDBO();

at the beginning, also its best when testing a site to put the error reporting (global config->system) to maximum to catch any php generated errors.