RE: Programmable Tables R5 vs R6 Narasimhan Nallani 14.Aug.06 06:25 PM a Web browser Applications Development 6.0Windows 2000
ok. Are you getting the Tab headings in that programmatic table or just only display of rows? One thing is sure that, whatever is the value of $Approver, that row will be displayed as an active tab.
Try this: Just takes 10 minutes.
Idea is to have customized tabs. When clicked on Tab updates $Approver field and displays particular row as active tab which will be with a colored background you choose and other tabs will be with a grey background. For this we need to have a 4 r * 7 c table with hidewhens so that each row display with 4 tabs.
Create a multivalue computed field (RowTabs) and have the 4 values as(Basics, Facts, Summary & Approvals)
Create a fixed width table, with a row of 7 columns and make sure the 2nd, 4th and 6th columns will have least possible width.
Create computed for display fields in 1st, 3rd, 5th & 7th columns and have the formulae as @Subset(RowTabs;1), @Subset(@Subset(RowTabs;2);-1) ....etc. for all those 4 fields.
Create 3 more rows and repeat the above with different field names and make sure the correct Tab Label display in the same column.
Make sure the first cell of this 1st row, 2nd cell of 2nd row, 3rd cell of 3rd row and 4th cell of 4th row will have the same colored background for the cells so that they can be distinguishable as active Tabs. All other cells of this 4*4 table can have dark grey background color. Leave the 2nd, 4th and 6th tiny cells with white background. This way when user click on 3rd tab, it will have colored background and identified as active Tab and all others will have the grey background (Inactive)
Leaving the fields in the colored cells, create action hotspots for all the other fields in grey background cells, with the action hotspot formulae as for eg.
To the 1st grey colored cell (3rd col) hotspot of 1st row :
FIELD $ApproverTable := @Subset(@Subset(RowTab;2);-1);
The same column gre colored cells will have the same action hotspot formula. But for the 5th column and 7th column, have the formula so as to update the $approver Table with the 3rd and 4th values of the RowTabs as
FIELD $ApproverTable := @Subset(@Subset(RowTab;3);-1);
FIELD $ApproverTable := @Subset(RowTab;-1);
. Similarly for the 1st column too.
Underneath this table, create your programmatic table with those 4 rows. Make sure there is no gap between the above table and this programattic table and name all 4 rows and Table too as ofcourse "Approver".
This way you can hide each row. Now when user clicks on the action hotspots $Approver will be upodated with right key and hence the programmatic table displays accordingly with its value as active tab.
Let me know if this is of any use for you. This is the only way you can get your task to work I guess.