Nick Ashcroft 4/22/2024 4:08:22 AM for those interested, I have made a solution for the checkbox option which makes use of the new 'related' prefix in the record picker filter as follows - add a new field on the 'parent' form named 'Search' - this is the search box you can use for filtering the list of checkboxes - position the new field just above the checkboxes - add an 'Apply' button using a text section on the form and 'text is html' and html <button type="button">Apply</button>. This doesnt actually do anything except move the focus away from the search box in order for the filter to apply. - Add a filter on the checkbox field record picker using custom formula. example: If(IsNull(related[Search]), true, Contains([Country], related[Search])). which translates as 'if the search box is not blank, match the list of countries against the value in the search box' - whatever is typed in the search box will filter the list of checkbox values when clicking 'Apply' (or anywhere else on the page!) - add a trigger on the parent table to clear the Search box on saving. screenshot below https://www.teamdesk.net/secure/db/87806/res.aspx/filter%20checkboxes2.pngmore info about the great new 'related' filter here https://www.teamdesk.net/blog/whats-new/related-column-prefix/ |