Switch Rule

[Duplicates]

In my excel file I have a column called First (for first names) some of the fields are blank and I want to make those blank fields say Group Leader, but I want to keep the other names i have already in there. Any ideas?

[Duplicates]

right now my rule says, if "first" = "z" return "Group Leader"

[LesSjo]

Try this out...

 

if (Field("First")) {

return Field("First");

} else {

return "Group Leader";

}

[Duplicates]

didnt work, now everything just says First.

[Alex Marshall]

if(Field("First")!="")

return Field("First")

else

return "Group Leader";

 

Check the box for "Treat Return Strings As Tagged Text". Also, make sure your field name matches your data file.

[Dan Korn]

return Field("First") || "Group Leader";