Increment values in bulk

I have a function that sends notifications and I'm storing the total # of notifications sent in my db. What's the best way to increment this value from the js client without a for loop?

const { data: updatedSigners, error: e2 } = await supabase
    .from('contract_signers')
    .update({
    last_notification: now.toISOString(),
    total_notifications: ?????
})
    .in('id', signers.map((signer) => signer.id));

const { data: updatedSigners, error: e2 } = await supabase
    .from('contract_signers')
    .update({
    last_notification: now.toISOString(),
    total_notifications: ?????
})
    .in('id', signers.map((signer) => signer.id));

const { data: updatedSigners, error: e2 } = await supabase
    .from('contract_signers')
    .update({
    last_notification: now.toISOString(),
    total_notifications: ?????
})
    .in('id', signers.map((signer) => signer.id));

const { data: updatedSigners, error: e2 } = await supabase
    .from('contract_signers')
    .update({
    last_notification: now.toISOString(),
    total_notifications: ?????
})
    .in('id', signers.map((signer) => signer.id));

vick•12/15/23, 9:32 PM

where from does the value for total_notifications come? Is it part of the signer object? Is it computed from some other table in your database?

bennettcohenOP•12/16/23, 4:21 PM

it's a column in my db that I just want to increment by one

Increment values in bulk

Similar Threads

Similar Threads

Similar Threads