Generated qrcode with a URL Link is reduced 'without explanation' (also: prefill google form)

[baba_sawane]

Hi, I'm facing a strange behavior while creating a Qrcode to an app view.

The link on the QR Code is reduced, showing the default app start link but not the one I linked with my formula...

Anyone with an idea of why it's happening ?

This is the formula i'm using to generate the qr code : 

concatenate("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=",[ApprovalLink])

Have a nice day.

[baba_sawane]

edit : it may be because my url is too long... 

Any workarounds ? 😞 

[Marc_Dillon]

What is the value in [approvallink]?

[baba_sawane]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Convert-DEEPLINKS-to-Full-External-URLs-for-Use-...

I used the method described in this post :

SUBSTITUTE(
"https://www.appsheet.com/start/{PUBLIC_APP_ID}#appName="&[AppLink],
"#control","&control")

[baba_sawane]

Hey ! I'm updating this because I'm still facing the issue for another use case. 

Here is an exemple of formula i'm using to generate the QR Code : 

CONCATENATE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=",
  ENCODEURL(
    CONCATENATE(
      "https://docs.google.com/forms/d/e/(myformid)/viewform?usp=pp_url&entry.1555339817=",
      ANY(
        SELECT(
          Plan de contrôle[CODE CHANTIER],
          CONTAINS([Related PDC_Zones], ANY(SELECT(PDC_Zones[ZoneID], [ZoneID] = [_THISROW].[Zoneliée])))
        )
      )
    )
  )
)

Everything works fine. I mean, the QR Code is generated as intended, when I preview my data, the link is as it should be. BUT the QR Code itself then somewhat reduced and it just return to my default values.

If anyone have any guess on how to fix it, it would be amazing !

I think it's because the link is too long and reduced by the appsheet system, but not sure.

[baba_sawane]

After checking, my link are changing into : 

https://docs.google.com/forms/d/e/(myformid)/viewform?usp=pp_url 

[baba_sawane]

Tried increasing the qr code size from 150x150 to 500, did not work

Update : tried with another api, did not work so i guess it's an appsheet issue 😷

Tried to encode the form url, no success

[baba_sawane · Accepted solution]

I got it working using form.jotform.com instead of Google Form. note that you have to encode your url structure using ENCODEURL()

I GAVE UP with google form. I searched for a fix for 7 hours straight and no ones seems to have found a fix. So I will use jotforms and link it to my sheets db for now. 

I can't even say if the issue is from appsheet or not now. The sad thing is that, using a third extension tool to create and make forms, because you can't from the native app is counter productive. Some Google products integrations to appsheet should just make sense like --appsheet based google form (editable only from appsheet, but can be shared externally). Why would we have to go to such measures just because the one you're interrogating is not an user ?

[cikguhelmi]

if this solve ur problem

https://www.appsheet.com//templates/?appGuidString=5cc261b0-e581-4a51-aad5-ddeff5666cc7