Participant IV
Since ‎09-22-2019
Sunday

My Stats

  • 52 Posts
  • 7 Solutions
  • 2 Likes given
  • 5 Likes received

Jack_Bates's Bio

Badges Jack_Bates Earned

View all badges

Recent Activity

I can sum the two summary columns in the reportsHowever I need to omit from the total the data from the column when the other column is emptyIn Table “Basic Summary” Fuel Amount: SUM(SELECT([Expenses][AMOUNT], [EXPENSE] = "Fuel"))Fuel Discount: SUM(S...
The app users for the annualloadbook app put in fixed expenses in the {Expense} TableThey add an ENUM category and an price on either a weekly schedule or a monthly schedule it would have to be specific per app user preference.Is there a way for the ...
I made an automation to the {TRUCK} Table to alert the app user that a “Service” or “Inspection” is overdue. I then added a condition before it fires the BOT.[Days Since last Inspection]>[Inspection Interval][Miles Since Last Service]>[Service Interv...
In the annualloadbook app I need to add a notification when a unit reaches a preset time for service based on the miles that the unit travels from the last service date.I created a form to log an event “Full Service”, “Grease” The date migrates to a ...
I need to count the number of days that a booking was made for by summarizing the difference between the [Checkin Date]and the [Checkout Date]ColumnsVirtual column