Embedded Grid Edit Report Pre-filtered Conditional Dropdown
I'm trying to get an embedded (report link) Grid Edit report field to return a pre-filtered conditional dropdown list similar to how a Form field can filter based on a report. This is a Legacy Form. In screen shot 1 one can see a conditional dropdown list of Standard Deliverables (conditional on Discipline) that filters out Obsolete (checkbox field) deliverables by using the Form's "When Used for data entry:" filtered dropdown report. (filtered Obsolete not equal checked) I'm trying to replicate this behavior in an Embedded Grid Edit report, however, the full list of deliverables including the obsolete deliverables are showing up (eg. 3300 Utilities and 3610 Fabrication Drawings) and there doesn't seem to be an obvious method to pre-filter this dropdown list (ie. pre-filtered report). I've done some reading on the subject in these discussions and the following discussion seems closest (https://community.quickbase.com/discussions/quickbase-discussions/embedded-grid-edit-report-help/18372), however, I haven't been able to get any of these ideas to work. Any help would be appreciated. Please let me know if additional information is required. Screen shot 1 - Individual Record Form Conditional Drop Down List Screen Shot 2 - Grid Edit conditional drop-down Thanks in advance for any help!
