Pass a dynamic value from a BOT process to an Action

AppSheet AppSheet Q&A
,
1

Hi everyone,

Is it possible to pass a dynamically defined value in a BOT process to an Action? For example:

  1. BOT Trigger: When an order is created in the Orders table.

  2. Process: Calculate a total amount using:

    INPUT("TotalOrderAmount", SUM(SELECT(OrderDetails[Amount], [OrderId] = [_THISROW].[Id])))

  3. Action: Add a row to the Invoices table using this value with [_INPUT][“TotalOrderAmount”].

Do INPUT() and [_INPUT] support this? If so, how?

Thanks for your advice! :blush:

2

You don’t need INPUT() or _INPUT for this; just use an action of type Data: add a new row to another table using values from this row.

3

Hello Steve,

For the action ‘Data: add a new row to another table using values from this row,’ I don’t understand how I can pass [OrderId] to the row I create in the Invoices table through this action.

Could you help me clarify this point?

4

Like this?

Steve_0-1735919390709.png
Steve_0-1735919390709.png574×400 33.2 KB

5

Thank you for your suggestion! What I need is a way to dynamically pass the OrderId to the Invoices table when adding a row through an action triggered in a BOT process.