topic Default value if value = null in ArcGIS Experience Builder Questions

Default value if value = null

DavidRasner1 — Wed, 14 Sep 2022 15:38:24 GMT

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.

Re: Default value if value = null

DanJiang — Thu, 22 Sep 2022 06:49:15 GMT

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.

Re: Default value if value = null

DavidRasner1 — Mon, 26 Sep 2022 10:27:06 GMT

Ah, thanks!

Re: Default value if value = null

HowieBrown — Sat, 24 Dec 2022 13:34:08 GMT

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 !!!!!

Re: Default value if value = null

apgis16 — Tue, 21 Nov 2023 16:59:13 GMT

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?

Re: Default value if value = null

LindsayWithers1 — Wed, 04 Dec 2024 23:17:49 GMT

I'm having the same problem, but on a numeric field. Did you ever get the Expression name to work for null values on your date field?

Re: Default value if value = null

apgis16 — Wed, 18 Dec 2024 18:23:30 GMT

No 😞