Skip to main content
davide567595
davide567595
December 19, 2024
Question

Best way to structure a UX / logic flow of 2 related tables

  • December 19, 2024
  • 1 reply
  • 0 views

Hi! I have 2 related tables that I have access to BUT do not own. Let's say the 2 tables are Recruiters and Members.

Recruiters has an interface showing recruiter records. This is the entry point of the portal.

I want to have a column in the Recruiter interface that holds links to the Members interface. The Members interface must show records in the Members table depending on the value of multiple columns of the recruiter row clicked.

Take note that I do not control any of the 2 tables so I cannot make the "blessed way" of using those columns to build a composite primary key. I need a way to pass those column values to query and filter the records in Members table and display them in Members interface.

How do I structure this UX / logic in "idiomatic" Appian?

    1 reply

    mathieud0001
    mathieud0001
    December 19, 2024

    I would suggest the grid with detail pattern.

    https://docs.appian.com/suite/help/24.3/grid-with-detail-pattern.html

    When you select a recuiter row, simply make another query (using queryRecordType with multiple filters) to the members table and display the results.

      Terms & ConditionsAccessibility statement