Return Value of Lookup Without Match

[Drew_D]

I’ve got an app that has a form with the sole purpose of scanning a barcode to change the status of the associated record. This part works perfectly.

I want to popup a message if the user scans a barcode that doesn’t already have an associated record. I’m not sure how to do this however I was thinking of something like a lookup that runs after the scan as an action that runs with the status change. Any recommendations?

[MultiTech · Accepted solution]

Hey @Drew_D, welcome to the community.

First: you might check out the following post; it’s full of tons of helpful tips to help you get stared with using the community to find answers.

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

---

To answer your question

• What you’d need to do is create a separate column (I would go with a Show (Header or Text) type) to alert someone that the item scanned wasn’t found, and conditionally show this whenever a result isn’t found.

To do this, I’ve done the following in the past:

1. create a “data entry field” - this is the actual scanner field
2. Create a separate field that does a LOOKUP() based on the data entry field
3. Create a show (header or text) column with a conditional show if statement:

and(
  isnotblank([Date_Entry_Field]), 
  isblank([Lookup_Field])
)

You’ll have to enter some text to be shown for the Show column (this would be the warning text or alert you want the user to see), but this field will only show up when someone scans something, but there’s no result from the LOOKUP()