Pre-fill fields from URL link

[Richard_Hulbert]

Hi All,

I am using a QR code which contains a link to open a form in a public App. I want the link to also pre-fill the PROJECT ID (in the background). I have looked for examples for this URL and it has been suggested I use a JSON style expression as example below:

https://www.appsheet.com/start/f22******51#view=Users > Start Form&defaults={“PROJECT ID” : “b546cf16”}

The link works and opens the from but doesn't pre-fill the PROJECT ID on the Users Table when the data is submitted. If any one can help I would be very grateful.

Many thanks

Rich

@Aleksi @LeventK 

[SkrOYC]

Encode them

ENCODEURL() - AppSheet Help

[Richard_Hulbert]

Hi @SkrOYC 

Thanks for your reply. Not done this before, can you please give an example of how this would work with my URL:

https://www.appsheet.com/start/f22********251#view=Users > Start Form&defaults={“PROJECT ID” : “b546cf16”}

Many thanks

[SkrOYC]

Wrap your view and default values on an ENCODEURL() function

[Richard_Hulbert]

Hi SkrOYC,

Thanks for your response but unfortunately I must be doing something wrong as this is still not working. Is there any chance you could post an example of how I should do this preferably using my expression above?

Many thanks

Rich

[SkrOYC]

Post an example of what you did with ENCODEURL()

[Richard_Hulbert]

https://www.appsheet.com/start/f22*******-a118-aaa1a5135251#encodeurl(view=Users > Start Form&defaults={“ PROJECT ID ” : “ b546cf16 ”})

[Steve]

Where in the app configuration are you entering or constructing this link you want? Please post a screenshot of the entire app editor screen showing the configuration.

If you use Expression Assistant to configure the link, please also post a screenshot of the entire Expression Assistant screen showing the entire expression.

[Richard_Hulbert]

Hi Steve,

Not sure what you are asking. Essentially all I am trying to do is be able to scan a QR Code which opens the App in a form view with some pre-filled fields. I have searched the forum and documentation for various ways to do this but I don't really mind how I do it. If you have any other suggestions I would be very grateful.

Many thanks

[SkrOYC]

Here is a post by @Koichi_Tsuji 

Scan barcode with your native mobile camera and ju... - Google Cloud Community

He also makes use of ENCODEURL() on the right places so you should understand what I mentioned earlier about it