Hi, I have one table with Companies. Then I have one table with Contacts that is linked to the companies table with a related column. One company can have multiple contacts. I have a third table with ads that are sold to the companies. Every ad is connected to a company. So far, so good. Now I want to be able to select a different contact for every ad. I don’t know how to do that. When I add the contact row in the ad table all contacts show up and I cannot select. Can someone tell me how to do this? Thank you.
Hi @Lettrafot_Kommunikation_GmbH,
can you share your doc or create a dummy doc and share that?
Best regards from Germany
Jannis
I would guess that you created a calculated column instead of just a basic relation in the ‘Ads’ table to the ‘Contacts’ table. Calculated columns cannot be manually edited. Here’s a little example, with a filter in the ‘Contact’ relation column to make sure that only contacts from the right company can be selected
Hope this helps,
Pablo
1 Like
Thank you Pablo, that is exactly what I want. However, I cannot see any Filter or Formula in the Contact column of your example. And in my table it just jows all of the contacts, not only the ones specific to the company in the row. What am I missing here?
Within ‘Edit column’ you can find the ‘Filter’ section.
In this case it means that for each row in ‘Ads’ it will only show as selectable options, contacts where the ‘Contact.Company’ is the same as the ‘Ad.Company’.
If you pay attention, ýou can see that not all ‘Contacts’ are selectable in ‘Ads.Contact’
2 Likes
Thank you so much. It works now and I learned something.
Thanks for your offer, I cannot share the doc but Pablo_DV was able to help me.
Grüsse nach Deutschland
1 Like