I have a Lab Inspection form. When creating a new Lab Inspection, you can mark items from a list as “Unsafe”. Each of these Unsafe items needs an issue created. I’ve created a Ref column that allows issues to be created. I’d like to pass the “Unsafe” values to that form so that users can only create issues from items marked “Unsafe”. Is this possible?
When you click “New” to add an issue, you get to this form:
I tried this expression. I put this is the Valid_If for the Issue > Issue Type field (which should be filtered to only include “Unsafe” items from the Inspection form). Unfortunately, this yields no results.
SELECT(Lab Inspection Issue Type[Key], IN( [_THIS], SELECT(Lab Inspection[Unsafe], [Key] = [_THISROW].[Lab Inspection])) )
And here are the columns. For the Lab Inspection Issues (“Issue Type” is the field that needs to be filtered):
And for Lab Inspections (“Unsafe” are the items of interest, “Related Lab Inspection Is” is the virtual column to hold related issues):