Automation with a task from behavior

[Aepifania]

Hello!!

I'm new on appsheet, and now I'm having an issue with Boots because I tried to run a data action using an action made on behavior.

I want to add information from one table to another when a new record is added on the first one without clicking on the action icon, that is why I created an automation to make it automatically but dont work. If i test the task with the action icon it works, but using the boot nothing happens

I would appreciate your help.

[Tommy62]

Haben Sie nicht vergessen, als ersten Schritt einen Trigger in Ihrem Bot festzulegen?

[Julio35]

Hello, 

On the top right corner of your automation panel you have a "Monitor" button that helps you understand what's wrong with your automation, if there is any error you'll see a red text. 

[Aepifania]

Thank you! I see the error, but i cant fix it because the Amount column has a formula on it and appsheet doesn't allow me to select it.

[jaichith]

I think "required ? " Option Is checked in the properties . Secondly  I think you cannot pass a value to the field it has formula. Better try pass values to the field , which is required for the formula to work. 

[Julio35]

I think that formulas field can't be edited. On the other hand, "Initial values" field can...

Try to move the formula from "Formula" to "Initial values", you should be able to modify this one. One more thing, right now you are doing the following:

(Inventory)ID Item = (Inventory)ID Item =

(Inventory)Item = (Inventory)Item

If i am correct, you are just copy the same value. If you want to copy the values of Materials in Inventory you have to use [_thisrow] as follows:

ID Item = [_thisrow].[ID Item]

Item = [_thisrow].[Item]

This means that you are assigning the values of the row (you pressed the action to) of Materials to Inventory. 

Did this help?