Run, bot, run!

[CorneliusH]

Hi community.

I am trying to automatize (is that how you say that?) a process with bots or hidden actions, but I just cannot make some of them work. For instance, this is one of the actions, made to add rows to another table:

Runs good, normally. Now I try to make it run with a bot:

The istructions are the same:

The bot is not working. When I test it manually I got this message:

Clearly, I have the column “Agregar?” set as “No” by default.

Is there anything I am missing? Doing wrong?

UPDATE: I changed some wording in the first condition for the bot, so now I get a positive in the test:

But the rows are not added as requiered by the action. If I click on the second “execute” then the action is triggered. Why is the bot not doing the job?

[Steve]

@CorneliusH

I am trying to automatize (is that how you say that?)

Automate

Please post a screenshot of this event’s configuration and of any expressions it uses.

[CorneliusH]

Content in the “referenced rows”

SELECT(DETALLE_FORMULAS[ID_DETF],[ID_FORM]=[_THISROW].[AGREGAR_MEZCLA])

the action

the content of “id_cubetas”
ANY(SELECT(CUBETAS[ID_CUBETA],[ID_CUBETA]=MAXROW(“CUBETAS”,“_RowNumber”)))

[Steve]

Your bot is configured to respond only to updates to existing rows in CUBETAS and not to new rows added. Are you testing by updating existing rows?

[CorneliusH]

[quote=“Steve”]
Are you testing by updating existing rows?
[/quote]>

Oops, since the row is created when the bot does NOT run, I most definitely test it after the row is created. How can I configure a bot to run with new rows?

The bot is suppose to run when a row is edited and Agregar? is true, or when a new row is created with Agregar? being true.

[CorneliusH]

If I am not wrong, now it is supposed to run on adds, too, but no results yet

[Steve]

Good! Next, try changing [_THISROW].[AGREGAR?] = true to just [AGREGAR?]. Dereferencing _THISROW is both unneeded here and can cause problems. The comparison to true is redundant and so should be avoided.