Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 31, 2023 11:14 AM
I have two tables: Employees and Licenses.
I created a view, named Current Licenses, on the Licenses table. This view ensures that only the active license for an employee is displayed.
I linked the Employees table to the Licenses table, specifying the view:
Unfortunately, the list of Licenses in the Employees table includes the non-currently licenses.
Am I doing something wrong?
Solved! Go to Solution.
Jun 01, 2023 05:56 AM
Hey there—sorry to hear of the trouble with this! To ensure that I'm following this in full, is it the record picker list displaying the inactive licenses or is it that the field is displaying already-linked records which are inactive? The view-scoped selection applies to the menu of new records available to be added from the picker, so it's not designed to work like a view filter, hiding what's already been logged into the column's cells. If this is not quite the case here, let me know and we can dig further in. 😊
Jun 01, 2023 05:56 AM
Hey there—sorry to hear of the trouble with this! To ensure that I'm following this in full, is it the record picker list displaying the inactive licenses or is it that the field is displaying already-linked records which are inactive? The view-scoped selection applies to the menu of new records available to be added from the picker, so it's not designed to work like a view filter, hiding what's already been logged into the column's cells. If this is not quite the case here, let me know and we can dig further in. 😊
Jun 05, 2023 08:26 AM
OK, I understand now.
It works as you describe.
Thanks.
Jun 05, 2023 08:43 AM
That's great news! Glad to hear that this could help. 🎉