Hello, Can you please educate me how to use Tags with Auto Cat. I created a new column in the table for Tags and when I ran the auto cat the tag didn’t populate. I verified it added the tags to the Tags report. 'm sure its user error on my part
Hmmm…Did you label the columns in both the Transaction Sheet and the Auto Cat sheet, “Tag,” or “Tags?”
I think it needs to be just, “Tag” in both to work. (Mentioning this since I made an error once and called a column, “Notes” when it could only be “Note.”)
Are you confident that what you are using in the “Description Contains” field on the Auto Cat sheet for a particular tag is actually in your Transaction sheet Description column somewhere?
Did you get this working? We did a webinar recently on tags where I demo this. Skip ahead to minute 5:10 in the video here:
https://community.tillerhq.com/t/tiller-money-live-community-webinar-q-a-september-3-using-tags/5364
The proper column is Tags in both sheets (I know that’s confusing @Brad.warren with “Note vs Notes”)
Heather
H,
I did not get tags working with AuotCat I will be sure and check it out.
Thank you for thinking of me!
Michael
In the AutoCat rules sheet, there are essentially two types of columns:
- Columns that Filter
- Columns that Override
Columns that Filter must start with the exact match of a column name in the Transactions sheet. This is the column they will reference when filtering. They then must end with one of the following words to specify how they filter: “Equals”, “Contains”, “Starts With”, “Ends With”, “Max”, “Min”, “Regex”, “Polarity”. For a transaction to be processed in AutoCat, every non-blank filter column criteria must be met.
Columns that Override must start and end with the exact match of a column name in the Transactions sheet. When all filter criteria are met, all overrides are applied to the transaction in the Transactions sheet.
Long story short… if the column names don’t match exactly between the rules sheet and the Transactions sheet, the filter or override is ignored.
1 Like
Hi I’m new to Tiller, another Mint eviction looking for a home.
I am trying without success to use Autocat to retroactively add a tag to transactions of selected categories. The example is, suppose Airfare, Hotel, and Tour Fee are almost always while on vacation, so I want the vacation tag to be added to transactions in those categories. I thought I could use Autocat to do this, but so far haven’t been able to make it work.
I tried using the advanced rule builder to do the hotel part. The builder added two columns to the Autocat sheet: Category Equals = Hotel, Tags = vacation. Ran autocat, it found nothing to do.
I added to the rule Hotel under the Category column in Autocat sheet, ran it again, nothing.
Tried Category Contains rather than Category Equals, still nothing.
What am I missing?
Thanks.
I think you’re really close, @Wizardofaz. (It sounds like you have a good understanding of what is supposed to happen.)
There could be other minor issues but the most likely problem is “Run AutoCat Rules On” dropdown that is somewhat hidden.
The default is to only apply rules to uncategorized transactions. You can change this behavior— and I’ll bet your rules will run— but just proceed with caution because anything you’ve manually categorized or modified may be changed by your rule set. (One hack might be to temporarily delete all of your rules except the tagging rules… then paste them back in after running this process.)
Hope this helps.
P.S. Welcome to Tiller!
1 Like