Can I use IFS() expressions in templates?

[jcmoras]

Hi, I allready using IF expressions in templates.

https://support.google.com/appsheet/answer/11568425?hl=en&ref_topic=11445504&sjid=194117038092938038...

but , I am trying to use IFS() and I cannot figure it out.

Im searching for some example or information, cant find it yet.

[AleksiAlkio]

Yes you can use IFS() as well. Would you please provide what have you tried so far..

[Suvrutt_Gurjar]

Hi Aleksi,

Sorry, I missed seeing your reply when I replied.

[AleksiAlkio]

No worries.. response was the same 🙂

[Suvrutt_Gurjar]

Yes, true 🙂

[Suvrutt_Gurjar]

Yes, you can use IFS() expressions in templates in general. 

You may want to share any specific implementation if you want , then community could share more details on exact feasibility for your requirement.

For example, the following is a working example of IFS() in a template.

<<IFS([State]=”WA”, “Washington”,

           [State]=”MN”, “Minnesota”)>>

[jcmoras]

Hi Suvrutt_Gurjar,
I have 4 conditions with AND() expression, like this:
(AND([SISTEMA]=”ABRIR”,[D4]=”70INT”,[COEF19]=”PLACA”,[CANTHOJAS]=1)

Then the values  for those conditions or something like this

([PRG]=HOJA_DOBLE_ACTIVA.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;
[PRG]=HOJA_DOBLE_PASIVA.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;

this is what i have so far:

<<Start:[PUERTAS]>>

<<IFS(AND([SISTEMA]=”ABRIR”,[D4]=”70INT”,[COEF19]=”PLACA”,[CANTHOJAS]=1,[MANO]="DERECHA"),
([PRG]=HOJA_OPT.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;),

AND([SISTEMA]=”ABRIR”,[D4]=”70INTD”,[COEF19]=”PLACA”,[CANTHOJAS]=2,[MANO]="DERECHA"),
([PRG]=HOJA_DOBLE_ACTIVA.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;
[PRG]=HOJA_DOBLE_PASIVA.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;),

AND([SISTEMA]=”ABRIR”,[D4]=”70INT”,[COEF19]=”PLACA”,[CANTHOJAS]=1,[MANO]="IZQUIERDA"),
[PRG]=HOJA_OPT_IZQ.pgmx;[DX]=<<ALTO HOJA PANTOGRAFO>>;)>>

<<End>>

[jcmoras · Accepted solution]

Solved.

<<Start:[PUERTAS]>><<IFS(AND([SISTEMA]=”ABRIR”,[D4]=”70INT”,[COEF19]=”PLACA”,[CANTHOJAS]=1,[MANO]="DERECHA"),
CONCATENATE("[PRG]=HOJA_OPT.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[ANCHO HOJA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";"),
AND([SISTEMA]=”ABRIR”,[D4]=”70INTD”,[COEF19]=”PLACA”,[CANTHOJAS]=2,[MANO]="DERECHA"),CONCATENATE("[PRG]=HOJA_DOBLE_ACTIVA.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[HOJA ACTIVA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";","
","[PRG]=HOJA_DOBLE_PASIVA.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[HOJA PASIVA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";"))>><<End>>

[Suvrutt_Gurjar]

Great. Thank you for the update.