Patch after 15 collects

[Pseifert]

Hello,

I have an order fulfillment app that uses a barcode scanner to scan product, then the order handler places the order in the box and submits. On submit, the record updates in SQL server and upticks the qty filled by 1. We seem to be having issues where too many calls are being made and these records are not being updated properly and data lost/overfulfilled due to the 10-15 seconds between each call. Is there a way to save to a collection and then bulk patch with forall after 15-20 orders are filled?

Thanks!

[sayyed007amir]

Yes you can use this condition:

If(CountRows(Collection)>15,ForAll(your patch code) )

[v-bofeng-msft · Accepted solution]

Hi @Pseifert :

Could you tell me if you want to implement the following functions:

• Generate the scan result as a record and store it in a collection.
• This collection stores up to 15 records.
• When there are 15 records in the collection, the system prompts the user to submit.
• After the user clicks the submit button, these 15 records will be added to the data source at once, and then the collection will be emptied.
• Loop the above operations.

I assume my assumption holds.

I've made a test for your reference:

My Date source:'[dbo].[Table_2]'

Field Name	Date Type
barcode	varchar(50)
upticks	int
id	int/Primary key

1\Add a BarcodeScanner control(BarcodeScanner1)

OnScan:

If(
    CountRows(mycollection) > 15,
    Notify("Cache is full, please submit data"), /*When the collection storage record reaches 15, it prompts the user to submit data in time*/
    Collect(
        mycollection,
        {
            barcode: BarcodeScanner1.Value,
            upticks: 1,
            id: CountRows('[dbo].[Table_2]') + CountRows(mycollection) + 1  /*id is the Primary Key of my data source*/
        }
    )
)

2\Add a button

OnSelect:

Collect('[dbo].[Table_2]',mycollection);Clear(mycollection)

Use collect to submit multiple records at once to avoid calling the API multiple times. Clear the collection after submission.

Best Regards,

Bof