Search on inverse link fields?

This topic contains 2 replies, has 2 voices, and was last updated by  Greg Maletic 7 months, 1 week ago.

  • Author
    Posts
  • January 10, 2019 at 9:56 AM #33356

    Greg Maletic
    Participant

    I have a one-to-many link set up between two forms. Let’s call the forms A and B.

    In B — which has an inverse link back to A — I would like to have a search set up that can show me all the records in B that have _no_ link established, i.e., the inverse link field is blank.

    But when I try to do a search on B, the inverse link field does not show up. Is this a limitation? If so, is there another way to accomplish what I want?

    Thanks.

    January 10, 2019 at 12:43 PM #33357

    Brendan
    Keymaster

    Hi Greg,

    There’s no function to search a parent form for any values contained in a related form.

    However, you can workaround this by using either a Script field or a Calculation field.

    On your form B, add a Calculation field. Edit the formula and choose a field from the list of fields that show up that are contained within the parent form A. Any field will do. Then you can add a Saved Search that checks to see if the value of the calculation field is empty or not.

    Hope that helps.

    Thanks,

    Brendan

    January 10, 2019 at 1:56 PM #33358

    Greg Maletic
    Participant

    This worked! Thank you.

You must be logged in to reply to this topic.