Is there a way to embed a "Google Forms" into the Appsheet?

[Luis_David_Alej]

I have a Google forms that I would like users to have direct access to from the App (to answer within the App) I am trying to embed the forms but its seems that this is not possible.

I hope that someone can help me with this problem

[Aleksi · Accepted solution]

Unfortunately you can’t embed Google Form directly to your app. Though you can use the Form as a data source but if you want forward your users to that Form, your users need to open the form from the URL link.

[Steve]

Why not have the users answer the questions directly with the app?

[Luis_David_Alej]

I would like the questions to send feedback of right and wrong answers, that’s why I was using google forms. The Appsheet forms can do this?

[Steve]

Luis_David_Alejandro:

The Appsheet forms can do this?

They certainly can!

help.appsheet.com

Valid_If Column Constraint

How to check if a given form input is valid based on its type.

[Luis_David_Alej]

Thank you Steve!

[James_McFarlane]

Hi @Steve

Would it be posible to send out pre-filled links to an AppSheet form like in google Forms?

[LeventK]

@James_McFarlane
Yes it is possible with correctly structured deep link

[James_McFarlane]

@LeventK

We need to send out a form to X quantity people, we would have a public app for this.

1. When you say correctly structured deep link what do you mean, could you provide a sample?
2. Were would I construct this link?
3. Could I send it out via a Workflow?

[LeventK]

@James_McFarlane

James_McFarlane:

1. When you say correctly structured deep link what do you mean, could you provide a sample?

You can use a URL like this:

CONCATENATE (
    "https://www.appsheet.com/start/Your_AppID_here#view=",
    ENCODEURL("Your_Form_Name_Here"),
    "&defaults={'KeyColumn': ' ",
    UNIQUEID(),
    " ', 'AnotherColumn': ' ",
    [SourceColumn],
    " '}"
)

James_McFarlane:

2. Were would I construct this link?

In the email body of your Email Workflow. Provided you want, you can also use HYPERLINK() expression or <a href='....'>Click Here</a> HTML tag

James_McFarlane:

3. Could I send it out via a Workflow?

Yes of course…See above item response

You may also check this sample app:
https://www.appsheet.com/samples/How-to-create-a-prefilled-form-with-an-email?appGuidString=3aae0194...

[David_Joyce]

Im actually trying to finish up doing this right now. I wanted a survey type form for visitors to a website to fill in. I started doing it in Google Forms, then realised that it AppSheet could do it better. So I looked at the browser link to an app with one Form. However…

how do you restrict users to their own data after they click “Save/Submit”?

Obviously the one Form app is a public app with no security filters (its an enquiry / survey)

[LeventK]

@David_Joyce
With public apps all app data can be filtered out so that no any data can be seen. For the workflows only you have an option to bypass the security filters otherwise no any data can be retrieved from the source table. You can see that filtering option under the Security tab of your table’s details.