Depending on type of project works, different Job (template tasks) are assigned to different personnel.
Job A: Task 1,2,3,4
Job B: Task 5,6,7,8
Example. So when there is a Project #1, I need copy the set of task (either Job A or B) in to the Project #1 to-do list.
Anyone has concept suggestion on how I should design my data?
Not supported yet-however, you have two options- do it with scripting or add/upvote feature request and wait for it.
@Bellave_Jayaram Do u mean script in AppSheet or in Google Sheet? Can App Sheet call Google script?
You can trigger google apps scripts bound to a google sheet from AppSheet via webhooks.
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |