Display user names in separate data table Column based on specific parametres

Ask for Help
1

Hi,

I am trying to display specific user details (name) in a column within a different Data Table.

The user ‘name’ is from the User Data Table.

I have created a new column in a separate Companies Data Table and want to display the users (names) matched to the company they work for but limit it to only users who work for the same company AND that have a checkbox selected in the User Data Table also.

*The user Data Table includes a Companies column that matches the Row ID in the Companies Data Column.

in the Companies Data Table row (company specific) I am trying to display all the users (by name) that are linked/related to that company and also have a specific checkbox ticked in a column from the user data table.

IE

User Data Table

Row ID | User Name | User Email | Company ID | Company Name | Checkbox [ √ ] |

Company Data Table

Row ID | Company Name | Display User/s Name (that work for the same company as referenced in the Users Data Table and have the check box selected within the column in the Users Data Table) |

2
  • Add a Query column to your Companies table
  • Target it at the Users table, and apply the following filters:
    • CompanyID is This row→RowID
    • Checkbox is checked
  • Now add a Joined List column that fetches a list of usernames via the Query column.
2 Likes
3

Mr Murphy, once again I salute you, good Sir.

Click Bang Done √

Thank you !

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.