Slightly more complicated OE system

[comment]

I am not exactly following the description of what you have done. IIUC, a simple calculation using Last() or Max() over the self-join of similar items should produce the intended result. Similarly, Count() would give you the number of item occurrences.

[Agent Ska]

Took me a few tries, but I figured out where they should be calculated from. Thanks for pointing me in the right direction.

[Agent Ska]

I wouldn't use a real checkbox for this, because two salespeople working simultaneously would interfere with one another. But you can have a button in the portal that puts/removes the selections into a global field, which can then be used to generate a new invoice. The selected items can be marked by conditional formatting or by an unstored calculation field.

I set this up in the database and it works beautifully with a graphic button, that when selected, adds the parameter to a global field and, conditionally formats the portal row. When clicked again, it removes the parameter from the global and reformats the field. It's beautiful.

This obviously only works in the FM Client. I have a need for a layout using the same portal information to be accessed via IWP. Obviously, the conditional formatting will not work there. I have searched the forum for a manner in which to use a checkbox on the web layout, but have come up empty. (My concern, of course, is that the user can see which rows have been selected vs. which rows have not)

I tried setting up a checkbox attached to a value list with only one value, and attaching a button with the same set field steps to that checkbox. However, the check box clears itself after adding data to the global field. And if a secondary checkbox is selected it over-writes the global field, rather than adding to it.

Is there another way to add an interactive button/checkbox for use in IWP?

Edited January 7, 2009 by Guest
clarification

[comment]

As I said in the part you quote, the marker can be either conditional formatting or an unstored calculation field.