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([ped_fechado]=โCanceladoโ,โCanceladoโ,
IF([ped_fechado]=โNรฃo Utilizadoโ,โNรฃo Utilizadoโ,
IF(ISBLANK([nf_venda]),
IF([tipo_ped]=โFaturamentoโ,โEntregueโ,
IF(ISBLANK([data_col]),
IF(ISBLANK([data_ent]),
IF([liberacao]=โOKโ,โLiberadoโ,
IF([status_mat]=โPendenteโ,โMaterial pendenteโ,
IF([status_mat]=โEm Substituiรงรฃoโ,โEm Substituiรงรฃoโ,
IF([status_mat]=โReservadoโ,โReservadoโ,โPendenteโ ))))
,โEntregueโ)
,โColetadoโ)),
โFaturadoโ))))
What is your question?
I am using the isblank command, but the app is not considering
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |