* Replacing missing surname in source title

[JoopvB]

Some persons in my database have no surname.

When using {Persoon:REVERSE} in my template title field, I end up with a starting comma.

I Thought to fix that by prefixing it with: {=NotExistsText(%SOUR.~NM-PERSOON>NAME:SURNAME%, "NN")}.

But something must be wrong since it's not accepted. Help is very much appreciated!

[tatewise]

The problem is =NotExistsText( ... ) requires an unqualified data reference, so qualifier :SURNAME is not supported.

Use the =TextIf( ..., "NN") function instead:

{=TextIf( %SOUR.~NM-PERSOON>NAME:SURNAME% = "", "NN" )}

[JoopvB]

@Mike

I replaced the Not Exist with TextIf but still get the error. Any ideas?

[tatewise]

Maybe it does not need the NAME tag as it is already a Name meta-field so try:

{=TextIf( %SOUR.~NM-PERSOON:SURNAME% = "", "NN" )}

[JoopvB]

Yes, that's it.

Thanks Mike!