[cgieselman]

I have a saved transaction search that displays sales order lines given they meet certain criteria. One of the results column is a custom hyperlink (Formula: Text field) that when clicked redirects the user to create a new custom record with the fields populated from that line of the search.

All of this works great however the problem I’m running into is I only want the hyperlink to display if there is no applying transaction (a work order in this case) related to the line item.

In an abbreviated form I’ve tried

Code:
case when {applyingtransaction} is null then html to create link else null end
but this results in the link never being shown despite there not being an applying transaction for many of the lines.

Any help is appreciated, thanks.
This is a cached copy. Click here to see the original post.

[JCirocco]

If you include {applyingtransaction} in the results, do any appear?

[Olivier Gagnon NC]

Might not be null. Might be equal to ”

[cgieselman]

Originally posted by JCirocco

View Post

If you include {applyingtransaction} in the results, do any appear?

Yes, of the (currently) two results one does have an applying transaction and it displays normally. This was already a results column, the idea being that if an applying transaction exists the user would click on it, otherwise they would click my link and I don’t want to show them both options on the same line.

[cgieselman]

Originally posted by Olivier Gagnon NC

View Post

Might not be null. Might be equal to ”

I tried changing the formula to

Code:
case when {applyingtransaction} = ” then …
but got the same results, that the link never displays.

I also tried

Code:
case when {applyingtransaction} is ” then …
just to see but this resulted in an error as expected.

[alanvarghese]

CASE WHEN {applyingtransaction} = ‘ ‘ THEN ‘LINK’ ELSE ‘NOLINK’ END

This should work..

[Author]

Posts