AddRow to table based on change in another table

[Pch]

Ok, so here I am .

This took me a little of time because following your doc, I had to change the way the button Sync (here, in your doc) is disable as, if I understood correctly what you’re trying to do, you want the automation to be triggered when you manually check the corresponding Status checkbox after reading the article.

Using checkboxes can sometimes complicates things but I think I found a way to make it work .

For simplicity and because I’ve got a few things to explain () , I re-used my earlier example so you might need to adapt things for your doc .

So, the raw principles behind my sample here are:

1. You read your article (meaning your article is currently not in your table Read Articles)
2. Once finished reading, you check the corresponding Status checkbox to “send it” to the Read Articles table.

Following this, what I did in my sample (below) to disable accordingly the buttons is compared the articles in Backlog and the articles already in Read Articles, meaning that the Sync buttons will only enable if an article in Backlog is not in Read Articles (and those buttons will also be disabled if Status=false (just in case )).

The Disable if formula is this one :

[Read Articles].Title.Contains(thisRow.Title) OR thisRow.Status=false

Now, trying to be as complete as possible, I found 3 ways to sent those read articles from the Backlog to Read articles .

First, the automation, as you requested but it has its flaws as it requires more attentions (well, at least checking if it did correctly its work and there might be some delay between the triggering of the automation and the results).
I also needed to add a Properties field : ModifiedOn() to make it work (See the step 2 of the automation below)

With the new Disable if formula the steps for the automations are those :

The formula in this step is :

Backlog.Filter(Status AND [Modified on]=[Modified on].Max()).

It looks for the most recent row where the Status=true.
I needed to go there, because the trigger is row based, which means that it will trigger whether you check or uncheck a checkbox. So I tried to put a “stop” on the automation there.
(It might be superfluous though but it’s been a long time since I’ve played around with automations )

The last step is logically :

You could also add a step here to notify you when the automation was able to run .

Now, because I personally don’t like relying on automations, you could also use a Push button on the canvas . Which is something I used in this post .
It’s the Button 1 in my example . Like its name says, it will just push the appropriate buttons in Backlog and it will tell you how many rows will be added

Or strictly an AddRow button (Button 2 in my example) on the canvas following this post . It’s a little bit more complicated though .

I hope this helps !

If you need clarifications, don’t hesitate ! (It’s not always easy to explain those kind of things )

PS: Happy New Year (maybe a little bit in advance )