I have a medical representative registration app. When changing the representative of a doctor, the requests that are for that doctor changed the representative as well

I have a mysql db and check if the field is empty, but in the formula the field validation does not work. when the data_col field is done, the status field is being filled in as “Coletado” IF([ped_fechado]=“Pedido Duplicado”,“Pedido Duplicado”, IF([p...