Hello dear Community,
the other day I had an introduction call with a Coda customer support and discussed several questions (among them column view for the layout and there seems to be something around the corner till the end of the year) and one of the questions I had I was told it should work but he could not really tell me how.
Well, perhaps I find some help here, because I have spent already hours on this without a solution.
This is what I am trying to achieve:
I have a table called Assets, which includes per row a single assets for a social media campaign - these assets are links to hashtags files, text files or picture files.
There is also second table called Content Repository in which I am combining the content for a message on Twitter, LinkedIn or some other channel.
My idea is to checkmark individual content rows in the Asset table and take from each check marked assets row the Source File column into a new single row of the Content Repository.
I am trying to take the content of individual columns of different rows of the Asset table and combine them into a new single row of Content Repository table.
I have played around with various formulas (incl. formulamap) but there were always three rows added in the Content Repository table.
I sure do hope that the description in combination with the image kind of clarifies my challenge
Any hint and idea would be fantastic, thanks!
I have put together access to the tables:
Also I must say, that these tables are a combination of several templates I have found in the various Coda communities - fantastic help inside those!