I want to copy rows from a table (“Activity”) in another doc into a table (also called “Activity”) in the present doc. One of the columns is a relation to a row in a table called “Organiztions”. Both documents have their own Organization table.
When I paste a row into the present doc, the relation-to-organization row contains the text of the relation; not a relation to the Organization table in the present doc. Expected and reasonable behaviour. But is there a way to convert the text values to links to the Organisation table?
1 Like
hi @Tellef_Kvifte , it has been a while, welcome back.
define the columntype as relation (by default it is text) and link to the related table.
I hope this helps, chees, christiaan
1 Like
Worked beautifully - thank you!
1 Like