How to dynamically change certain value only in a list box

[ronaldwang]

  I have load a inline table as below

Then in the list box display the filed as below

 

What I want is that have another button where use can toggle between original and adjustment so that when user select original, the list box will be unchanged, but if the user select adjustment button, some value of the list box will be dynamically changed.

 

[Sergey_Shuklin · Accepted solution]

Hello, Ronald!

If your inline loaded field called fld1 then you can try this:

Go to the ListBox general tab and choose expression instead of field. And use Subfield() and Replace() functions to get some changes in output field values.

For instance:

If(Subfield(fld1,'|',3)='Nov', Null(),

     Replace(fld1, Subfield(fld1,'|',2), 'ActualAdjustment')

)

And of course this condition should have effect only if the User have pressed certain button.