Default value if value = null

[DavidRasner1]

Hello,

I was wondering if anyone maybe knows how to format a dynamic text value (attribute) with a default value if empty. I would prefer to do it via UI, not in the DB.

Something like:

If missing then "Missing value"

else {Attribute}

I couldn't find any info on this.

[DanJiang · Accepted solution]

Hi @DavidRasner1 , 

You can use the Expression instead of the Attribute in Dynamic content. Set the expression name as the default value you want and configure the expression content as the attribute. 

[HowieBrown]

This is way past awesome ... I have searched everywhere for this and where to do it. I need this because the First_and_Last_Name field is not mandatory in the survey, but I need the field to have Anonymous in it if they leave it blank - - - The Data base that imports the results can not be null.. Setting it up as a Default would cause problems on the end ...

Anyway - Thank You So Much !!!!!

[DavidRasner1]

Ah, thanks!

[AvaPatterson]

I tried to do this with a date field I have within a list. I want it to display "Pending" If it's NULL. The populated dates show up but the empty ones still don't show anything. Does this not work on a date field?