UPDATE FIELD FROM ANOTHER CONDITIONS

[Tecnopica]

Dear experts,

I am new to AppSheet and I am learning with tutorials and the posts that are published in this community.

Thanks for your time. Now I have a problem and I need your help.

In my app I have three fields:

UD (Number)

COMPRARSINO (Color: Green and Red)

BOOLEANO (Yes/No)

The idea is that when [UD] >0 the field [COMPRARSINO]=Green and the field [BOOLEAN]=Y .

On the contrary when [UD] =<0 the field [COMPRARSINO]=Red and the field [BOOLEAN]=N.

I have tried an IF in the formulas, but it doesn’t work.

Thanks for the help, I will continue studying with you.

[dbaum]

In the App formula property for the BOOLEANO column, you could use an expression like the following, which is similar to what you seemingly already tried. If this doesn’t work, you should elaborate regarding what you’ve configured and what’s not working–probably including screenshots.

AND([UD] > 0, [COMPRARSINO] = "Green")

If the issue is that you don’t want “Y” or “N” when UD > 0 and COMPRARSINO = “Red”, then you probably need a different data type (e.g., ENUM) for your BOOLEANO column.

[Tecnopica]

Correction to the formula:

AND([UD] > 0, [COMPRARSINO] = “Green”)

Thanks for your contribution.

It works with the [UD] field, changing it updates the [BOOLEAN] but doesn’t update the [COLOR] field.

With the COLOR field it updates BOOLEAN, as long as UD is not = 0

Something is wrong.

[Tecnopica]

?

[dbaum]

@Tecnopica

The idea is that when [UD] >0 the field [COMPRARSINO]=Green and the field [BOOLEAN]=Y .

On the contrary when [UD] =<0 the field [COMPRARSINO]=Red and the field [BOOLEAN]=N.

I misread your goal. I think what you want is as follows.

Column	App formula
COMPRARSINO	<br>IF([UD] > 0, "Green", "Red")<br>
BOOLEANO	<br>[UD] > 0<br>

[Tecnopica]

Thank you very much.

The latter does work. All perfect.

Cheers

[Tecnopica]

Dear experts, continuing with this matter, I want to complicate it even more and I need your help.

I have these columns:

[ITEM] ----> Type BOLLEANO
[TOTAL TICKET] ----> Virtual Column --> TIPE PRICE
[CAMBIAR ITEM] --> Type NUMBER
[MENSAJEITEM] Type TEXT

App Formula:

IFS(
AND([ITEM]=FALSE,[TOTAL TIKECT]<0),
"Click en el Carrito...",
AND([ITEM]=TRUE,[TOTAL TIKECT]=0),
"Un momento por favor...",
AND([ITEM]=TRUE,[TOTAL TIKECT]>0),
"Calculo de su Pedido..."
)

I need the initial value of the column

[MESSAGEITEM] = "Calculo de su Pedido......"

The options of

[ITEM]=FALSE,[TOTAL TIKECT]<=0

They are saved THIS WAY when entering the form, therefore they are already in the table.

Now the Text should change in the column

[MENSAJEITEM]

[MENSAJEITEM]

according to the values ​​of the columns

[ITEM]=TRUE,[TOTAL TIKECT]=0 --> "Un momento por favor..."
[ITEM]=TRUE,[TOTAL TIKECT]>0 --> "Calculo de su Pedido..."

Sorry for my clumsiness, I tried applying the previous example but I was not able.

Gracias por su tiempo. Happy 2023, Thank you for your time.

[Steve]

Please start a new topic for help with this.