Hi,
I am having challenges checking the value of a Yes/No dropdown when calculating a currency field.
For example, I have this formula below
[387] + (([382] >= 2018 && ([380] != "") && [381] != "") ? 30000 : ([382] >= 2018 && ([380] != "") && [381] == "") ? 45000 : ([382] <= 2017 && ([380] != "") && [381] != "") ? 70000 : ([382] <= 2017 && ([380] != "") && [381] == "") ? 90000 : ([382] == "" && ([380] == "") && [381] == "") ? 110000 : ([382] <= 2017 && ([380] != "") && [381] == "" && [393] != "No") ? 110000 : ([382] <= 2017 && ([380] != "") && [381] != "" && [393] != "") ? 110000 : 0 )
Expressions where Field [393] == Yes or No do not seem to evaluate at all. So, I get results for the other expressions without the field [393].
How can I resolve this?
Staff replied 8 months ago
I wrote an answer but the forum didn't save it. You should get it through email.
Staff replied 8 months ago
Also, Formidable does not store empty values in the database. So checking against an empty value, [393] != "", will never be evaluated because if there is no value, there is no entry for that field in the database.
Staff replied 8 months ago
Set a default value for the field and you won't have to worry about the absence of value.