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.