How to link different views through actions?

Hello, I am a newbie and trying to build an app for inventory management. There three categories of PO items- foundation, excavation and construction. Each of these have separate inputs for the user to input to update progress. I wanted to make an action with link to a certain view within app. 

My dataset is called Items2

If PO category is foundation, the link has to be to view POEDIT View

If PO category is excavation, the link has to be to view POEDIT View

But if PO category is construction, the link has to be to view Items View

I have the following formula written in the actions link tab:

IFS(
IN("jointing", Items2[PO category]), LINKTOROW([_RowNumber], "POEDIT") ,
IN("excavation",Items2[PO category]),LINKTOROW([_RowNumber], "POEDIT"),
IN("Pipe laying",Items2[PO category]),LINKTOROW([_RowNumber], "Items") ,
TRUE,LINKTOROW([_RowNumber], "Items") )

Issue is this links all the categories to POEDIT view. I am not even sure if I can do this within actions. Could anyone suggest if this is the right way? and what can I do to achieve the views desired for each category.

Solved Solved
0 2 109
1 ACCEPTED SOLUTION

IF("construction" = [PO Category], 
  LINKTOROW([keyColumn], "Items"),
  LINKTOROW([keyColumn], "POEDIT")
)

View solution in original post

2 REPLIES 2

IF("construction" = [PO Category], 
  LINKTOROW([keyColumn], "Items"),
  LINKTOROW([keyColumn], "POEDIT")
)

Thank you Joseph, this works perfectly

Top Labels in this Space