I have a tasks table that has a Duration field. When i create the task i need the field to be optional because i can't always tell how much time it will take me to do that task. Only when i finish the task (by changing another field named "status") i need that field to be mandatory.
I have tried recreating the form rules in some way or another. I have played around with having the fields mandatory/not-mandatory, from the fields section of the table and from the form, with no luck. Last i have tried automations but they don't let me use blank values for the duration (i set a dummy value for the duration when an item is created and then erase it with the automation to get my desired result).
