Converter without Custom/Javascript

Help from Community
,
1

Hello!

Unfortunately, for financial reasons, I will probably have to downsize the license of „Enterprise“ to „Essential“.

Therefore, in my Experience I can no longer use any Converter with Custom/Javascript.

How can I determine if a cell is empty or not empty? Javascript:

if(INPUT==“”)

“False”;

else

“True”;

Thanks in advance!

Micha

2

Hi @marnold Micha,

Are you looking at an Excel or H-CMS cell, or another of data source?

In the first case, if you have control on the data structure, one of the simplest solution is to create a new field “Is Empty” with either true / false values and use it as your binding source. If you need the opposite of the value, you can use the logic / Not converter.

A typical use case for me is an image / document / video field and how to address the case when no media was added.

Another approach could be to use the Is Equal To converter and leave the parameter empty. Depending on your data source field type, this converter should return true if the field is empty.

You can then use the Not converter to get the opposite value if needed.

Let me know if one of these options would work for you, or tell us more about the use case.

Seb

3

Hi @marnold, this is the one I use all the time:

if (INPUT.length < 1)
false;
else
true;

4

@AlexB This is still a custom script converter, which he won’t be able to use with an Essential plan.

1 Like
5

Ah, didn’t realize that. Apologies for the mis-info!
Agreed your suggestions would be best.

6

Hi Seb,

I forgot to mention:
I use H-CMS, after removing all old Excel references.
I use Player classic.

Using the Equal To Converter seemed the most simple and elegant approach. Sadly, sometimes it works perfectly and then again works not.
So I choose the direct solution with an on/off switch.Works perfectly, of course – and gives better optical control in the base, too.
Thanks!

Micha