4 Replies Latest reply on Dec 26, 2016 10:44 AM by philmodjunk

    Display execute sql result in table filemaker

    muhammad.ikram@contedia.com

      Hello.

       

      I was having a go at ExecuteSQL() function and its very handy. But I'm not sure how i can display data in table or in portal like view.

       

      I have a dashboard where I wan to display latest data for example, I would like to see last 10 newest customers, last 10 notes added, last 10 timesheet.

       

      My dashboard is obviously is assigned to show customers table.

       

      In relationship I have customers table linked to all other tables.

       

      My question is if i have portal; the portal will display related records of that customers only. So how can I use execute SQL script to display data in table.

       

      My second comes from this. I was looking at something called Virtual list. Can anyone explain what is that and how that can be used to display results in table or portal like way.

       

      Thank you