Oracle Apex APEX 22.1 Calculation on Apex Form

SANPAT

Dear Friends

We are creating a Invoice Form based on master / Details. In the form we tried to return the fields for total value , discount value and final value. where we should apply the return script so that it can save the record with these figures. currently if value gets store other fields are not getting stored. Please suggest.

sanjay

Hamza Al-abbasi

Hi,

Sorry, the requirements are NOT clear enough to me. Could you please give more details ?

SANPAT

Dear Hamza

Create a Invoice Form where the fields are Item,Qty,Rate,Value,discount per,discountamount,final value.

while making the entry , when we insert the qty and rate , value should be calculated similar way as soon will enter the discount per, system should calculate the discount amount and the final value. it was more easy in forms and reports , where with trigger it was getting calculated, but i am new for oracle apex, here not understanding how to put the trigger in forms.

sanjay

Hamza Al-abbasi

You need to read more about Dynamic Actions. On change QTY Item, add Set Value action with type JavaScript Expression :

parseFloat($v("P1_QTY_ITEM")) * parseFloat($v("P1_RATE_ITEM"))

Affected Elements :

Selection Type: Item(s)

Item(s): Your item that hold will the result