Help

Linking problem between tables in bases

Topic Labels: Integrations
239 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_Phillips
4 - Data Explorer
4 - Data Explorer

Hi, I wonder if you can help me.  I’m stuck with a linking problem between tables in bases.

Scenario:  We have several clients and some of them have completed a feedback survey(s).  I wish to create a column that counts the total number of feedback surveys completed by each client.  Clients are stored in BASE1 and completed surveys are stored in BASE2.  I have activated ‘Sync data to another base’ to make the survey table data available in BASE1 and that is all working fine.

I then created a ‘Link to’ column in the Clients table and pointed it at the synced Survey table (both in BASE1).  I was expecting this ‘Link to’ column to be automatically populated with a unique reference to the survey number(s) or be blank if no survey existed.  Instead, the ‘Link to’ column is entirely blank and when I click into it, I get a pop-up to create a relationship between individual data points in the Clients and Surveys tables.  I don’t want to create individual relationships because that already exists via the Client name which is both tables.

Any ideas on how I get the ‘Link to’ column to auto-populate?

Thanks, in advance, for your help.

Kind regards

Ben

0 Replies 0