# Advanced FormulaMap() Calculation between 3 tables

Hey there! Im trying to get a button using a formulaMap() to create new rows in a 3rd table based off information from 2 source tables. I can do this - but there is one piece (one column specifically) I cannot get.

Here is a screenshot with all the explanations, hopefully it makes sense! In the formula map, the list that I am pulling from looks like this:

That blank spot is what I dont know how to do? How do I add the appropriate â€śanswerâ€ť from the answer key table to my new â€śsingular gradesâ€ť table?

@Scott_Weir

I canâ€™t tell whatâ€™s going on with your schema from that image. Can you share a dummy doc?

Hi @Scott_Weir
As @Ander says your scheme seems a little overcomplicated can you share a dummy doc?
iâ€™m pretty sure that it can be simplified heavily

Trick pre-sharing, if you want to get data from a table you use a formula like that: [tablename].filter(), this gets only the row you need, and in a flow like the one i imagine you need there is no need to use buttons!

But yeah letâ€™s wait for a doc so we can play with it :)))

@Mario and @Ander here is a link! THanks for the help - https://coda.io/d/Copy-of-Grading-Pear-Deck_dnaSN-bxzce

@Scott_Weir

Hereâ€™s one possible approach, using a counter:

Thanks for the doc!

Now i think iâ€™ve got your concept!

In the doc you shared iâ€™ve added a page that show my approach to your problem, iâ€™ve added a â€śtests managerâ€ť table, this one allow to manage answers and different tests easily

So, 2 table, one contains all the test, one per row, and the other contains all the questions and the right answers, one per row.

Then, the copy and paste one, and then the â€śanalyzerâ€ť table that check for wrong answers

Iâ€™ve not been able to get rid of formulamap but implemented as iâ€™ve done it auto-adjust based on the number of question for that test so it should be simply adaptable to different tests

Let me know if this helps in some ways or if you have any question

Have a nice day,

Mario

Mario - This is awesome, and a really cool solution. Thanks!

1 Like