Vlookup column expressions and bots

[Peter_S1]

Hi,

Having some trouble making a simple vlookup work and wondering if anyone could help. I would like to look up a Company Name in the Company Name column based on a V# and populate it in another table called Linehaul Trips when new rows are added to this table. I’ve tried different things for hours and just can’t get it to work. Here’s what I’ve done:

1. I’ve created a new Bot → when event occurs: Data Change and Adds Only selected. Table = Linehaul Trips.
2. Added a new process with Set Row Values selected to the Company Name column (which is blank). Here is the formula I’m using:
   LOOKUP( [_THISROW].[V#] , “Company” , “V#” , “Company Name”)

New rows are added to the Linehaul Trips straight into the google sheets document, not through AppSheet. Please help.

[jyothis_m · Accepted solution]

Peter_S1:

New rows are added to the Linehaul Trips straight into the google sheets document, not through AppSheet

I think the BOT won’t trigger if the data change is made directly in gsheet.

[Steve]

jyothis.m:

I think the BOT won’t trigger if the data change is made directly in gsheet.

Correct.