Open a form after using LINKTOFILTEREDVIEW

I currently have this action and it works perfectly, I now need to open the form related to the field_detail
, I can’t seem to figure this out. when I navigate from one view to the other it gets me the correct customer, I just need to open the form thru the current action somehow. Thanks in advance

LINKTOFILTEREDVIEW(“FIELD_DETAIL”,
[MASTER ID] = [_THISROW].[MASTER ID])

You can this try this formula to open the form on that record

LINKTOROW(
	[Master ID],
	"NAME OF THE FORM"
)
2 Likes

I need to combine with the linktofilteredview, the form name is Field_Form and the column i need to match is the master id

Why?

Did you try the suggestion from @June_Corpuz?

1 Like

These are two separate tables, I can’t get this last piece to work.

I don’t see how that matters.

Have you tried what @June_Corpuz suggested?

1 Like

when I use the suggested it goes the the desired view/form, but its opens a new form instead of the customer being looked at in the other table, this is why i have the action to

Please post a screenshot of the complete LINKTOROW() expression you tried.

1 Like

What is the key column of the FIELD table?

Perhaps not ideal, but worth a try:

LINKTOROW(
  ANY(
    FILTER(
      "Field",
      ([Master ID] = [_THISROW].[Master ID])
    )
  ),
  "Field_Form"
)

1 Like

the master id never changes, store name could be slightly different in some occasions

Beautiful!

image

LINKTOROW(
  [Store Name],
  "Field_Form"
)

Unless…

Then you should use the LINKTOROW() expression I gave before, with the ANY(FILTER(...)) component.

1 Like

You are the man, that did it, LINKTOROW( [Store Name], “Field_Form”)
Should I make the master id a key column in the pivot paste table instead just to be on the safe side?

1 Like

There can be only one key column. If you have references from other tables to the Field table, changing the key column will break those existing references. In an ideal world, though, both tables would probably use Master ID as their key columns, yes.

2 Likes