Is there a way to filter an interactive table by an array rather than a single value?
Basically, I am building a training manager app and I am building a slide to assign a specific training to a user. I’d like to filter the user selection table so that it only shows users that do not have that specific training scheduled already. I built a connector that outputs an array of users that already have that specific training scheduled, but don’t know how to apply that output to a table.
I have Table 1 that generates ID’s using the expression [User Name] + [Training ID].
In Table 1, I have a field for the [User Name], [Training ID], and [Status].
I built Connector 1 that creates an array of [User Names] for the [Training ID] selected in the app that has the [Status] = “Currently Assigned”. I’ve created a text variable array named “Duplicate Training Users” which stores the Connector output.
I have Table 2 which is made up of all the Users added to this training manager app.
In the selection screen of the app, I’ve embedded Table 2, but would like to filter the table so that the [User Name] of Table 2 does not contain any of the [User Names] in the “Duplicate Training Users” text variable array.
Is there anyway to do this?