Dynamic price list in an input box

[#1]

Dear All,

I have a set of 40 products under a variable "Product" and would like to have dynamic price list in an input box to be able to adjust the prices without doing a reload i.e.

Could you please help?

BR,

Przemek

[#2]

The easiest way to go is to put the Products in a field, and respectively name another field to "Price", but in the script make it an inputfield.

inputfield Price;
table:
LOAD * INLINE [
 Product, Price
 A, 1
 B, 1
 C, 1
 D, 1
 E, 1
 F, 1
];

Like this, you can view in a chart with the dimension Product and the expression Price. Then it's possible to change the value of the Price field individually for each product.

Do note that inputfield resets to it's original value as soon as the number of rows in the table changes. It does not reset during a reload.

//Jakob