IF GetFieldValue Formula?

Question

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 enters a Part Number "12345" in the the part number field. Another field looks in another table for Part Number "12345" and returns the text "Out of Stock" or some other text.I gather it is probable a combination of If and Get Field Values.Thanks for your help!------------------------------Conor Gray------------------------------

DavidHyde · Answer

This is possible,

Are you trying to make it automatically count off of an inventory or are you manually managing inventory and you want to see what the status of an item is?

Both are possible but one is a little more complex than the other.

------------------------------
David Hyde
------------------------------

Sign up

Login to the community