Preventing Duplicate Form Submissions

Ask the community
,
4

I don’t know your collection schema, but I’ll assume you have a memberId filed that contains the memberId.

Then you can either do without concat:

//backend/data.js
import wixData from 'wix-data';
function lookUpForDuplicates(item, collection){
    let today = new Date();
    today.setHours(0,0,0,0);
    return wixData.query(collection)
        .ge('_createdDate',  today)
        .eq('memberId', item.memberId)
        .count();
}
export function Employees_beforeInsert(item, context) {
return lookUpForDuplicates(item, context.collectionName)
.then(r => {
    if(r){return Promise.reject('already submitted');}
        return item;
    })
}

Or with concat (shorter and works even if the same user submits 2 forms from 2 browser tabs at the same time):

export function Employees_beforeInsert(item, context) {
     let today = new Date();
      today.setHours(0,0,0,0);
    item._id = item.memberId + "--" + today.getTime();
     return item;
}