Amending code to pull references to this row from several tables in document

1

Hey there!

Wondering how I would amend this code to pull references from not one form results table, but from 3 different form results tables?

[Usability Test Form Results].Filter([Test Sessions Tag].Contains(thisRow))

Basically I have a table where I’m tracking users that are involved in user tests, and want a summary of the different user tests they have done. In the test results table we will be linking back to the user from the initial table.

2

Hello @Kayla_Kompter ,

It would help to see what your tables look like and what you expect the output to look like:
Is the output on a canvas, is it in another table? Are the source tables similar or completely different?

Can’t you make different forms for one table? That might make things a lot easier.

You can do this with a formula, a button or an automation - depending on what you want to accomplish. There are packs to combine different tables to a new one.

So, please make and share a dummy doc that resembles the basics of what you are trying to accomplish and I am sure someone (or me) will be able to help.

Greetings,
Joost

3

Thanks for the response!

I made a duplicate file here: https://coda.io/d/_dPcOihWDn83/UX-Strategy-Overview_suFJY04r

I’m not sure if there’s a better way to approach this

4

Hello @Kayla_Kompter ,

I looked at your document and I am not really sure where to start to help you - so many pages…

I don’t mind taking another look to see if I can help at least with the question in your first post, it would help if I know where you are trying to use this formula:
[Usability Test Form Results].Filter([Test Sessions Tag].Contains(thisRow))

Greetings,
Joost