Form Personalization
In po form on approved button i want to do form personalization....
I am having one table
Table XYZ
seg1 seg2 seg3 budjet
------ ------- ------- ---------
111 72002 230051 2000
111 72007 230051 4000
select seg1,seg2,seg3, budjet from XYZ
Now i want to do form personalization such as when i press approve button i have written some procedure which will calculate the budjet available for each item and stores in one temporary table
I want to show that to user
In action
Type =message
Message Type=Show
Message Text=
=SELECT 'The net fund balance of : ' ||segment1||' - '||segment3||' - '||segment4||' is :'||sum(ROUND(TOT_BALANCE_FUND,2))||' of the period :'||period_name