6 Replies Latest reply on Mar 19, 2015 9:25 PM by WenchangShi

    show filtered records in the portal

    WenchangShi

      Title

      show filtered records in the portal

      Post

      Hi,

      I am new to the filemaker, and struggling with it!

      Here is my question.

      I have two table:

      Sign_in: PK_Sign_in_ID, FK_User_ID, Sign_in_time, Sign_out_time,Sign_in_date, Sign_out_date;

      User: PK_User_ID, User_name, User_photo;

      In one layout, i want to use a portal to show all users' name and photo who haven't sign in yet, and use another portal to show all users' name, photo and sign-in time who already signed in.

      Is this possible? I tried to use calculation to filter the records, but just a mess.

      Thank you!