How to search & compare 2 (or more) rows with data in different tables

Ask for Help
27

@Jeff_Hager I’ve figured it out finally. It’s a mix of what you suggested and some explanations in this topic Calculation/Relation with previous (list) data in inline list? Global var?

What was done in DB:

  1. Separate table with 1 row. Columns: Text(could be also template as you wrote)=“key”, User specific1="", User specific2=""

  2. Pills table. New columns: Template=“key”, Relation=Template.key in separate table.key

    image
    image1290×758 63.1 KB

  3. Interactions table. New columns: Single value choice=Separate table.userspecific1, Single value choice=Separate table.userspecific2, IsInteract (IfThenElse column as Darren_Murphy described above but based on new sv columns).

    image
    image714×652 27.1 KB

What was done in UI:

  1. 2 buttons in new tab each writing main_component trough the relation column to its own column in the separate table
  2. Inline list with source of interactions table and with filter by IsInteract positive value.

Thanks again for your help.

2 Likes