Get 1 field from current selection

[pauldamen]

Dear all,

I have a listbox with fields: Actual, Budget, LE

I also have a table with different columns which match the Actual, Budget, LE and some other calculations.

Now I want to show them conditional, if you select Actual and Budget in the listbox the columns should appear. How can I get this to work, I tried GetCurrentFields, GetCurrentSelections formulas in the conditional box but it doesn't work.

Hope you could help me.

Regards,

Paul

[#2]

Can you upload your sample application

[Gysbert_Wassenaar · Accepted solution]

See attached example. It uses the substringcount and concat functions.

[pauldamen]

Thanks works great!

Just for my interest could you explain what you did with the SubString and the Concat and what this does?

[Gysbert_Wassenaar]

Well, I didn't since I didn't create the document . But the concat creates a string of all the possible values of Field. And substringcount checks in the value you want is in that string. If it is then it returns true, otherwise false. That makes it handy to use for the conditional display expression.

[pauldamen]

Thanks for the clear explanation and the help!