Need correct formulas for both issues who can help

[Jeanlem]

I am turning in circles here can some one help here is my issue.

I created and apps with share point inventory every thing is good I can edit and add inventory and quantity but missing the following.

• I want to add a bar code scanner to add quantity in my SharePoint
• I also have multiple location where I have the same inventory need to select that location before I start scanning
• example (location J2G need to scan 60 items) (Location Quad need to scan 90 items) I would also need to filter them by location and see there inventory's 

I need both formulas I cant make it work need solutions 

here is a picture of my share point list let me know if I need to add any columns 

thank you, 

[EricRegnier]

Hi @Jeanlem, Is your data also in CDS and is integrated with a SharePoint list? Also, I would suggest to try the SharePoint community to get additional support: https://techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint

Thanks,