About Caio_Barros

Caio_Barros · 12-13-2021

I have an app for task Management where you can log tasks, start time, end time, comments, status, etc. I want to add a Bot that automatically closes the last “In progress” task (meaning, endTime is blank) when a new one is created. Here is a simplif...

Caio_Barros · 12-14-2021

One thing that I noticed (in the real app) is that using virtual columns as references doesn’t work. In the App I have a column for username (which is not the email) and a virtual column for the user email itself. I can’t reference this virtual email...

Caio_Barros · 12-14-2021

Thanks for your help. WillowMobileSystems: SELECT(Tasks[id], AND(USEREMAIL() = [_THISROW].[User], ISBLANK([endTime]), [id] <> [_THISROW].[id])) This one works! I think it will close all open tasks except the last one, but I’m totally fine with that. ...

My Stats

Caio_Barros's Bio

Badges Caio_Barros Earned

Recent Activity

[SOLVED] Automatically close the last task when creating a new one

Re: [SOLVED] Automatically close the last task when creating a new one

Re: [SOLVED] Automatically close the last task when creating a new one