How control multi user in stock transfer creation?

App Building
1

Hi i have an inventory management system and have one transaction named stock transfer to move example Product XYZ from warehouseA to warehouseB.

image
image1393×376 36.4 KB

in this screen user fills all required fields that works and it saves info to a mysql tmp table, but what happen when i got 2 users that may create that stock transfer transaction? if both user save to the tmp table will generate bad transactions . what you guys recommend me?

thank you

2

My Advice would be to use JS to check if that stock transaction already exist before saving

1 Like
3

I think with localstorage I may control this, first using localstorage then before generating real transaction user click Generate button and it will save all to MySQL db with their userid from retool