Hi Guys. Sorry for the silly question but I’m struggling with some ref links that I have between tables in my app:
Customers Table where the “Company ID” is the key:
Customer Call table which records contact made with customers such as calls, emails, visits etc. Here I have a “Company ID” column which is my ref to the Customers table. Currently the ref link is working, and form a UI there is an automatic dropdown selection for “Company” which is pulled in through the ref:
Here is a detail view of the formula showing the ref link:
Here is my issue though… when I go into google sheets to view the data created by creating a new customer call the Company ID column and Company column BOTH contain the Company ID as referenced by the Customers table. So my issue is the “Company” column isn’t showing the correct data.