linktofilteredview doesn't work suddently?!

AppSheet AppSheet Q&A
, ,
1

Hello , I am using linktofilteredview function in “Actions” as the image below:

1.png
1.png1849×965 135 KB

It worked perfectly until yesterday. But today I cannot use it in production. As the picture shown above, it can be loaded the pdf file successfully in preview after save. However, all the productions (android, IOS, webpage) cannnot load pdf from Google Drive like below. (Automation runs perfectly to generate pdf and saved to Google Drive)

The weirdest thing is, all the pdf file can be loaded before yestereday. all the data added today cannot load pdf.

11.png
11.png1200×712 181 KB

No matter how many times I refresh or restart appsheet. It still cannot fetch the pdf as normal.

Is it only my problem or what happens to linktofilteredview function. Thanks

@Steve @WillowMobileSys @SkrOYC @Suvrutt_Gurjar @dbaum

2

I’d have to assume your LINKTOFILTEREDVIEW() expression is broken somehow. Please post a screenshot of the entire expression.

3

Hello Steve,

I use Automation to generate pdf as below:

2.png
2.png1492×1008 32.9 KB

Above Automation works perfectly to generate pdf files to my Google drive when the table is updated as below:

3.png
3.png1500×1064 38 KB

Here is the LINKTOFILTEREDVIEW() in Actions’ formula below. I see it works on “Preview panel” but not work in any productions. Thanks

1.png
1.png1500×1026 36.2 KB

4
LINKTOROW() - AppSheet Help
1 Like
5

Hello SKrOYC,

I tried to rewrite formula. It show formula correct, but it doesn’t work at all. Not sure why.. Thanks

LINKTOROW(
Concatenate(text([InputDate],YYYYMMDD),text([InputTime],HHMMSS),"-",text([EventStartDate],YYYYMMDD),"-",[EventName],"-",[VendorNo],".pdf")
,"PDFFiles_detail"
)