I've taken the PO Approvals Template a step further and am attempting to add an item type (Hardware, software, Office Supplies, etc) and assign a purchaser to each of those item types. When a purchaser is assigned and the approval process is complete then the purchaser gets notified and they make the purchase. I am making good progress and I'm confident it will be an easy addition.
Here is what I have so far...
New table M_Fullfillment
The main table (that I renamed to "Purchasing Approvals") I added two columns, "Item Type" and "Purchaser"
The issue I'm having is with the "Purchaser" column. I would like it to auto populate the purchaser as it corresponds with the Item Type. So when Hardware is selected the Purchaser column displays the person assigned to the Type in the M_Fullfillment table.
My best attempt was this...
=FINDROW(M_Fullfillment, "M_Fullfillment[Type]=%",A_Purchases[Item Type]
I tried both of them that you gave me as well as typing it in manually using the autofill options to make sure I didn't misspell anything.
Still giving me the error.
