how to import data from excel into field with multiple app references?
I have a field which references an organisations app on one hand and a contacts app on the other. In other words, one can choose to reference either a person or a company in this field. However when I tried to import the contents of an excel file into this app, it seems the import module only gives me the choice to match excel fields with those of only one of the referenced apps (the organisations app). Is there a way to properly handle such a situation? - Thank you very much!
As it looks now you can not import to a relationship field that points to multiple apps I'm afraid, just single apps. Multiple items within the same app works fine though. I'll add your vote on supporting also multiple apps in the future! For now, manual linking of app 2 would be the way forward.
Hope that helps!
/Charlie - Podio
Hi Charlie - thank you for your reply!
Just a quick note to let you know that I somehow managed to do this - might be useful for someone else that needs to do the same:
I noticed that when a field references two apps, the import module will try to import into the first referenced app. So I first imported the data that would referenced the first app listed as possible reference for the field. I then changed the order of the referenced apps in the field's settings and imported the part of data for that would reference the second app, and voila! : ))))
Please sign in to leave a comment.