Forum | Appery.io

helped me out as well, this is a common feature of most apps seems like there should be a tutorial or something to make it more easy

I have a sort of a similar issue. I am still new to this, but the above answer I could not relate to but I'm sure it's something that I'm doing. Basically, I want to use the barcode to scan a UPC, then have it query the database (CSV i've imported) and display the description. Seems simple enough, now let me tell you what I've done:

I'm using 2 services, barcodescanner, and a wharehouse_UPC_Query service...

Barcode scans it, and returns 3 fields, Text, format, cancel, with Text also mapping to a local variable called "code" (basically the UPC code again, to be resubmitted in the query. This is where it gets fuzzy to me.

I'm not sure if the barcode response is making it to my code variable, I have no way of knowing. If I test and use the parameters where {"UPC"="code"}, I get nothing. I'd like to do it all without adding any JS and as simple as it is, I would think I could do that. But like I said, I'm not sure if the response is being stored into the variable, how can I tell?

Also, the response from the query_service does pull the description, but it's only the first record in that column of the database in alphabetic order. Meaning if I do a test
from within the query_service, I get back the entire collection, and whatever is first in the description is what I get back, I need to make sure this returns the correct value or the correct code being submitted.

I think the problem is lying somewhere with the code value that's being submitted from the stored variable.

Thanks for all your help, I'll continue to search and play around...

Jason

I think I'm going to work my way through this one. I've created another input box on my startpage, and until I see that the UPC code that's coming back from the barcode scan is actually correctly showing up in my test input box. Sounds like a plan...

Hello Jason,

Thank you for the update!

hi victor,

I've tried ur example 3. but the data display all from the db although I've define my id.

can you assist on this?