In that case here’s what you need to do…
In backend workflows add a new API endpoint, and uncheck the ‘expose as public endpoint’ box.
You’ll need to add a parameter of the type ‘whatever datatype it is that you want to change the field in’ - unless it’s a ‘user’ datatype, in which case you don’t need to use any parameters.
Add a single action in the workflow to ‘make changes to a thing’ and select the type of thing to make the changes to…
If its a user just select ‘current user’ and if it’s something else then select the name of the parameter that you added in the first step.
On that action, click to add another field and select the field ‘Status’, and enter that value you want to it change to.
- Then you just need to schedule this workflow to run on whatever thing it is you want to change, at the date/time stored in that thing’s ‘End Date’ field.
The most likely way you’d want to do that (although it depends on how your app works and how it’s set up), would be to do that in the same workflow that set the ‘End Date’ in the first place.
So wherever that workflow was, after you set the End Date, in the next action schedule the API workflow to run on that thing, on the date/time of that end date.
Then, once that End Date is reached, the workflow will run and change the status field to whatever value you set in the workflow.
It sounds more complicated than it is, but have a go and see how you get on.