+2Hi there ,
I want to select multiple lines with the 'Select' checkbox as seen below, but I have a problem. Each time I select a line, the form on the right is also updating with the information of the line that I am currently selecting. Is it possible to keep the form from the first line as I select the other ones, until I click on the task that I want to execute on all of them?
Here is the example
Best answer by Erwin Ekkel
This effect can be achieved if you do the following:
create a view based on the table, but with an added fake reference column.
Add a column to the table to indicate the main row.
When the first checkbox is set fill the column with the main row.
After executing the task you would reset the fake reference column.
The main issue with this, this will only work if 1 person works on an exclusive set of rows at the same time.
The select of the view would look like this (pseudo code):
select x.*, x2.x_id
from x as x
join x as x2
on x.x_id = coalesce(x2.x_fakereferencecol,x2.x_id)
When the reference column is not set you will see it's own detail. If the reference column is set you will see the detail of the indicated row.
When the indicator is not set:
when the indicator is set:
This effect can be achieved if you do the following:
create a view based on the table, but with an added fake reference column.
Add a column to the table to indicate the main row.
When the first checkbox is set fill the column with the main row.
After executing the task you would reset the fake reference column.
The main issue with this, this will only work if 1 person works on an exclusive set of rows at the same time.
The select of the view would look like this (pseudo code):
select x.*, x2.x_id
from x as x
join x as x2
on x.x_id = coalesce(x2.x_fakereferencecol,x2.x_id)
When the reference column is not set you will see it's own detail. If the reference column is set you will see the detail of the indicated row.
When the indicator is not set:
when the indicator is set:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
