Supabase UPDATE function: How to reset/clear a Field?

Questions
1

This should be really simple, but to this point I was not able to reset a Row Value to NULL via Update.
There is also no Error Feedback, simply no Output.

I tried [null], null, 0, ‘’

nothing worked. only when I add new values in the correct format.

How to reset a field in a supabase database to NULL via Update?

Screenshot 2023-01-06 at 13.27.51
Screenshot 2023-01-06 at 13.27.51958×711 35.7 KB

Screenshot 2023-01-06 at 13.29.50
Screenshot 2023-01-06 at 13.29.50940×286 9.42 KB

Information on your n8n setup

  • n8n version: 0.209.4
  • Database you’re using (default: SQLite): Supabase
  • Running n8n with the execution process [own(default), main]: own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: n8n.cloud
2

Hey @ourHDC,

Have you tried {{ null }}?

2 Likes
3

Thanks @Jon , that did the Job!!

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.