Hi all....so I'll give you a bit of a background on what my app is before I ask for the help. I have built an inventory app for a department here at our school district. I created it from an Excel spreadsheet. The first screen is a gallery that lists all of the items, the second screen is a detail screen for the item and the third screen is an edit form. The database includes things like item, description, location, status, asset tag #(barcode), etc. What I am trying to do is integrate a barcode reader into my edit form so a barcode can be scanned and in turn update that data card value and the Datasource. The issue I am running into is this: I scan a barcode, and it then updates my data card value and data source for that item. When I go into another item to edit the barcode, it is displaying the barcode that was scanned on the previous item. I would like to have it display the info from my data source (whatever barcode is in my data source or in some cases it may be blank). Let's say I go to edit an item, navigate to the edit form and I scan a barcode #17210, it updates the data card value and my data source for that item, I save and go back to my item gallery. I go into a second item, navigate to the edit form, that item already has a barcode in my data source #24685 but the data card value on the edit form doesn't show that # it shows my previously scanned #17210. How do I get the data card value to display the information from my Excel database unless I choose to scan a new barcode. I have done a lot of searching for answers in forums and utilized ChatGPT and so far, none of those suggested formulas are working. Any help I can get would be much appreciated.
Share
Report
All responses (
Answers (
53,685
