I have a supabase database and it has a primary key(id) that’s supposed to auto-increment but the problem is the supabase module in make requires you to map something to the id field.
This describes my problem exactly: MySQL "required" Primary Key - #5 by Catalina
Unfortunately, using the ignore function throws an error.
Please help.
Welcome to the Make community!
You have not yet provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any error(s).
To allow others to assist you with your scenario, please provide the following:
Could you please share screenshots of your full scenario? Also include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see what you’re working with to give you the best advice.
You can upload images here using the Upload icon in the text editor:
We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and prevent tracking cookies from third-party websites.
Perhaps you can also try the special variable {{ignore}} in that field.
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.
Hi Sam!
The link I provided is from a community post here on Make.
I did it so people have a lot more context to the problem because screenshots alone may not explain enough.
I see you also give the same solution that did not work as I mentioned using the ignore special variable did not work and if you checked the other topic which I linked in my complaint, you will see it mentioned too.
At the end of the day, I think it’s a bug.
I settled with using the HTTP function and working directly with Supabase API to bypass the bug.
Yeah, I got an error with that field in Make too. I ended up deleting the column in a new database.
In supabase? I think you cannot edit or make changes when there’s no id column in your table, right?
If this is a bug, please contact support as they have access to server-side logs and internal tools and resources, which allow them to investigate more thoroughly.
You can open a new ticket here, or if you are unable to login for some reason, you can create another new free Make 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.