Depending on type of project works, different...

(S J Sia) #1

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?

(Bellave Jayaram) #2

Not supported yet-however, you have two options- do it with scripting or add/upvote feature request and wait for it.

(S J Sia) #3

@Bellave_Jayaram Do u mean script in AppSheet or in Google Sheet? Can App Sheet call Google script?

(Bellave Jayaram) #4

You can trigger google apps scripts bound to a google sheet from AppSheet via webhooks.