I have a calc element that gets the raw value from a databasejoin element in the same group then uses that in a query to return the result as the calc value.
The calc element is configured to 'Calc on load' and 'Use Ajax' (to check if/when the raw value in the databasejoin element changes in a new form).
What is happening is, in the details view the calc element is initially displayed (correctly), but then the ajax gets triggered (even though this is a details view and the dbj element never gets changed).
At that point, the raw placeholder value for that dbj element (referenced in the calc element) changes to the dbj label instead of the raw value - which explains why the element freezes with the ajax spinner spinning. (I know this is what is happening because I tried using that placeholder for the dbj raw value as the return value for the calc in order to debug this.)
Weird stuff, I know.
And I'm not sure if this is some new bug - just since updating from Github yesterday (1st update in maybe 3 weeks) - or an old issue that I just never noticed before.
So there's 2 mysteries here
The calc element is configured to 'Calc on load' and 'Use Ajax' (to check if/when the raw value in the databasejoin element changes in a new form).
What is happening is, in the details view the calc element is initially displayed (correctly), but then the ajax gets triggered (even though this is a details view and the dbj element never gets changed).
At that point, the raw placeholder value for that dbj element (referenced in the calc element) changes to the dbj label instead of the raw value - which explains why the element freezes with the ajax spinner spinning. (I know this is what is happening because I tried using that placeholder for the dbj raw value as the return value for the calc in order to debug this.)
Weird stuff, I know.
And I'm not sure if this is some new bug - just since updating from Github yesterday (1st update in maybe 3 weeks) - or an old issue that I just never noticed before.
So there's 2 mysteries here
- I can understand 'Calc on load' if specified, even in details view - but why would/should the ajax get triggered in details view?
- (And even if so) Why does the {fb_generate___custom_report_id_raw} value change from the correct raw value to the label once ajax is run?
Last edited: