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.
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.
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))