Field does not update/update properly on "on input"? / Adding values of selected entries in real time

Field does not update/update properly on "on input"? / Adding values of selected entries in real time

Hello,

It's probably something small that I'm missing here, but I'm trying to get your example application, "calculate-multi-select-price" to update with the price of the items selected in real time.

The application is shared with development and is entitled "Copy of Calculate Multi Select Price"

( http://creator.zoho.com/andrewkahn.me/ copy-of-calculate-multi-select-price)

I placed the code from the on success script (which does work properly for On Success only) into On Input:

  1. val = 0.0;
  2. for each Select_Product r in Order_form  [ID == input.ID]
  3. {
  4.     val = (val  +  r.Rate);
  5. }
  6. input.Total_Price = val;

However, if I do that, selecting items from "Select_Product" has no result. If I remove [ID == input.ID], there -is- a result, but it is the -total- of all items in Select_Product, regardless of whether they have been selected or not.

Is there a syntax for getting selected items that I am missing? I would very much like to be able to do this sort of calculation.

Best,
Andrew