Bot: how to get the "Event" row data?

[Fael]

Hi,

I have a bot that is triggered when a new row is added. I need to use a column from this row to calculate a column from another row of another sheet using the bot. How can I access the column value from the event row?

I was expecting something like [Event name].[colunm name] would work on a bot process, the same way we can use [Step before name].[colunm name] to get a returned value.

[SkrOYC · Accepted solution]

Actually it should be even easier than you think. A simple [DesiredColumn] should be enough

[Fael]

It does not seem to work.

What I tried here is to filter the "Table 1" entries where the "Title" on "Table 1" has the same value as the "Title2" column on "Table 2", which is my Event row. (call this bot every time a new entry is added to "Table 2")

[SkrOYC]

---

@Fael wrote:

which is my Event row

---

[_THISROW].

FILTER() - AppSheet Help

This is not particular to automation, it's just because you are using a Filter expression

[Fael]

I've tried thisrow already, but it didn't do much difference. Pretty sure I'm missing something here.

[SkrOYC]

The event is fired on Table 2, right?

[Fael]

Yes:

[SkrOYC]

Make sure every part of your automation uses the same table:

[Fael]

Ok, gotcha. The problem here was the data source been using. I was using the new AppSheet database feature, which is still in beta. I redid the exact same application using Google Sheets and the automation worked as expected, with no errors. I think I gotcha a bug here.

Anyways, your first answer was correct. Thank you!