Event when TO DO list is Over

[Entrenador_Hisp]

Hi guys, Im trying to trigger an event when my To-Do has all task compleated.

I got this table call TODO

ID TASK Finished? (yes/no)

I got the event on UPDATES only
with the following condition:

Count
(
	FILTER(
  	TODO, [FINISHED?] = False
  )
) = 0

This actually works pretty well but I’m concerned about performance on big data.
My question is:

• Do you know any more simple or elegant way to do it?
• Do you know if actually Bots process on Parallel and this will not bring a SYNC TIME ISSUE?

THANKS!

[Steve]

Entrenador_Hispano:

I’m concerned about performance on big data.

How big are you thinking?

[Entrenador_Hisp]

It is actually part of a Multi User App.
So it may go up to 100-200 users.
Each user may have like 20 Tasks

So the TODO table may go up to 2000 Registers, Filtered with a Security Filter.

[Marc_Dillon · Accepted solution]

I would not consider 2000 records to be very big.

Entrenador_Hispano:

Do you know any more simple or elegant way to do it?

I believe the following would also work, and probably would be more performant. But really, that’s not an expensive expression to start with.

ISBLANK( TODO[Finished?] - LIST( TRUE ) )

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.

[Entrenador_Hisp]

Awesome!
I was not aware of lists could substract in that way. Another time, Jumping stairs without knowing the basics delays everything. Thanks for the solution