Dynamic link to amend record in a linked table
I have a view with a couple of linked tables displaying collection/delivery addresses for jobs.
I would like the collection field and delivery field to display its contents as a link that opens a pop up window to edit the linked record, in the same way that the default "edit" button does for each record in the view.
I have created a formula field in my Suppliers/Destinations form which contains the following code to duplicate the text in the collection name field and turn it into a link...
"<a href="https://creator.zoho.com/<username>/cross-dock/Create_Suppliers_Destinations/record-edit/View_Suppliers_Destinations/" + ID + "/>Company</a>"
...which I found in your dynamic link demo but I cant get it to open as a pop up, only as a new window. Also I can't get the formula to display the contents of the "Company" field, only the word "Company" appears.
Any help would be greatly appreciated.
Mark