Solved

Check quantity from List to List

  • 19 April 2017
  • 2 replies
  • 3 views

Badge +2

Hello Everyone
I have a k2 form whiche make the employee able to order PC
so let say that an employee want to order a PC , after he send the request
his manger can't click OK until the form make sure that the warhouse is empty and there is no PC so
the manger can esculate the order to the main warhouse.

so if there is PC's in the local warhouse the Order does not pass the manger

 

 

15948i8E1C8BEF248FB859.png

as you see in the picture the first view is what the employee want to order .
Laptop and DEsktop
the second view is what the local warhouse has right now
so the order can not be accepted unless the Item balance is 0
i hope it's clear

best regards

 

icon

Best answer by Kran 19 April 2017, 14:39

View original

2 replies

Badge +9

 

Hi ShlbAh,

 

  To achive this you can't  use smartform rules directly, In this case you have to use For-Each Loop which is available under conditions in rule designer.

here you have to use multiple loops (2 loops) 1 for Employee request list and second for Warehouse list , where for each item requested by employee need to check with item  quantity available in wharehouse.

 

let me know if it helps you.

 

 

 

 

 

 

Badge +2

thanks Karan

it's working perfectly

appreciate your effort

Reply