IF GetFieldValue Formula?
Hello QB Pros! I am trying to set up a field that compares the entry of one field to a list in another field and gives a result based on whether the fields value is in that list.
Example. User ente...
Forum Discussion
Thank you David! Here is the exact problem I am trying to solve.
We made an app that allows technicians to order parts. We have the complete inventory in a table that is related to the form the technicians are using. That's working really well.
However, there is another table that has a list of parts that are "Restricted" which require additional approval/routing.
I want the technicians to order the parts like normal, but when the part number they request matches a part number on the restricted parts list, if flags it as "Restricted" and triggers a notification.
I hope that clarifies! Thank you!
------------------------------
Conor Gray
------------------------------
To add to the response . When I say the relationship has to be based on the part number. you don't necessarily have to change the key field. You can just make the proxy field the part number so it makes sense for entering.
If that makes sense. So in a sense it will still be based on Record ID or whatever your key field was but it will show the part number in the picker.
------------------------------
David Hyde
------------------------------
Thank you Dave! I was able to figure it out. I just added a Restricted field to the related table. It's a connected table to another App, I hope it doesn't drop on the next update.
Conor Gray | Leidos
Operational Excellence Lead
Security Enterprise Solutions (SES)
mobile: +1 334-753-4132
conor.a.gray@leidos.comGreat!
------------------------------
David Hyde | Director of Technology, Systems Dev. and Data Analytics
BWW, Inc. dba SERVPRO® Team Wilson
Locations in Birmingham, AL | Dallas, TX | Houston, TX
------------------------------
