AnsweredAssumed Answered

How do I export records with portal data without having multiple rows for the portal data?

Question asked by barraa007 on Aug 16, 2018
Latest reply on Sep 20, 2018 by philmodjunk

I want a "flat" row in my export that has all of the portal records in the same row (exporting as an Excel, for instance). I've tried some fancy relationships that would populate calculated fields in table 1 with specific related data from table 2 but I am working with SQL data and I cannot create anything but unstored calculations to make my relationships by (FM apparently does not like those for joins...). The portal on the layout works beautifully but I need to present my data analysts with one row per record which also has the related portal record data. I am sure there is some sort of scripting magic that can accomplish this upon export but it is not something in my current knowledgebase :-)