Depending on type of project works, different...

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?

0 3 352
3 REPLIES 3

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.

Top Labels in this Space