Help understanding "Key column 'member_id' is not present in the Data payload"

AppSheet AppSheet Q&A
,
5

I got a solution from support.

My first bot adds a new row to a table.
My second bot “on data change / add” sends an email, from data in that new row.

I got the following error as the second bot fired (and failed).

Error: “Key column ‘qev_id’ is not present in the Data payload.”
Properties: { “Exception”: “Key column ‘qev_id’ is not present in the Data payload.”, “AppTemplateName”: “8bfa7498-b2ab-4222-a7ea-a4097bf37756”, “Operation”: “Change Bot”, “Result”: “Failure” }

The solution is to explicitly define the key column in the first bot. ie setting qev_id = uniqueid(UUID)

I already had the table column defined with initial value = uniqueid(UUID) however, support clarified “The initial value works when we use the form to add a row but while using bot we have to define all the required columns.” .

1 Like