Consecutive duplicate scans

Sai_bhargav

Hi guys
In my appsheet i want to scan same barcode mutliple times in a single box continuously and a counter to update number of times its scanned. I tried achieving that with concatenate and also with list, but both are not accepting consecutive duplicates.
Any one can help me here pls?

Rafael_ANEIC-PY

Hello there,

I'm guessing you need 3 columns in a table for that, one for the ID using UNIQUEID() other for the Scan field, and another for the Scan Counter.

For you to be able to quickly scan barcodes back to back, you should hide the ID and make the Scan Counter a non editable app formula.

Is this what you currently have going on? if you do, what's the issue then?

Sai_bhargav

Yes, how can i increase counter before submitting form by scanning in same box consecutively.

Also there is only one unique id for one form entry

Rafael_ANEIC-PY

@Sai_bhargav wrote:

Yes, how can i increase counter before submitting form by scanning in same box consecutively.

Use an expression such as this one as an app formula or an initial value in the counterColumn:

COUNT(
 SELECT(
  scansTable[scanColumn],
  AND(
   [_RowNumber]<=[_THISROW].[_RowNumber],
   [scanColumn]=[_THISROW].[_RowNumber]
  )
 )
)

@Sai_bhargav wrote:

Also there is only one unique id for one form entry

Yeah, so 3 columns correct? idColumn, scanColumn and counterColumn