Need to create a format rule when a bot is triggered

[Jack_Bates]

I made the automated expenses work

• Creating a new Table for automated Expenses
• Created an Action to create new rows in Expenses Table
• Created a BOT to run each Friday and trigger the action
• I need to make a Format rule to Color the date in the expenses table when the BOT runs. or someway to be able to make the ones that automatically transfer stick out

[Suvrutt_Gurjar · Accepted solution]

The format rules can be unconditional -meaning the format rule is always applied to the selected columns or action buttons.

To make the format rules conditional, there will need to be some row columns/CONTEXT() based condition that needs to be mentioned in the format rule setting" If this condition is true"

In your case since the bot adds automated expenses, you could add a condition if those automated expenses are specifically categorized. 

For example the format rule could be  OR( [Expense_Type] = "ABC" , [Expense_Type]= "LMN") 

Here "ABC" and "LMN" are two types of automated expenses.

[Jack_Bates]

Thank you I will try that

[Jack_Bates]

After testing the Format rule I still have a problem It’s not transferring the format rule when the BOT creates the new rows in the expense column

Format rule expressionAutomated expensesExpense table