nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

429313_en-US

liliconcom

Make IsMissing work more intuitively

Pop quiz!

Question 1

Suppose you have a function GetCurrentValue which gets the current value of user certain interface objects, and returns missing (.) for others. Suppose you have a list of interface objects (AllInterfaceObjects).

Will this work?

UserValues = Transform Each({object}, AllInterfaceObjects, GetCurrentValue(object));
FilteredValues = Filter Each({value}, UserValues, !Is Missing(value));

Answer:

Question 2

As you may or may not know, Create Database Connection is a function for creating database connections. It returns a database connection on success, and missing on failure.

Does this work?

connection = Create Database Connection(magicString);
if( !Is Missing(connection), 
    RunSomeQuery(connection),
    Print("I have failed to connect")
);

Answer:

My Proposal

Make the use of missing (.) and Is Missing more disciplined.

Do not magically thread the function through lists, tell me if the variable holding the list is missing or not.
If Is Missing cannot handle your success, do not use missing to signal failure.

Scripting

Comments

Quick Links