Solved: Triggering actions on a table based on events in d... - Page 2

Jack_Bates · 02-20-2025 11:34 AM

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

Jack_Bates

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"
)

View solution in original post

Triggering actions on a table based on events in different table