Starting a task with the name of the field that has focus as a paramer

Hi Bas,

Table tasks are row-based procedures. The selected column on a row cannot be communicated to the task. 

One step back, what are you trying to accomplish? Maybe there's an alternative solution possible.

Hi Bas,

It is not possible to execute task with the context of the selected column, only from the selected row(s). That would mean the task pop-up will need a field to specify which column has to be passed onto the Task. Feel free to create an Idea for that.

For creating a task parameter and populating it with all visible columns, you can create a View that gets a record for each of the visible grid column using SQL-typed Control procedures. The template looks like this:

select c.col_id
from (
    values
        ('[COLUMN]'),
        (null)
) c(col_id)
where c.col_id is not null

In the Control procedure code, assign the template once by inserting a record into #prog_object_item and replacing the parameter with the column values like so:

-- Available variables
-- @model_id        - Name of the current model
-- @branch_id       - Name of the current branch
-- @control_proc_id - Name of the current control procedure

insert into #prog_object_item
(
    prog_object_id,
    prog_object_item_id,
    order_no,
    template_id
)
 select
    'view_example', -- < replace "example" with correct view name
    @control_proc_id,
    10,
    @control_proc_id

insert into #prog_object_item_parmtr
(
    prog_object_id,
    prog_object_item_id,
    parmtr_id,
    parmtr_value,
    order_no,
    no_line_when_empty
)
select
    'view_example', -- < replace "example" with correct view name
    @control_proc_id,
    'COLUMN',
    col_id,
    c.abs_order_no,
    0
from col c
where c.model_id = @model_id
  and c.branch_id = @branch_id
  and c.tab_id = 'example' -- < replace "example" with correct table name
  and coalesce(c.grid_type_of_col, c.type_of_col) = 0 -- Editable in Grid

Or else (less mutable), you could write a Dynamic model procedure that obtains all visible columns in said grid, then create a domain with elements, one element for each field. For each new element that now has no translation, you can obtain the translation of the grid column and reuse that for the domain element, so the translation of both the column and the element are the same.

Hope this helps!

Hi @BasWesselink,

Good to read that Mark's reply may be an option for upcoming situations. Did the option you tried for now work? In that case I will close this topic :)