Re: state change error

khangLixil · 12-11-2022 05:51 PM

Hi everyone
I have a problem I need someone to solve
I have described as shown below. When filling out the form, it will be 1-Created, Press 2 action buttons, ORDER STATUS will deploy as shown.

i tried using ifs function but it only get ORDER STATUS = 7.0-Waiting User Approve and 1-Created, and 7.2-User Change it doesn't accept. I do not know why. I have taken the code as shown below
Anyone know please help me
Thanks

dbaum

The expression you screenshotted is in the column's Initial value property. Maybe you mean for it to be in the column's App formula property?

khangLixil

No. i want it to be in the Initial value property.
And I want it to take all 3 values, not 2.
Do you have any way?

dbaum

I still don't understand what you want the app to do.

Maybe you need to enable the column's Reset on edit? property.

khangLixil

i have enabled column's Reset on edit.
What I want to ask here is that ifs it will receive all conditions but why mine it only accepts 2, and 1 condition, it does not accept

dbaum

I'm sorry, but I still don't understand.

In case you don't already realize, the IFS function returns the result of only the first condition that matches.

Consider replying here with a table that outlines what value you want in [Order Status] for each possible combination of blank and not blank in [Estimated delivery date] and [Date User Change].