This is my first time to post a query here and I would appreciate any suggestions to help me with my problem. My aim seems simple but I have been doing some research and tests with no luck.
Situation: I have multiple projects (e.g. Project 1 to Project 10) and each Project has a checklist column that varies.
Say if I select Project 1, it will show the below table:
If I select Project 2, it will show the below table:
In other words, the Task column is constant while the Complete column changes according to project selected.
The first thing you may think of is to create one column per project, like this but this is clearly not the best thing !!!, as you may want to add project, and so on, and because this is more complicated to deal with column rather than with rows
What I suggest is to create a project table, and to refer to it in your checklist table using lookups like this
Or even better (see the embed doc below ), automate this considering the set of task is the same for each project . By clicking this master button, you will run through the different project, and for each project, it will click an inline button that will create a row in Checklist database with every tasks, for each project
I looked at your profile and saw some useful coda tricks. I wished it had a subscribe button so I get an update every time you have a new coda trick very helpful!
Wow that’s a great comment to read @Neil_Sipe thanks !
Working on community and for client I’ve had less time for this blog, but I’m thinking about improving it in the near future yes ! Thanks for support !
), automate this considering the set of task is the same for each project 
. By clicking this master button, you will run through the different project, and for each project, it will click an inline button that will create a row in Checklist database with every tasks, for each project 
