Question: I am pulling information from Googl...

(Patrick Patino) #1

Question: I am pulling information from Google Sheets that lists business contacts. I want to be able to show person x who I have had lunch with two times only once in the list of contacts (directory) but twice in the list of events. How do I go about doing this?

(Reza Raoofi) #2

You did not explain much about the column structure of your data table(s)? I would assume you could have 2 tables, one for Contacts and one for Events with Ref column to Contacts table, then it could be the way you wanted: Each contact could be related to more than one Event.

(Reza Raoofi) #3

I also recommend reading these two articles: http://help.appsheet.com/app-design/app-design-101

http://help.appsheet.com/data/data-the-essentials