List View Conditional Statement for Value Display

Hello - Could anyone please help me out with a statement to show Field1 in a list view, but if Field1 is empty/null display Field 2 instead? For example, business class is InventoryTransactionLine and the list is Lines. Create a column and call it To Bin.

ItemLocation.BinReorderPolicy_ByItemLocation_UsingSymbolicKey_SetRel.Bin blank

default to ItemLocation.PreferredBin

else ItemLocation.BinReorderPolicy_ByItemLocation_UsingSymbolicKey_SetRel.Bin

Thank you!

Find more posts tagged with

Accepted answers

robert-canham

I don't think you can do that directly in a list, but you could create a derived user field to do what you describe and display that instead.

Sandeep Chandak

Create a derived field like this:
MyDerivedField

if (Field1 entered)

return Field1

else

return Field2

And add the derived field to the list

All comments

Sandeep Chandak

Hi @patrick-webley

Can you describe in English what you are trying to do? The syntax above is not for lists.

robert-canham

I don't think you can do that directly in a list, but you could create a derived user field to do what you describe and display that instead.

Stace Webley

Hi @sandeep-chandak - Basically, display Field1 unless Field1 is null. In that case, display Field2.

hatem-elkhashab

I agree

Sandeep Chandak

Create a derived field like this:
MyDerivedField

if (Field1 entered)

return Field1

else

return Field2

And add the derived field to the list

Stace Webley

That's what I needed. Thank you, Sandeep!

Stace Webley

Thank you for the suggestion and quick response.

Dr. Awesome

Just a note that we are looking for a way to do this "inline" and not require Config Console access and a UserField to be created there. Some ins and outs to re-use and how personal and scoped this inline field will need to be yet. Nothing build yet but doing some design thinking around this area.

Stace Webley

Thank you for the update. Glad to hear it!

Copyright © 2025 Infor. All rights reserved.