how to obtain a line to a file when using the remote command in a tabl

how to obtain a line to a file when using the remote command in a tabl

[Uwe Brauer]

Hi

I have the following two files

#+begin_src 

File1.org

,** Table
   :PROPERTIES:
   :ID: student1
   :END:


,#+BEGIN: columnview :maxlevel 2  :skip-empty-rows t :indent nil :hlines 2  :format "%5TODO(Status) %5Ap(Name) %5Ej1(Ej1/20)  %5Ej2(Ej2/25)  %5Ej3(Ej3/55)  %5Res(Result)"
| Status | Name     | Ej1/20 | Ej2/25 | Ej3/55 | Result |
|--------+----------+--------+--------+--------+--------|
| DONE   | Student1 |     15 |     20 |     35 |      7 |
,#+TBLFM: $6=vsum($3..$5)/10;
,#+END
#+end_src

And  after using org-id-update-id-locations 

#+begin_src 


File2.org

Create a master file with the following content

| Status | Name | Ej1/20 | Ej2/25 | Ej3/55 | Result |
|--------+------+--------+--------+--------+--------|
|        |      |        |        |        |        |
,#+TBLFM: @2='(identity remote(student1,@>$$#));
#+end_src

Is there any possibility also to obtain a (clickable link, for the file1
location) via the remote command?

Thanks and regards

Uwe Brauer 

-- 
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine.