Hello. I'm a newbie to Appsheet and trying to create what I thought was a simple app to onboard employees and track tasks to be done to prepare for their arrival (the templates don't work for this). I have one table where new Employees are entered, one for the standard list of Tasks that need to be done for every employee and one for the actual Assignments that have due dates. My thinking was Assignments would get a copy of every row in Tasks and the triggering employee ID would be added as a column to tie everything together. I have created the action/bot to copy every row from the Tasks table but I cannot seem to get the triggering employee ID to be referenced. Is what I'm trying to do possible (and appropriate?)? If so, how can I copy the triggering ID into the Assignments table with each task. Thanks for any help. Happy New Year all.
User | Count |
---|---|
18 | |
11 | |
7 | |
4 | |
3 |