Skip to main content
A
Andrea28630482rrjp
Participant
March 2, 2023
Resuelto

Nested if function

  • March 2, 2023
  • 2 respuestas
  • 562 visualizaciones

Hi,

is it possible to create an if statement where fieldA is populated with a number if fieldB is filled in with a specific number, but if fieldB is filled in with that specific number and fieldC is filled in with a specific word the result in fieldA changes? 

Este tema ha sido cerrado para respuestas.
Mejor respuesta de try67

Sure, although you also need to specify what will be the value of the field in all other scenarios.

Use something like this:

 

var b = Number(this.getField("B").valueAsString);
var c = this.getField("C").valueAsString;

if (b==6) {
	if (c=="Apple") {
		event.value = "Something else";
	} else event.value = b;
} else event.value = "???";

2 respuestas

try67
Community Expert
try67Community ExpertRespuesta
Community Expert
March 2, 2023

Sure, although you also need to specify what will be the value of the field in all other scenarios.

Use something like this:

 

var b = Number(this.getField("B").valueAsString);
var c = this.getField("C").valueAsString;

if (b==6) {
	if (c=="Apple") {
		event.value = "Something else";
	} else event.value = b;
} else event.value = "???";
    A
    Andrea28630482rrjpAutor
    Participant
    March 2, 2023

    Thank you, it worked!

    Términos y condicionesAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices