Can't insert from weweb > supabase

Hello. Have a problem with inserting from WeWeb > Supabase.

It used to work, but now it doesn’t work. Now it asks for a specific ID number to add, but previously it assigned a number automatically, based on the rows.

image


image

Hi @david :wave:

Ah yes, it’s happened to me before on a personal project.

I think it’s when the sequence of the ids in the Supabase table is out of sync. So maybe you have items 1, 2, 3, 5 but not 4

There might be a better way but I fixed it by using UUIDs instead of sequential IDs in Supabase.

Somewhere on the forum is a topic where a fellow nocoder fixed the sequence and posted the query. You’ll need to look for it, I know I saw it here as I was solving that one with him in that moment

Looks like, it’s a problem if you import data as .csv

Anyways, I put it as random UUIDs, thanks.

1 Like