Add ONE row only the current work week to another table

[desmond_lee]

Hello Guys

How do add ONLY ONE ROW to the table below. I manage to put the current WW in column A however it duplicate 13 rows WW48 because there are also 13 row on top of WW47

This is my bots. 

The action WEEKNUM(TODAY())

[Aurelien]

Hi @desmond_lee 

What about using a condition there?

Such as, for example:

[WeekNumber]=ISOWEEKNUM(TODAY())

[desmond_lee]

Nothing is happening. It does not add a new row

[TeeSee1 · Accepted solution]

Try setting the Filter condition of the event as

[id column] = MINROW("table name","_RowNumber")

[desmond_lee]

There is an error in data type. Column A WW is the key

[TeeSee1]

My expression should go into the Filter condition of the event. Not the value of [WW].

[desmond_lee]

Thanks a lot. It works perfectly. I just tweak to [WW] = MAXROW("Weekly STS","_RowNumber")

[SkrOYC]

You want to add a row weekly to a table and that row is current's week number?

[desmond_lee]

The last row is 47 at column A which is also the key. I want to schedule this ti add ONLY ONE ROW and put the lastest week on every MONDAY 1am in the morning.

[SkrOYC]

So... you want a bot that adds a row to a "weeks" table every monday.

Config:

Schedule bot with a weekly event that runs on monday at 1AM (12AM should work as well, maybe 00:01 could be a good idea)
Action: Add a row to another table using values from this row.
This action should have something like ISOWEEKNUM(TODAY()) for the key column.
The trick is that this needs to be "Foreachrow" event in order to be able to point to a table, but you need to filter the rows in which the bot is going to run to just one row. Use something like this:

[RowNumber]=2

Since you are not refering to any record from that row, it just matters that it returns exactly one 

[Landan_QREW]

I think you will want to toggle off the 'for each row' selection in the event. This will remove the connection to a specific table, so you may have to make some adjustments to your process and task as well.