Export relationship items in secondary app

Answered

Follow

Marco Rossi

• March 06, 2015 09:15

Hi everyone,

I've got a problem that I can't figure out how to solve, hope you can help me!
Basically, I have 2 apps: 1 is the father and 2 is the son -> 1 is recalling info contained in 2.
When I open one item in app 2 I can clearly see all the items from app 1 that link to it, but then when I export in excel these "connections" are completely lost!

How can I export keeping these connections?

Thanks!!!

0

• 

  Rainer Grabowski (FVM)

  • March 06, 2015 11:58

  Hi Marco,

  the incoming relations which are listed at the bottom of the item under "related items" can't be exported. There is weak workaround with which you can export the information which incoming relation an item has at the moment you do the export (but only as text, not as links).
  Create a calculation field in App 2 with the formula:

  @all of NameOfTitleFieldApp1.join(";\n") 
  

  This lists all related items from App 1, separated by semicolon and line break (=\n). Instead of semicolon and line break you can use every other separator you like (always in quotation marks; if you don't put anything into the brackets after .join they are separated by a comma.)

  Rainer

  3

  Comment actions Permalink
• 

  Marco Rossi

  • March 06, 2015 13:28

  Hi Rainer, thank you very much for your workaround!

  0

  Comment actions Permalink
• 

  Daniel Salazar

  • June 22, 2016 03:18

  Thanks Rainer, is not the best to add additional fields but your suggestion helped a lot. 

  0

  Comment actions Permalink
• 

  Hans Rudbeck Dahl

  • September 15, 2016 13:47

  Hi Marco, thx for the help, is there any new development you know off ?

  0

  Comment actions Permalink

Please sign in to leave a comment.