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:
- FormulaMap(Listcombine(Slide 1, slide 2, slide 3), AddRow(Singular Grades, Student, ThisRow.Name, answer, currentvalue, key, _____________)).
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?