The Supabase 'Create a row' module requires data for the ID field, even if it's supposed to auto-increment

How To
, ,
1

I’m struggling to get Make.com’s Supabase connector to auto-generate IDs when creating new rows. I’m not sure if the issue is in how I’ve set up the ID in Supabase or how I’m using the ‘Create a row’ module.

My Supabase table has an auto-incrementing ID (‘Is Identity’), but the Make.com ‘Create a row’ module insists I provide a value for the ID, giving me a ‘Value must not be empty’ error. I’m not sure why it’s not auto-generating.

2

Welcome to the Make community!

If you provide a random value in the ID field, does it still auto-increment the new record, or it uses the provided value?

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Hi @samliew, unfortunately, auto-incrementing isn’t working and I’m getting an error:

Bildschirmfoto 2025-03-04 um 16.41.17
Bildschirmfoto 2025-03-04 um 16.41.17890×820 73.4 KB

4

In that case, it looks like a bug.

For technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to.

You can open a new ticket here, or if you are unable to login for some reason, you can create another new free account to access the ticketing system (which is only available to logged-in users). After submitting a new ticket, you will receive an automatic confirmation email with the subject “Ticket Created” in the subject. If you do not receive this, try sending the ticket again.

If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

5

Thank, I created a ticket in that regard (#1488988 ) and will let you know if s.th. comes out of it:

Description:

When using the Make.com Supabase connector’s “Create a Row” module to insert new data into a Supabase table with an auto-incrementing ID column (“Is Identity” enabled), the module incorrectly requires a value for the ID field, leading to a “Value must not be empty” error. This prevents the expected automatic ID generation.

Steps to Reproduce:

  1. Create a Supabase table with an integer column configured as an auto-incrementing identity column (“Is Identity”).
  2. In Make.com, create a scenario using the Supabase connector’s “Create a Row” module targeting the aforementioned table.
  3. Attempt to map data to the other columns in the table, leaving the ID field blank.
  4. Run the scenario.
  5. Observe the “Value must not be empty” error for the ID field.
  6. Attempt to pass a random value to the ID field.
  7. Observe that the auto-incrementing function is not working, and an error is generated.
  8. Attempt to pass ‘ignore’ or ‘null’ values to the ID field.
  9. Observe that the auto-incrementing function is not working, and an error is generated.

Expected Behavior:

The Make.com Supabase “Create a Row” module should recognize the auto-incrementing ID column and automatically generate a unique ID value without requiring user input.

Actual Behavior:

The module requires a value for the ID field, preventing automatic ID generation and resulting in a “Value must not be empty” error.

Environment:

Make.com
Supabase Module ‘Create a Row’

1 Like
6

I resolved the problem by bypassing make.com for the initial data ingestion. I created a custom webhook using JavaScript within Cloudflare Workers, which directly writes data to Supabase. Then, I leveraged Supabase’s insert webhook to trigger my make.com workflow.

3 Likes