Linking directly to google forms

AppSheet AppSheet Q&A
,
1

I run a my business mostly on Google Forms and spreadsheets.
I ve successfully created an app that allows my users to view all spreadsheets and forms within the company structure but I am finding the native form input through appsheets to have limitations.

I am wanting to create and action that will open a new form submission with the actual google form being displayed.

I’ve created a NEW FORM action
Set the the form to the correct spreadsheet / form

Do this is set to EXTERNAL : GO TO WEBSITE

Then I am using the HYPERLINK
HYPERLINK(https: // docs .google.com/forms/, “New Form”)

The google form exists - the link above is redacted - however I get the error

Data action ‘New Form’ uses an invalid target URL expression ‘=HYPERLINK(https://docs.google.com/forms, “New Form”)’. Arithmetic expression ‘(“https:”/“docs.google.com”)’ has inputs of an invalid type ‘Unknown’

what am I missing?
everything Ive found sofar says that this approach should work.

2

disregard I needed to put “ “ around the they hyperlink to make it work

3 Likes
3

Hey,

Hope you’re keeping well.

In AppSheet, the HYPERLINK() function is meant for use in a column expression, not directly in an “External: go to a website” action. For an action that opens a Google Form, you can set the URL field in the action to a plain text expression containing the form link, for example:


"https://docs.google.com/forms/d/FORM_ID/viewform"
```

Make sure you use the full form URL from the Google Form’s “Send” > “Link” option, and wrap it in quotes if you’re entering it as an expression. Avoid `HYPERLINK()` in this context—the action will treat the value as a URL string directly, not a clickable label. Also verify the form’s sharing settings allow access to your users without requiring extra authentication.

Thanks and regards,  
Taz
1 Like