Solved: Look for data in the actual table - Page 2

Juan_Camilo_Sie · 01-07-2021 12:48 PM

Hi everyone.

At the moment I’m having an issue for something that “should not” be very difficult.

I have a table with the records of employees [Employees].
Here I upload the information like “Task” daily, and this “Task” have an “Start Date” and “Finish Date”.

I want that when I will more information about any employee if he is working in any “Task” this row will appear as “Bussy”.

What I have done so far is:

if(
count(
FILTER(“Employee”, and([Employee] = [_THISROW].[Employee],
[Start date]<today(),[Start Date]>today()))
)>0,
“Busy”,
“Available”
)

I suspect that my error is in “[Employee] = [_THISROW].[Employee]” but I’m doing this because I want to filter the actual Employee in this hole table.

Please let me know if you need more information.

PD: My error is that ALWAYS show it as “Available”

Juan_Camilo_Sie

It becomes a little more complecated with the action to do it automatically, but after some time I could solve it.

What I did with action was:

Take the information of the users from table “USERS” ([Name], [Email] and [Telephone]) I did it with the action “Data: add a new row to another table using values from this row”. And after that triggering an action for each row using the report structure.

So my idea was to create the status of every employee automatically.

So It was givin to all operator an status to “Busy” because I couldn´t filter properly the data from it’s own data.

So I create 2 diferent actions and applied the formula that you gave me in 2 different actions, actions that give me the bussy employess and and the available employess

Behavior for the available empoyess:

COUNT(
FILTER(
	"Employee",
	AND(
		[Employee] = [_THISROW].[Employee],
  [Date] = today()-1,
  OR( 
    [Status] = "Available",
    AND(
    [Asistió ?] = "Bussy",
    [End Date] < today() -1
    )
    )
	)
))>0,

Behavior for the bussy operators:

COUNT(
FILTER(
	"EMployee",
	AND(
		[Employee] = [_THISROW].[Employee],
  [Status] = "Bussy",
		[Start Date] <= TODAY()-1,
		[Finish Date] >= TODAY()-1      
	)
))>0,

And it worked, now that I solve if anyone has a question because I could not have explained in the best way i could give more detail.

Thanks @LeventK for your help

View solution in original post