Filter results using API_GenResultsTable query
This is my current query.
~=qdb.GetURL("bnezxxxxx","API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}^clist=80.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~
How do I add filters to create form 1 and form 2?
Form 1: Display only rows where Activities: ?Key Activity? is checked (checkbox)
Form 2: Display only rows where Tasks-Level3:?Required? is checked (checkbox)
I am working with 3 tables with relationships:
? Projects
? Activities
? Tasks-Level3
Activates = ?bnezxxxxx?
40= (Text Lookup) (Value Field) Projects: Name (Reference Field) Activities:RelatedProject2
?Name?=(Text Field) (Projects:Name)
80= (Text Lookup( (Value Field) Tasks-Level3:Level 3 ? Name (Reference Field) Activities:Related Tasks -L32)
91=(Date field) Activities:?Start-Display?
92=(Date field )Activities:?Finish-Display?