I created a bot that triggers an action when a condition is met in Add row or in Update.
This bot triggers some actions that updates the value of a column in 2 tables.
However I get an error in the bot log that says as follows:
Error encountered in step with name [Trigger actualizar estatus de transferencia PAJ]: Error: ‘Execute a Sequence of Actions’ Grouped action ‘Trigger actualizar estatus de transferencia PAJ’ child action ‘Actualizar estatus de transferencia GAA desde PAJ’ failed due to error: Error: Perform DataAction ‘Actualizar estatus de transferencia GAA’ failed because Row having key ‘GAA0000000157’ in table ‘Inventario GAA’ in field ‘Cantidad’ is required to have a value
I reviewed manually the row in google sheets with key ‘GAA0000000157’ in table ‘Inventario GAA’ and it does have a valid value before running the bot. This column is marked as required, so I unchecked the required box from that column and the error got fixed, however, the value in ‘Cantidad’ got cleared by the bot when it did run. What is weird is that not a single action triggered by the bot touches column ‘Cantidad’, I don’t know why it is trying to update the value to “blank”.
I’m going crazy with this error, please help.
Here is the information of the actions triggered by the bot:
Trigger:
Actions:
Detail of actions:
Actualizar estatus de transferencia GAA desde PAJ:
Formula of referenced rows:
SELECT(Inventario GAA[ID_operación], AND([ID_transfS] = [_THISROW].[ID_transfE], ISNOTBLANK([ID_transfS])))
Actualizar Estatus de transferencia GAA
