Hi,
I have a field element on my form to enter a date in the form mm/dd/yyyy
I use a calc element (ajax enabled) to watch this date field and calculate the users age based on the date entered.
All works fine.
Now, I need to use this calculated age as one of the values in a WHERE clause on a dbjoin element dropdown on the same form.
It seems when the ajax fires which calculates the age in the calc element, the result of the calculation is not seen by the dbjoin element and considered in the where condition.
I use two other field element placeholders in this where clause which work fine in the WHere clause of the dbjoin, but the calc element does not work.
Is it possible to use the calc element in the where clause and if so is the placeholder syntax any different from a field element placeholder??? I've tries with and without _raw but with no luck.
Much thanks.
I have a field element on my form to enter a date in the form mm/dd/yyyy
I use a calc element (ajax enabled) to watch this date field and calculate the users age based on the date entered.
All works fine.
Now, I need to use this calculated age as one of the values in a WHERE clause on a dbjoin element dropdown on the same form.
It seems when the ajax fires which calculates the age in the calc element, the result of the calculation is not seen by the dbjoin element and considered in the where condition.
I use two other field element placeholders in this where clause which work fine in the WHere clause of the dbjoin, but the calc element does not work.
Is it possible to use the calc element in the where clause and if so is the placeholder syntax any different from a field element placeholder??? I've tries with and without _raw but with no luck.
Much thanks.