Blank value result

[Kuroshi]

I have two fields [@field:Field1] +  [@field:Field2]

If the first field 1 has a value and the field 2 is blank, it does not give a result. it is always blank. 

Can you help?

[Barbie]

Hi @Batchini

 

Can you try this formula instead:

IsNull([@field:Field1], 0) + IsNull([@field:Field1], 0)

I just added IsNull function. What it does is it replaces NULL with the specified replacement value, otherwise returns the result of expression.

You may refer to this article as well. https://howto.caspio.com/function-reference/

- Barbie

 

[telly]

Hi @Batchini,

 For more information about ISNULLyou may check there function reference: https://howto.caspio.com/function-reference/ or 

 

[ParkLoey]

Hi! Just wanted to add this link if you want to see other SQL null functions which mostly can be used in Caspio:

https://www.w3schools.com/sql/sql_isnull.asp

[Ulensr]

Also  if you want to know the type of value  you enter, you can use javascript.

 

Paste this in the footer (add header / footer if you don't have one) and make sure you disable the HTML editor in the advanced TAB but replace X with the number of your virtual field

When you then enter a value and click TAB for example it will popup and tell you the Type of this value

 

<script>

document.getElementById("cbParamVirtualx").onchange = function() {getType("cbParamVirtualx")};

function getType(field){
alert(typeof field);
}

</script>