Other Tab Variant for form depending on grid column value

Question

Is it possibe to to change the table variant on a form depending on a value of a column ( for instance category ) ?

I have a screen type where theres is a grid on first tab and form and details on second tab.

i created table variants for some categories where i have a different setup for the form

and its details. ( other group labels , different field order )

now when i have selected a record and go to the form tab it shows the default form

but i woold like the formlayout of one of the defined table variants

Marco Maat · Accepted Answer

Solved it by adding a table task that works on double clicking a record in a grid only screenTask opens a variant according the category with screen withform and details.But yours is interesting too

Erwin Ekkel · Answer

Not by default. But you can simulate this with a double self reference toggling between reference 1 or 2 using the context procedure. You can then assign a different table variant to the reference. The reference columns are expression columns see the input below. Below is an example:

Ref1 expression column = case when t1.category = 1 then t1.x_id else null end
Ref2 expression column = case when t1.category = 1 then null else t1.x_id end

Context:

if @reff1 is null
begin
set @ref_X_X_ref1_type = 2
end

if @reff2 is null
begin
set @ref_X_X_ref2_type = 2
end

Other Tab Variant for form depending on grid column value

Cookie policy

Cookie settings

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings