Behavior and bot with condition

[HguillenA]

Hello,
I'm learning how to use bots and need help with the following case that I can't get to run properly.
I have a Behavior named Clock In, which works perfectly when the user executes the Action icon in the view:

Clock In Behavior settings:

Consider improving the app by using a bot that can evaluate this condition: 

AND(

[Distance]  > 0,

[Distance] <= 0.025

)

where: Distance is a virtual column in the Team table that has the formula DISTANCE([OfficeLocation], HERE()) as part of separate tests. Everything works fine

The case: I can't get the ClockIN event configured as shown in the image to apply the established condition. That is, it executes the Clock In process always, even if the event condition is false.

Event Setting 

Process setting

[MiguelPilo]

Please try using [_Thisrow]

Your condition will be: AND([_Thisrow].[Distance]>0, [_Thisrow].[Distance]<=0.025)

[HguillenA]

Hi MiguelPilo,

I adjusted the condition, but it didn't work.   The condition is false but the bot applied the process 

[MiguelPilo]

I'm according with @Marc_Dillon, you can add your original action and use it at the end of the Team_form.

But trying to understand the problem of your bot, you can test the bot and view the detail of TRUE/FALSE condition.

I replayed your bot in a sample app, made some trials adding "true" and  "false" rows and bot works OK.

[Marc_Dillon]

I'm not sure why you think a bot is a better solution than the action here.

---

@HguillenA wrote:

Distance is a virtual column in the Team table that has the formula DISTANCE([OfficeLocation], HERE()

---

Is OfficeLocation the "UbicacionOficina" from your screenshots? Does it even have a value before the bot fires? Since you're setting it's value with the action, it seems like it wouldn't.

[HguillenA]

Hi Marc_Dillon,

I'm not sure if it's the best option. I'm still learning.

Regarding the UbicacionOficina column... I was just doing some tests.