Filtering with second relationship

Comments

3 comments

  • Rainer Grabowski

    Hi Panu,

    1. Do you mean: Filtering in an app view (e.g. table view) or filtering in a calculation field?

    2. How are your 3 apps related? Which app references which one in which way (= where's the relationship field)?

    3. Do you use Globiflow?

    Rainer

    0
    Comment actions Permalink
  • Panu Heinonen

    1. App view. I think there's no practical way to do the listing in calculation field. Apparently you cannot filter things in app by string type calculation field?

    2. Client is created first. Then the Project is created and relationship to client is there. In time entry you choose the project. In every case only one reference is allowed.

    3. No I don't.

    Only workaround I figured out is to choose all the projects for particular client, but it's not very practical in long run.

    There is no way to "heritage" field from another app?

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Panu,

     I think there's no practical way to do the listing in calculation field.
    You can filter everything in calculation fields. I've created many Report-Apps which connect dozens of apps and with filters which are far more flexible and granular as the App view filters. The results are calculated and displayed in calculation fields  

    Apparently you cannot filter things in app by string type calculation field?
    Unfortunately not, you're right.

    In your case you need a relationship field. Add one(e.g. called "Client") in the worktime app which points to the Client app.
    Then in the Project app add a calculation field (e.g. called "Number related worktimes")  which can be always hidden. Then enter @all of some field in Worktime app.length.
    "some field in Worktime app" can be each field in worktime except a relationship field (maybe a date or a number field).
    Then create a Podio flow (if you don't know how, check the Podio Help for it, please).
    The flow should look like this.
    When
    item is updated
    field ""Number related worktimes" changes
    Then
    Update item in ... (select: Incoming -  the relationship field in Worktime which points to Projects).
    Then click in the field Client and select the relationship field to Client in Projects.

    Now the Client will be automatically added to each Worktime item and you can filter for the client in Worktime.

    If you want an overview in each Client item, how many hours have been booked in this client you can do that through calculation fields (even with a list or table which shows project, date, employee, hrs .... with a hyperlink to each Worktime item).

    Hope this helps,
    Rainer
    Btw: Globiflow (available only in Podio Premium plans) is an investment with a worth return. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk