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"
Item Type was easy to get working.
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]
Am I on the right track?
Thanks in advance!