ContributionsMost RecentMost LikesSolutionsRe: Filter results checkbox is checked using API_GenResultsTable queryAwesome! I am flying now! Thank you!Filter results checkbox is checked using API_GenResultsTable queryHi out there! I am trying to use an AND to only get fields where the checkbox is checked. This is not working. 11 is the field ID (checkbox) I tried upper and lower case 'true' I also tried the number '1'. How to you filter on a checkbox using API_GenResutlsTable ,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?TRUE?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~ ,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?true?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~ ,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?1?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~Filter results using API_GenResultsTable queryI am lost trying to filter data for my custom forms. 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? Re: DATE field in log the edits to this field and show them on forms?Will QUICKBASE consider including DATE field. You can use this feature on TEXT field type but it is not available for DATE field type. Why? Will QUICKBASE consider this feature for DATE type fields as well? If not how can I show history of date on the form if someone changes the Project Start Date.DATE field in log the edits to this field and show them on forms?Will QUICKBASE consider including DATE field in log the edits to this field and show them on forms? This would be extremely helpful!!! Iam not sure how to do this on my own.