Hey there, I’ll try to keep this question clear and quick. I’m currently writing a GDD with Coda. I have created a Detail view of a table which represents “Customization sets”. It has stuff such as the set name, which character can equip it, rarity, etc.
I also have a big Table called “Elements” which holds every single part (a customization set is made of multiple parts), the character that can equip it, the rarity and the part’s ID (which is a concatenation of its informations).
Here’s a quick look at how it looks like :
In my Customization Set detail view, I’ve added a Lookup table to display all the parts in the set. In my first screenshot, you can see it’s empty. What I want to do is as follows :
In the Customization Set view (so when I’m in my detail view, second screenshot), I want to be able to add a part to a set (through a button or adding a new row to the lookup table, whichever). This should add the part to the big Parts table + display the added row in the lookup table in Customization sets.
Adding a part should automatically fill the “Character”, “Rarity” and “Set name” columns of the new row (as it can be deducted from which row I’m in inside my Customization Set detail view) so that I would only have to use the dropdown list of the “Part” column to pick which part it concerns.
Problem is, I can’t find a way to do this. Here are the solutions I thought of :
- With a button inside my Customization Set view, I can add a row to Parts which has the correct information pre-filled. However, this new row does not appear in my Lookup table in my Customization Set detail view. I have to manually pick the row to make it appear there. That’s one extra step I’d like to avoid. Is there a way to, with the button, first add the row to the Part table (this already works) THEN display that row in the lookup table ?
- I tried editing the “Value for new rows” property of my Lookup table. I thought that this way, I could add a new row through the “+” button under the lookup table, it would properly add it to the original Table “Parts” + show the row in my lookup table. That’s all fine and dandy except I have no idea what to put as a formula in “Value for new rows”. I tried everything I could think of but nothing filled the row.
Any idea ? Hope this is not too confused !