How to auto fetch the value of item based on remaining columns in same page

pawan kumaar

Hi,

 

i have 7 items in a same form

like employee name,employee number ,department,designation,email address and contact address

if i entered employee number means i need to automatically display the corresponding employee details in other columns

Please reply asap.............

Regards,

Kani

Scott Wesley

Use dynamic actions. Here is a brilliant tutorial on the topic

Building Dynamic Actions in Oracle Application Express 4.1

Please do not expect fast answers from a volunteer forum.

pawan kumaar

Hi,

I tried alot to get the solution but exact requirement s not getting...

If i give employee number na i have to display other values  before giving submit button

Thanks,

Kani

Scott Wesley

Or something more concise:

Grassroots Oracle: APEX 101 - Dynamic actions

pawan kumaar

thanks ..

In ur scenario if v enter radius it ll calculate area...

but in mines if any value in weight,courier charge,packing charge,other charges the net charge ll be calculated..based on 4 item values net charge ll be calculated in tat scenario wat i hav to do..

Scott Wesley

There are a few ways this could be done, but one dynamic action would be best

Try:

Event - change

Selection type - jQuery selector

Items - #P1_WEIGHT,#P1_COURIER,#P1_PACKING

(or "input" for all input fields)

Condition - none

Then your action would be a similar formula. Don't forget to include references to all your fields in the 'Page items to submit'

pawan kumaar

Hi Scott,

I got the solution but i assigned the default values for weight,courier charge,packing charge,other charges  and net charges to ZERO...

and page items to be submited--weight,courier charge,packing charge,other charge..

If i gave --page items to be submited--weight,courier charge--net charge ll be display with out assigning default values(ZERO) for any item..fr tat wat i have to do...

Thanks,

Kani