Can anyone advise how to get return yes/no results...
# advancedpdfd
Dominic B
09/03/2021, 2:54 PMCan anyone advise how to get return yes/no results in a cell when returning a checkbox value from a saved search? I'm using Netsuite's recommendation, ie.
Dominic B
09/03/2021, 2:54 PM Copy code
<#if record.checkbox_fieldID?string == "Yes">
// code to be executed if condition is true
<#else>
// code to be executed if condition is false
</#if>Dominic B
09/03/2021, 2:55 PMBut if I set true condition to output yes and false no, I get no for every field. The field is sourcing from custom records if it makes any difference.
s
Sciuridae54696d
09/04/2021, 5:04 PMif you are working with the formula field, best bet is case when then else when then end
Otherwise you can check what it is, but the freemarker also supports boolean, so it probably wont be yes/no, but instead true or false, without the speechmarks
Sciuridae54696d
09/04/2021, 5:08 PMi'd try
Copy code
<#if record.checkbox_fieldID == true> Copy code
<#if record.checkbox_fieldID>d
David B
09/06/2021, 4:02 AMDavid B
09/06/2021, 4:04 AM[…]if you don't know the visibility of the field[…]
Copy code
<#if (record.checkboxfield?is_boolean && record.checkboxfield) || (record.checkboxfield?is_string &&
record.checkboxfield== "T")>🙌 1
4 Views