Hi There
I am currently looking to build an approval workflow.
Part of this is sending an approval request if the price charged for an item is less than the "wholesale price"(which is a price level) for that item
to do this, I assume I will need to create a script which searches for the price for the given item; price level ("wholesale price" in this case) and quantity
For example: I would need to be able to search for the price for:
-50 piece tool kit (item)
-3 units
-wholesale price level
I was wondering whether this is possible with a server side script?
Ideally, I would want this function in a server side script to since I assume having this search on the client side (for example, a client script which triggers after the quantity is entered) would slow down the performance of the record in the browser. Is that correct?
If I did this as a server side script, would I be able to use a map reduce script (which triggers after the record is saved using a combination of a workflow action script and map reduce) to carry out the search and then update the transaction's fields (e.g. setting the status of the transaction to "pending approval"?
thanks