LINKTOFILTEREDVIEW with data value filter

[DaGi07]

Hello to everyone,
I’m working on a budget tracker for my family and I’m trying to create an action with a filter condition–> When i click on this action in the red box, i would see only the data related to the income of the mounth (december 2021)

This detail view is based on table “Bilancio” as you can see in this printscreen.

When i click in the action i would see in the app the value related to the december mounth on the table “Entrate” in the UX “Cash In”

I’m using this formula in the action
LINKTOFILTEREDVIEW(“Cash In”,[Data]=[???])

Could I use formula CONTAINS? In order to select only data value that contains the month in the data?

TKS to ALL!!!

[Suvrutt_Gurjar]

You could try the below expression

LINKTOFILTEREDVIEW(“Cash In”,TEXT([_THISROW].[Data],“MMYYYY”)= TEXT([Data],“MMYYYY”))

Edit: Made changes to the expression to take care of year component as well.

[DaGi07]

Suvrutt_Gurjar:

LINKTOFILTEREDVIEW(“Cash In”,TEXT([_THISROW].[Data],“MMYYYY”)= TEXT([Data],“MMYYYY”))

It works perfectly, could you explain me this expression in word? I’d like figure out better the syntax.
TKS!!

[Suvrutt_Gurjar · Accepted solution]

Basically the TEXT() expression extracts the month and date( “MMYYYY”) from the [Data] column of the “Bilancio” table with the expression TEXT([_THISROW].[Data],“MMYYYY”) and compares it with the [Data] column values of the “Entrate” with the expression TEXT([Data],“MMYYYY”)

Thus only the filtered rows in the table “Entrate” matching the month and year from “Bilancio” table are returned. The expressions use TEXT() functions.

help.appsheet.com

TEXT()

Format as text

For constructing LINKTOFILTEREDVIEW() between two tables, please take a look at the below article

help.appsheet.com

App Column Type (Deep Link)

Learn how to use deep links to navigate to another view in the same app, or in another app.

[DaGi07]

You’ve been very kind! TKS