Adding data to new record with URL formula but having problems with order of operations

Te other option is to wrap a field that might be null with

Nz([my field])

The Nz() function will turn a null into a zero, else just the value it is, if not null.

But I really try to avoid that as it clutters up the code.