Kuroshi Posted January 31, 2021 Report Share Posted January 31, 2021 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? Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted January 31, 2021 Report Share Posted January 31, 2021 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 DaveS 1 Quote Link to comment Share on other sites More sharing options...
0 telly Posted January 31, 2021 Report Share Posted January 31, 2021 Hi @Batchini, For more information about ISNULLyou may check there function reference: https://howto.caspio.com/function-reference/ or Quote Link to comment Share on other sites More sharing options...
0 ParkLoey Posted January 23, 2022 Report Share Posted January 23, 2022 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 Quote Link to comment Share on other sites More sharing options...
0 Ulensr Posted January 24, 2022 Report Share Posted January 24, 2022 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> Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.