@1minManager Thanks for your interest. The setup for the issue is a bit lengthy. I was avoiding it since my question more of a general nature. BUT, in case it sparks a suggestion that helps, I’ll describe it here. I’ll start in the “middle”, as it were.
I have a WorkOrder table that is keyed by [Order #]. There is a child of this row for Labor performed - a list of services associated with the workorder. That table structure looks like this:
In the Labor FORM, I reference a list of services to choose from that come from a static table that looks like this:
But I want the dropdown list to be filtered by the Type equal to that chosen on the Work Order - the parent record for the Labor record.
So, when the Work Order is an “Installation” and I am adding Labor entries, when I tap the Service dropdown I want the list to be filtered to only the “Installation” type services:
To accomplish this I would update the Valid_If property on the Service ID column of my Labor Form.
To do the above I need show the Services on the Labor Form filtered by the Type matching that on the parent record - Work Order
Ideally in a SELECT() when there is no column clash, I could write the needed expression like this:
SELECT(Services[Service ID], [Type] = [Order #].[Service Type])
Note the dereference of the parent record by [Order #].[Service Type].
But, to reference current row columns in the SELECT they need to be prefaced with [_THISROW]. That makes the expression syntax look like this
SELECT(Services[Service ID], [Type] = [_THISROW].[Order #].[Service Type])
This syntax, [_THISROW].[Order #].[Service Type], is currently not valid in AppSheet.
Since [_THISROW].[Order #].[Service Type] is not valid syntax, I was asking if there is any other known shorthand way of dereferencing a parent record column value or other suggestions that might make this logic easier.
I know I can replace [_THISROW].[Order #].[Service Type] with another SELECT() to get at the value I want but that starts to make the Valid_If expression messy. Throw on top of that logic that removes items from the list as they are selected and the Valid_if gets very lengthy.
Please let me know if anything is nor clear! Look forward to your response.