Welcome to the community, @airtableuserdude! :grinning_face_with_big_eyes: Sorry that your questions went unanswered for so long. There’s a lot of activity here, and it’s hard to keep up with everything (says the guy who feels compelled to keep up with everything!).
Airtable’s barcode scanning only reads the code numbers. If you want to pull in more than that, you might be able to do it using a script in the Scripting block. I haven’t checked, but there may be a public API you could query, sending the barcode number and retrieving other details about the product. Just a stab in the dark, though.
Regarding the range idea, one simple solution is to write a formula that looks at your entered value and outputs a plain text label indicating the range. Formulas can only control their own output, though. They can’t change other fields. You could also use another Scripting block to update the range values from time to time, but that would require manual triggering of the script. A third option would be to take the new scripting action beta for a spin. It takes some setup to get it working, but you could develop a system that updates a range option in a single-select field when you change the price. This beta might also be useful for your UPC scanning idea.
If you’d like help with any of these ideas, just holler!
