Triggering actions on a table based on events in different table

[Jack_Bates]

1. I have a Bot for the DATA Table sends a notification. when a new DATA record is created.

2. I have a BOT for the TRUCKS table that triggers an Action for rows in the TRUCKS table

3. I need the BOT for TRUCKS to trigger when the BOT for New DATA record is created

[WillowMobileSys]

You wouldn't be able to just trigger another Bot.  Data Change Bots trigger based on activity in that row.

You can add actions to the DATA Bot to make a change to the desired TRUCKS row.  Basically, you force a change to the row that's in "context" in the Bot using an action of type "execute an action on a set of rows".   I call this a bridge action.

If you just need to make a small change to the TRUCKS row then you just specify the action or set of actions to execute.

IF your TRUCKS Bot has a whole complex set of processing you want to make sure the TRUCKS row goes through, then you need to initiate a small change on that TRUCKS row from the DATA Bot so the TRUCKS BOT gets triggered for it.  For these situations,  I usually include an EditCount column and just bump it by one.  It could be a small change to ANY column that gets picked up by your TRUCKS Bot.

I hope this helps!

[Jack_Bates]

It’s only three columns. in truck table

[Jack_Bates]

I also tried to add the process for Updating Mileage to the BOT for notification when a , New DATA record is created

However testing it isn’t working

[Jack_Bates]

With what you said probably something like this would work better

[Jack_Bates]

That’s not workin either

[WillowMobileSys]

Yes, this last one should work.  

When you say it's not working, how are you determining that?  Did you Save it before trying it?

I assume that the row you are using to send the notification has a [Truck] column.  Is that column a REF column?  Make sure it has the correct row key from the TRUCKS table in it.

[Jack_Bates]

It worked to transfer the DATA from the appropriate colums.

However when it transferred it adds mileage that is incorrect.Correct in app viewIncorrect in the email

[Jack_Bates]

I have tried many different ways and for reasons unknown to me

The only way that the sums are the same in the app view and the form view is with static columns not virtual columns

However I need the sum to update every time that a New DATA record is made.

A virtual column updates the sum automatically

The static column only updates when the table is edited and saved

[Jack_Bates · Accepted solution]

I found the solution by redoing the Expression that figures the math sum of the mileage after a specific date the totals sum for the appropriate columns is correct in the app view and the email notifications.

The BOT is triggered in a static column with an expression

IF(
[Miles Since Last Service]>[Service Interval]- 100,"OVERDUE", "OK"
)