Hi. Canโt quite work out an issue I am having. I have Fabrication Search Table with 1 column [Product Code] that is scannable. The scanned code takes the user to subsequent table Operations_Master_Check. One column in this table [Master Reject] is a text with Yes/No value (based on app formula). If this value is set to yes I want to return an error to the user in the previous table when scanning the [Product Code]. So it is something like Operations_Master_Check[Master Reject]=โNoโ in the ValidIf formula. I am getting an error because the system is trying to compare a List and Text. Could anyone tell me if I am on the right track here and if so how to tweak the expression to get me desired result?
Thank you.
Solved! Go to Solution.
Probably something likeโฆ LOOKUP([_THISROW].[Product Code],โOperations_Master_Checkโ,โProduct Codeโ,โMaster Rejectโ)=โNoโ
Most likely you have a column called Related Master_checks in the Product table so you can use IN(โYesโ, [Related Master_checks][Master Reject])
Hi @Bellave_Jayaram. If I understand you correctly I donโt have the Related Master Checks in the Product table. Is there an alternative approach.
Probably something likeโฆ LOOKUP([_THISROW].[Product Code],โOperations_Master_Checkโ,โProduct Codeโ,โMaster Rejectโ)=โNoโ
That worked @Aleksi. Thanks a million.
Youโre welcome
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
11 |