We are new to Coda and had our team workshop already. We have made great progress on our doc since then, but are now running into an issue. I have built out a test doc as an example I can share with everyone so you can see the problem.
The goal I think is simple, while a little complicated to explain so I hope I’m saying this right.
The layout looks like this:
Customer Database,Platform,Client + Template
The goal is to hit a button on the “Customer Database” which add all the rows from the platform of that customer (Apples, Potatoes). Right now I have it so the button works for one platform, and cannot figure out how to do a “if platform equals potatoes”, apply potatoes template. “If platform equals apples”, apply apples template.
The other issue I’m running into is when I hit the button a second time, it duplicates all the data. So instead of having 4 rows I’ll have 8, etc. We need to have the formula map check if the data already exists for that client, and if so move on to the next row.
Here is a link to the Doc:
I hope this makes sense. Please let me know if you have any questions and thank you for any assistance ahead of time as it’s very much appreciated.