Any way to automatically run a script for each newly added row in Transactions?

Conversation Ask Anything
1

I have a custom script that I run on each row in Transactions (to auto-categorize them). Right now, I manually invoke this for new Transactions.

Is there any way to have such a script run automatically whenever Tiller adds Transaction rows?

2

Hi,
You can create a macro and then schedule it via time or trigger, in this case updating of a row. Go to Tools>Script Editor>Edit>Add Trigger
However, Tiller has an auto-cat feature that does the same, if you just want to categorize a transaction based on data in columns. You can set min/max, institution, description, etc. You can’t split a transaction though.

1 Like
3

@Ghopper21, I’m curious what your script does that AutoCat can’t do?

4

Resurrecting an old thread to see if this has changed.

Tiller wipes-out a formula I have in a column on the Transactions sheet when it inserts a new row. I would like to run a script that re-inserts the formula whenever Tiller adds a new transaction row.

Thanks.

5

Hi @HelloMrGladstone what does your formula do and where do you have it placed?

1 Like
6

any updates on this thread? i also want to use a macro to repaste my formulas to the newly added cells. I am using formulas as helper cells to make categorizing the transactions easier. As an example, i have a dependent drop down list for my tags based on the category. I have to copy and repaste this formula into the newly added rows.

7

Why not use an arrayformula instead? ARRAYFORMULA - Google Docs Editors Help

8

Does that work in excel as well? i am not an Array expert but if that works that would be great.

9

@Cinistix Perhaps you can start with checking out this Microsoft documentation and see if it helps as you try to implement in Excel.