Ok guys, I need a little help on an expression.
I have a form where I input upcoming filter changes, on this form when you select a company you then select or add an address from a drop down that only gives you addresses already associated with that company based on prior address tied to serial numbers. That formula is.
Select(Serial List[Address], [Company Name]=[Serial #1].[Company Name])
When I try to replicate this in the form to add new serial #'s with
Select(Serial List[Address], [Company Name]=[Serial #].[Company Name])
it pulls up just all the addresses from any serial number. Ideas?
I got it, trial and error, you apparently have to use another field on the form in order for it to work, so I know have
Select(Serial List[Address], [Company Name]=[Issue].[Company Name])
Hi @EricBWS
What about aadding [_THISROW] in the expression:
Select(Serial List[Address],
[Company Name]=[_THISROW].[Issue].[Company Name]
)
I think it may come more simple if you use the Reference type.
Let’s say you have a column [COMPANY], with Ref type and a source table COMPANY (where you have the addresses, I think here it would be your table “Serial List”). If so, you would have for your valid_if expression:
[Company].[Related Addresses]
Here is a drawing to help understanding the use of reference here:
For reference:
References between tables - AppSheet Help
2 Likes
