If Statement in Choice Filter for Cascade Selects

Support
,
4

So I don't know if there are official rules on the forum with regards to text generated by ChatGPT as some forums have put a specific ban on that. Anyway, ChatGPT did help get the choice filter logic figured out to give the proper behavior.

"selected(username, ${username}) and selected(places0, ${q_place0}) and 
(
    (${q_place2} != '' and selected(places2, ${q_place2}) and selected(places1, ${q_place1})) or 
    (${q_place1} != '' and selected(places1, ${q_place1}) and ${q_place2} = '') or 
    (${q_place1} = '' and ${q_place2} = '')
)"

Here is the full XLSForm with working choice filter and the full list of farm activities. This is the start of a multilingual time sheet intended to be used to track labor activities on a farm.
Farm_Time good filter share.xlsx (14.9 KB)

1 Like