Display related data of the parent table in inline...

Glaiza_Victorin · 11-25-2021 09:09 PM

Hello. I would like to know if it’s possible to display in the inline view the related price list of the different suppliers once an item has been requested?? and is it possible to filter the view of the inline in a date range? So, I would only get the most recent canvassed price list.

Aurelien

Hi @Glaiza_Victorino

Yes
In the Chil table, you may want to add a virtual column and use this expression:
[columnTypeRefThatRefersToTableParent].[columnFromParentTable]
For reference (you may want to read it, this is full of useful information):

Yes
In the parent table, you may want to add a virtual column and use an expression with FILTER()
Something like:

FILTER("yourChildrenTable",
  AND(
    [Parent]=[_THISROW],
    [TimeStamp]<NOW(),
    [TimeStamp]>NOW()-7
  )
)

For reference:

Display related data of the parent table in inline views