Export relationship items in secondary appAnswered
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?
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.)
Please sign in to leave a comment.