Error bot dynamic : Unable to find column

AppSheet AppSheet Q&A
, ,
1

hello everyone,

I have a problem in Email body of Bots. I need the links to be generated dynamically.
So I typed :
CONCATENATE(“application link”, [Fournisseur])
But I have an error message that says it can’t find the Fournisseur column.

Yves86_0-1730709492584.png
Yves86_0-1730709492584.png955×148 16.9 KB

Here are the columns of the data table:

Unité légale ID Fournisseur Fournisseur Email

Yet when I click on Preview Email, it works. The link is generated.

Yves86_1-1730709820692.png
Yves86_1-1730709820692.png991×798 54.6 KB

I tried using ANY(SELECT([Fournisseur])). Same result.

Someone to help me ?

2

You are showing a saved Task. Saved Tasks allow you to specify a Table so that the Task can be implemented. But…when the Task runs in a Bot, it is the Bot Event that dictates what Table is in context.

I suspect the table you have specified in your Bot Event is different that the one you used to implement the Task and the column is not within that table.

How to fix this will depend on your goal you are trying to achieve.

I hope this helps!

1 Like