Issue with QR Code in Generated PDF File

[anonymous]

Hellooo Amazing community.

I am having some trouble with my pdf that was generated in a workflow.

I have a QR code column (image type) in my table which generates a QR code using the following Formula:

CONCATENATE(
    "https://barcode.tec-it.com/barcode.ashx?data=https%3A%2F%2Fwww.appsheet.com%2Ftemplate%2Fgettablefileurl%3FappName%3DNewApp-2369121%26tableName%3DMaster%26fileName%3DFiles%2F",
    [Staff ID],
    ".pdf&code=MobileQRCode&dpi=300&imagetype=Png&eclevel=L"
)

In my app, the QR code URL is working as intended - see below:

However, when this QR code is generated in my PDF report (using workflow). The link is broken - see below:

Does anyone know the reason for this issue?

[Marc_Dillon]

What do you mean “the link is broken”? What exactly is the issue?

[anonymous]

Hi Marc. Thanks for the response.

The issue is that the QR code in my app does not have the same link as the one in the generated PDF.

My goal is to get this exact QR code to show in my PDF report:

But for some reason I’m getting the following instead:

[Joseph_Seddik]

The template-generated URL is truncated. Please check the expression inside your template, or just replace it with the value of your image column, instead of repeating the formula.

[anonymous]

Hi Joseph,

Below is my column type along with the value.

and below is my template:

is something wrong with it?

[Yogesh_laddha]

I am also facing the exact same issue for the last couple of weeks.

The QR code in the app works fine, but in the generated template it is different.

I am guessing it may be because of the large url we are trying to embed in QR?

Is there any solution to this?
@Marc_Dillon @Steve

[anonymous]

I was thinking the same thing. Maybe AppSheet has a minimum amount of URL characters that can be transferred in the template.

[Yogesh_laddha]

@Aleksi Can you help here?

[anonymous]

@WillowMobileSys you reckon you can help here?

[Marc_Dillon]

Maybe instead of tagging random people to help you, you should be experimenting with it yourself and providing more details into this thread.

[Yogesh_laddha]

Hi Marc,
I believe this community exists for people to ask for any advice and for people to offer any advice if they can.
Maybe if you had considered for a moment that we tried working and experimenting on the issue at our end for a long time and come here only after exhausting most options.
I also mentioned that it had been several weeks since I was looking for a solution.

We post here to understand if other users are facing similar issues or if there are certain limitations to Appsheet.

[anonymous]

Hi Yogesh,

Did you get to fix your issue?

[anonymous]

Hello!

Was going through the same, try the solution posted on the link below, it worked for me.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Incompleted-URL-when-generated-to-QR-barcode/m-p/414165

[SkrOYC]

Long story short:
ENCODEURL() - AppSheet Help

[komering]

same case, not work in my work when QR cannot complately genereted to PDf

[Marc_Dillon]

You shouldn’t be using nested encodeurl()s, that’ll cause issues. Just use one for the entire url string.

[jkevz]

Try this,

CONCATENATE(“https://quickchart.io/chart? chs=150x150&cht=qr&chl=”&SUBSTITUTE((CONCATENATE([Invoice No.],“with Total Amount of “,[Final Amount]));” “;”%20”))