Status Button, how to!

Karthick_pk · 2024-11-27T07:24:35.608+00:00

I want my button to change the status of an existing column in supabase. On click of a button it should change the Pending to In Progress and to Completed. How to achieve this in toddle and supabase?

Karthick_pk

8 months ago

I want my button to change the status of an existing column in supabase. On click of a button it should change the Pending to In Progress and to Completed. How to achieve this in toddle and supabase?
Armand

8 months ago

Have a look at this video (from 40min onwards): https://www.youtube.com/watch?v=SHJ3EadcrgY

Andreas updates one column on a row in Supabase there, exactly what you are trying to accomplish as well.
Karthick_pk

8 months ago

Our status column have 3 to 4 transitions, and in supabase we mentioned the stages in numeric format like 1=Pending, 2=Open, 3=In Progress, 4 = Completed. Trying to show the status in button text using the formula and on click need to update the status from 1 to 2 and if it is already in 2 then to 3.

The video seems to be for open and closed kind of task function.
Tod

8 months ago

Great energy @Karthick_pk! Your continuous contribution to the toddle Community just made you advance to Community Level 1!
@Karthick_pk
Our status column have 3 to 4 transitions, and in supabase we mentioned the stages in numeric format like 1=Pending, 2=Open, 3=In Progress, 4 = Completed. Trying to show the status in button text using the formula and on click need to update the status from 1 to 2 and if it is already in 2 then to 3.

The video seems to be for open and closed kind of task function.
Tom Ireland

8 months ago

I read a good article a while back on handling statuses and other similar related data. For bedtime reading, see https://dev.to/houseman/a-better-way-to-store-record-status-in-a-relational-database-2ik1

In your case, it would be a good idea to store the text value in relation to the id, which means you can query based on the id but return the textual value. This would be a lot easier for managing on the front end and you’re always guaranteed some level of consistency.
Tom Ireland

8 months ago

This means that you likely won’t need a formula to check against the id and can just apply the textual value. If storing lowercase in the db, there is a formula to transform that to sentence case.

Status Button, how to!

Karthick_pk

Armand

Karthick_pk

Tod

Tom Ireland

Tom Ireland