I have an employee table under User Roles. It is linked to the Cellular table which holds cell phone, hotspot, and tablet details.
Each employee can have one or more cellular devices.
Each cellular device links to one employee.
But not every employee will have a cellular device.
I tried using a Text Formula on the Employee table to pull in the wireless number but the system does see that table.
However, when I add a Text Formula on the Cellular table, I can pull in information from the Employee table.
Hey @Jake4, as you’ve suspected, text formulas can’t be used on a many-side connection (i.e. showing all connected cellulars in an Employee record). Is there a reason you need to use a text formula?
The alternative is that in your live app you can add the connected field to a grid or details view. In a grid view, you can search based on this field, but you can’t filter.
Hi @StephenChapman ,
So when I create a grid with Employee Role and go to connections, select Cellular, it works to bring in the phone. However, if they are assigned a phone and an iPad, then two numbers appear.
I tried to use the display feature to hide the value but in the list of fields to use, I only saw fields for the Employee table and not the Cellular table.
The way I made this work before was that I created three separate tables. One for cell phones, one for tablets, and one for hotspots. But now I want to have the data together.
Thanks for the help.
Instead of showing Employees, show the list of Cellular records, and pull in details from the connected Employee. The downside with this is it won’t show employees that have no cellular records.
Hi @StephenChapman
I’m trying to create a directory like the one shown.
Maybe the issue is that I have a one to many connection, where as with my connection from Employee to Cell Phone is 1 to 1. Because I can use the Text formula as a field in employee and bring in the phone number.
First screenshot is a directory listing of employees. The cell phone is pulled from the Cell Phone table.
