How do you add criteria to an embedded table in Exact Forms?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

I have this code in my exact form and I need to make a modification. I want it to only show records where the field [Print?] is equal to true. This field is a checkbox field. How do I modify this code?

~=qdb.GetURL("bieg7wwmf", "API_GenResultsTable^query={'9'.EX.'"+ field["Record ID#"]+"'}^clist=6.30.33.34.35.16^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=21");~

Thanks, Dave

Photo of coachDave

coachDave

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of Keith

Keith, Champion

  • 1,148 Points 1k badge 2x thumb
Try this

~=qdb.GetURL("bieg7wwmf", "API_GenResultsTable^query={'9'.EX.'"+ field["Record ID#"]+"'}AND{'ZZ'.EX.'1'}^clist=6.30.33.34.35.16^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=21");~

Replace ZZ with the numeric field ID number for the [Print?] field in your table

Keith
Photo of coachDave

coachDave

  • 0 Points
It worked perfectly. Thanks for the help.