How control multi user in stock transfer creation?

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

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

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

1 Like

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