Deep Links in A Table

yastaaa · 06-08-2021 06:34 PM

Hi,

I have a Table that has two columns. RACE_TRACKS Text Column and Deep Links Colums Type App Column. This table is in Deck View so when you click on the Track will link to a filtered view.

LINKTOFILTEREDVIEW(“Calendar”, [TRACK_NAME] = “AQUEDUCT” AND ([RACE_DATE] > EOMONTH(TODAY(),-1),[RACE_DATE] <= EOMONTH(TODAY(),2)) )

When in the deck view i click on the row, the app cannot display the filtered view.
This message pops up:

Marc_Dillon

What do you expect to happen with this portion of the expression? Perhaps you need to review how AND() works?

yastaaa

The expresion is working. I have tried it in a slice

Marc_Dillon

I doubt it.

Do you mean to use:

AND(
  [TRACK_NAME] = “AQUEDUCT” ,
  [RACE_DATE] > EOMONTH(TODAY(),-1) ,
  [RACE_DATE] <= EOMONTH(TODAY(),2)
)

?

yastaaa

Yes. That filter expresion works. The deep links either LINTOFILTEREDVIEW OR LINKTOVIEW don’t work.

yastaaa

Unable to fetch app definition.

App ‘LINKTOFILTEREDVIEW(“Calendar”, [TRACK_NAME] = “AQUEDUCT” AND ([RACE_DATE] > EOMONTH(TODAY(),-1),[RACE_DATE] <= EOMONTH(TODAY(),2)) )’ was not found.

Steve

Your expression is invalid in several ways, and given the error, I suspect you have it in the wrong place.

Please post screenshots of all configuration involved in this deep link.

yastaaa

It is not the expresion. The thing wrong is with Appsheet App Filed colum type that doesn’t work.
The deep links just work in the Actions.

yastaaa

Marc_Dillon

Your expression is definitely not correct. Now two people have told you this. Not sure what else to do here if you still don’t believe it…

A possibly 2nd issue is that you’re probably not using the App Type column correctly here. Your screenshots fail to show if there are any App Formulas or Initial Values in the [VIEW_LINK] column, are there? How did these values get to be in that column for those 2 rows. Do you have the literal strings “LINKTOVIEW…” and “LINKTOFILTEREDVIEW…” in as the data points? If so, that’s definitely not correct.

yastaaa

The expresion works in this slice perfectly. So that is not the problem.

Steve

Sounds like you know how everything works, so you clearly don’t need my help.

yastaaa

That is your problem how things sound to you. In fact there is another post in this blog with the same problem. I saw it once and i couldn’t find it anymore.

Steve

Sure you did.

yastaaa

This was the post.

yastaaa

With this simple expresion also does not work. With or Without app Name.

I think the deep links just work when you add them in actions in the panel Behaviour.

The URls work but you have also to create the View.

So I have to construct views for all TRACKS to work this way or have a form to filter base on a form where the user selects the TRACK.

What intrigues me is. What is the app type colum filed them for if cannot do direct linking to a view?

Steve

You’re still doing it wrong.

yastaaa

Why don’t you say how to do it. Maybe is because you don’t know.

Steve

Yes, please tell me I don’t know what I’m talking about.

https://community.appsheet.com/search?q=@steve

yastaaa

Then you are here for confusing people. I thought the purpose of Appsheets was to produce app with less code.

Fund a church. Write a book.

Steve

Again, I’ll refer you to the search link I posted. I’m clearly not here to confuse people.

Marc_Dillon

If you still need help, you could try to answer the questions that were asked of you.

yastaaa

This is the Data I will Have in the Columns Filled with Deep Links Expresions

yastaaa

yastaaa

yastaaa

This is the way it WORKS

The links have to be written this way

#appName=Yastaaa-2610605&view=Calendar%20%20Belmont%20Park%20(View)

I don’t know if it is possible to do filtering as it was supposed to do the LINKTOFILTEREDVIEW expression.