Hi all -
Iโm creating a validation rule for a drop down list that references different lists depending on another value in the form ([tx type]). It works except the last ifs statmentโฆ
If [tx type] doesnโt equal the conditions in my ifs() statement, I want the user to be able to input any value.
How do I do this? Can I create a list that allows any value? My last attempt is belowโฆ
=ifs( [tx type]=โClient Billโ,select(clients[company short name],[status]<>โInactiveโ), [tx type]=โClient Bill Pmtโ,select(clients[company short name],[status]<>โInactiveโ), [tx type]=โCarrier Billโ,select(carrier accounts[label],and([carrier id]=[_thisrow].[carrier],[status]<>โInactiveโ)), [tx type]=โCarrier Bill Pmtโ,select(carrier accounts[label],and([carrier id]=[_thisrow].[carrier],[status]<>โInactiveโ)), TRUE,{TRUE})
Thanks for any help!
-Cy
Hi all just checking in for tips! @Aleksi_Alkio any thoughts?
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |