I have some small appsheets, google form and views in the screenshot below.
I have been able to navigate the small appsheets but struggle with navigating to google form from the dashboard below.
below is my script;
IFS([View Name]="A",LINKTOAPP("A4778820"),[View Name]="B",LINKTOAPP("B223455"),[View Name]="C.",LINKTOAPP("C-14562943"),[View Name]="D",LINKTOAPP("D48595"), [View Name]="E",LINKTOAPP("E89754"),[View Name]="F",LINKURL("https://docs.google.com/forms/xxxxxxxxxxxx"))
Hello there,
This will be much easier for you if you add the following columns to your "Menu" table:
target type (enum type, possible choices: "View" or "URL")
target app name (text)
target view name (text)
target URL (URL)
You cannot navigate to a view OR an external URL with a single action.
Your first action for navigation between apps would use this expression as a "Only if this condition is true":
[target type]="View"
And this as the target:
LINKTOVIEW([target view name],[target app name])
The second action would be for navigating to the external links would use this expression as a "Only if this condition is true":
[target type]="URL"
And this as the target:
[target URL]
and check the "launch external" option.
Now you just need a grouped action that runs both of these when your users click on any items on your menu.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |