Method Community

Is there any way I can check a value for NULL or empty prior to attempting to use it in an action?

I've customized my Item table by adding a couple fields. Most Item records will not have a value set for these new custom fields but if an Item does have a value I need to use it in a series of custom Actions. When I use the 'Retrieve Value From Table' action, an error occurs b/c there's no value set.

Does this make sense? How do I get around this? Is there something like an ISNULL check I can do from an Action?

Thx

BTW, I immediately thought of a workaround. I just loop through the table for the field I'm trying to get the value for and inside the loop assign the value to an action result. Knowing there will be only one record to possibly loop over affectively sets the value if one exists.

GOT to be a better way than this...what am I missing?

Hi Blake,

The Loop Through Table/Grid actions are very useful and in this case you can set the condition to where "field" is not equal to, type in, and leave the text box blank. This will work as you want it to.

- Ashur

Forgot to mention that if you have the grid on your screen then add a Refresh Grid action after your end loop through table action. 

Yeah, that's exactly what I wound up doing. Seems weird, but it works