Call a process for multiples rows

AppSheet AppSheet Q&A
,
1

Hey there !

I’m Creating a CRM where I have:

Parent Table (Leads)

Child Table (Services Detail)

What I want to archieve is when the Lead is closed/Sold I want to send an email for each Child record (Each Service sold).

What I have so far is a bot for the Leads Table that triggers when the status is “Close” After thet I have a Call A Process Step to Send the Email

Problems:

  1. On the Call a Process Step I Put manually the ID of the Service DEtail Otherwise I had this error :

Error Message

Error encountered in step with name [Crear Cada Hoja de Negocio]: Could not find row with key: in table:Detalle Comercial.

  1. It can only send 1 email for each child record

Help please

2

Hola Juan,

  1. Can you please show the expression that is giving you the error?

  2. I don’t understand, in the beginning of the post you said you want to send 1 email for each record then at the end you say it is a problem. Would you please clarify? what is the desired behavior exactly?

Thanks.

2 Likes