Serial Number Verification

We have a database of 90K serial numbers, and I’m trying to design an app for users to submit their serial numbers for a rewards program. Users currently can add / submit the serial numbers, but there is no verification or redlining of the serial number to prevent duplicate submission. There is nothing to notify them of a submission error or typo.

I’m not sure how most efficiently this would be done, but I’m currently tinkering around within the Simple CRM template. FYI

1 Like

Hi John,

You can create a user-specific column to store the user’s input in a field, then make a relation from that field to the existing serial number column to verify that it has not existed in your database.

If the relation is empty, you let them submit and vice versa.

1 Like

He has a database of 90,000 serials. Glide does not support this many rows.