Solved: REF_ROWS() formula I canțt figure it out - Page 2

sorin_mihai · 10-19-2019 07:39 AM

Hello all

I’m having some trouble creating a formula.

So in my Task Management App, Makers are the Employees and they complete their Working or ExtraWorking Times (working outside the daily scheduale).

So I have a Makers Table, a Tasks Table and a Times Table.

When selecting a Task, there is an action button to add Times to that Task (a Maker completes the for to say that he spent 2 hours working on that Task). In this form there is an Enum option to choose whether that time was worked during the daily working hours - Working Time or if it was done on top of daily working hours - Extra Time.

What I would like is to have in the Makers Table, a virtual list column of all the Extra Times completed by each Maker.
So in my Makers View, when I go to the Detail View of one Maker, I can see the list of only the Extra Times he has completed in the app.

Any Ideas how this formula should look for the Virtual Column?
I guess it should be done with REF_ROWS() but I can’t figure it out.

Thank you,
Sorin

Steve

Used from Makers Table, this:

REF_ROWS("Times", "Maker ID")

means, in English, “list the rows in the Times table with a Maker ID column value that references this row” of the Makers Table table. It is equivalent to:

FILTER(
  "Times",
  ([_THISROW] = [Maker ID])
)

which isn’t specific enough for your purposes. Instead, it sounds like you want:

FILTER(
  "Times",
  AND(
    ([_THISROW] = [Maker ID]),
    ("Extra Time" = [type of time])
  )
)

View solution in original post