Bot that creates multiple rows in many to many table

AppSheet AppSheet Q&A
1

Hi! How could I create this behaviour in automation?

Context:
Table 1 - Employees

EmployeeName
John
Mark

Table 2 - Projetcs

ProjectName
Project A
Project B
Project C

Table 3 - Employees are assigned to project (many to many relationship)

EmployeeName ProjectName Assigned?
John Project A No
Mark Project B Yes

Bot:
Every time a new employee is created (Peter for instance), create a new row in Table 3 for every existent project and set Assigned? as ‘No’

EmployeeName ProjectName Assigned?
John Project A No
Mark Project B Yes
Peter Project A No
Peter Project B No
Peter Project C No
2
  1. Have some way to identify the new employee. 2. Run an “execute…” action across all records in Table2, that each adds a record to Table 3 for the new employee.

Or, you could use a START expression in the JSON body of a webhook to the Appsheet API.