Filtered Lists

Viewing 3 reply threads
  • Author
    Posts
  • May 19, 2024 at 6:37 AM #50737

    Hannes keller
    Participant

    Is it possible, to filter a list with a field dynamic value?

    thanks for your help.

    best regards Hannes

    May 20, 2024 at 8:24 PM #50738

    Brendan
    Keymaster

    Hi Hannes,

    You can filter your lists of records by clicking on the filter button just to the left of the Search field (macOS) and the filter button at the top-right of the records list view on iOS.

    From there you can specify which fields you want to filter and by what values.

    https://www.tapforms.com/help-mac/5.3/en/topic/searching

    Although I’m not sure what you mean by filter by a dynamic value. You can edit your saved searches and put in a new value if you need to. Or create as many saved searches as you like, each with different values to search for.

    Hope that helps!

    Brendan

    May 21, 2024 at 2:13 AM #50739

    Hannes keller
    Participant

    Hi Brendan,

    Thanks for your prompt answer. First, I need to mention that I came from Filemaker Pro due to the easy sync feature.

    In Filemaker I have the option field on the dropdown list to only show list items that are related to the form. Her an example with a project database:

    The following bases are existing: clients, projects, tasks

    If I create a new task I have a dropdown with all my clients(here a,b,c) every client has two projects.

    Now there is another dropdown field based on all project. Here is a filtering option on for this list with works like this: filter all items out of the project base by the client field. So it will show me on this record only the project with are related to selected client.

    Is this possible?

    May 22, 2024 at 9:57 AM #50743

    Brendan
    Keymaster

    If you have a form of Clients linked to a Projects form, then when you select a client, you’ll see only those Project records that you’ve already linked to the client. And with an inverse relationship if you select a Project record, you can see which client that project relates to.

Viewing 3 reply threads

You must be logged in to reply to this topic.