What does this script do?

wynnjimbbt — Wed, 25 Nov 2020 16:16:04 GMT

SET AltString=

if(NOT IsNull($1), $1,

if(NOT IsNull($2), $2,

if(NOT IsNull($3), $3,

if(NOT IsNull($4), $4,

if(NOT IsNull($5), $5,

if(NOT IsNull($6), $6,

if(NOT IsNull($7), $7,

if(NOT IsNull($8), $8,

if(NOT IsNull($9), $9, '')

)

);

/*********************************************************************************************

Re: What does this script do?

swuehl — Fri, 27 Oct 2017 17:41:03 GMT

I guess it should do similar like Alt() does for numeric values, i.e. return the first not null argument (also for text values)

Use it like this (with up to 9 arguments, but you can use less)

=$(AltString( argument1, argument2, argument3, ...., argument9))

edit: you need to use a dollar sign expansion

Added this link

argument1 to argument9 can be a numeric or text value or NULL

edit2: for example

=$(AltString(Null(), vVariableNotExist,'Text2'))

in a text box will return Text2 value