Can I change the value of a calculated column?

Hey there again! I'm back with another question.
So I made a table that has a calculated column called "status". It takes the values from both the startdate and enddate to see whether a booking is expired or still pending.

However, I want to add another function to this column. I would like to be able to change the value of the column to closed or re-opened at the press of a button or any type of selection component in the check in menu.

Are you saving this to a database? If so the Action button can trigger a query to update the row that is selected and then reload the table.

1 Like