Auto-Populating Most Recently Scanned information

[CXIntegration]

Currently, I have a table that will reference and populate Stock Numbers as soon as the associated QR is scanned, however, I have an ENUM column I also need to auto-populate based on the last/most recent scan but I’m not having any luck whatsoever.

[Steve]

What have you tried?

[CXIntegration]

I’ve tried:

• LOOKUP([On or Off], “Scan”, “On or Off”, “On or Off”)
• LOOKUP([Scanned], “Scan”, “Scanned”, “On or Off”)
• IF([Scanned] <> " ", [On or Off].[On or Off],
  ANY(SELECT(Scan[On or Off], ([Scanned] = [_THISROW].[Scanned])

I even created a sheet that is a mirror image of the main table “Scan” google sheet, so I can try to reference but I’m not getting the result I need.

[Steve]

CXIntegration:

• LOOKUP([On or Off], “Scan”, “On or Off”, “On or Off”)
• LOOKUP([Scanned], “Scan”, “Scanned”, “On or Off”)

You’re using LOOKUP() incorrectly.

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

CXIntegration:

[Scanned] <> " "

This isn’t doing what you think it is. Read more:

https://community.appsheet.com/search?q=@steve%20quirk

[Marc_Dillon]

This may help too.

help.appsheet.com

MAXROW()

Row with greatest value in column