I have a table Organisations with the fields ‘Organisation Name’ and ‘Organisation Type’.
I would like to include all rows from Organisations for which ‘Organisation Type’ = “Network” in a new table Network - and only these rows.
Ideally, the primary field in Networks should show the ‘Organisation Name’ from Organisations.
I thought it may be possible to achieve with the filter and lookup functions, but I can’t get it to work.
Is it possible at all? Any help is much appreciated.
Hello @Mary-Lou, what is the field type for ‘Organisation Type’? It needs to be a text field to make this formula work.
It’s not possible since a Link to table field cannot be a primary field, but there is a workaround to make a primary field a Lookup field.
Here’s what I managed by using a formula and hidden fields. Would this work for you?
Hi @olgatrykush,
Organisation Type is a text field.
It looks good, yes. Can you share the formula you used?
I suppose the primary field looks up ‘Name_linked’?
Hello @olgatrykush,
Thank you so much for your help.
Unfortunately, I still don’t fully understand the table.
It seems to list organisations that are not networks as well?
What I am trying to achieve is a new table that does not list organisations (1, 2, 3 in your example?) that are not networks.
Hey @Mary-Lou, I understand, but it’s not possible. It’s just a workaround. To have “Name” as a Primary field and show only rows where “Type” is “Network,” we need to have all these fields in the table.
As a Link to table field cannot be a primary field, we need to add a Lookup field. That’s why we have both Name_linked and Name fields.
To make the formula (filter on lookup) work, we need to add a Type_linked field.
Ok, Thanks for clarifying.
