I need some input from those of you with a LOT of Coda experience. I have an idea for a doc I built. It basically is to help people stay on track for a program that was developed by someone else. I want to present this to the program developer as an option for their users to track their progress and give the company some additional ways to interact with their clients.
I could just have each person copy the doc and make it their own. But doing this eliminates anything ever being changed in the future. If we wanted to add some things into the program then each user would have to get the new doc template and then they’d lose all their previous progress.
So I was wondering if I just made one doc and each user that logs in can only view and edit their particular records in tables how would that impact performance?
If there were 200 users or 2,000 users would it make much difference?
The other thought I had was for me to create a new doc for each user. But that would mean updating it would require me to make the same doc edits to every doc created! For 20 people that might not be bad for for 200 or 2,000 people that could be horrendous.
Basically the document is one page of information showing where they are today. Each item being tracked, weight/body measurements, water intake, food diary, etc. is on it’s own page. We want to make this simple for a user to pull up their cell phone or web browser and just see what they haven’t done yet.
I could build this in some other product like Microsoft crap…er ah, platforms. But I don’t want to spend that much time on creating it since we don’t know if it will be successful. Coda is quick and easy and I already built the entire thing in 1/2 a day. I’m just not sure how best to make something that can be changed and updated as we go. The company ads new challenges all the time and it would be great to be able to add these to the front page so the client only has one place to go to track everything in the program.
So…those of you who do custom work and have made big documents, lots of users, please share things to consider.
Some thoughts I have.
If I made a document for each user I could do a CrossDoc and pull all that data for the company to see stats and to be able to share things like…way to go people y’all have lost a total of X pounds this week!
If it were one doc per user. If I wanted to change the main page and add in other things I woiuld assume I could make the new challenge into a page template and have each user just add that template. But if I wanted to change that main page to include the new template information could I make a template of the new page and when they copied that template and deleted the old first page would all the things being pulled work?
You have consumed X ounces of water today.
X is being pulled from a table on another page for water.
So if you make a new template page for that and in your document all the table names, etc. are all the same and you import this new template page will it get X from the water table? Or will it show up as broken until you go in and fix it?
I don’t want a maintenance nightmare and these are mostly women over 40 many with very limited computer skills.
Is there a way to make something in Coda or should I just go back to an actual web/database development platform? Am I trying to force Coda beyond it’s limits?