I have a table which contains a list of records. Each record can have either a URL to an external website (such as Google) OR the name of a VIEW. When a user selects a record, the app should be able to determine whether to call the HYPERLINK to display the external website, or change the page to the VIEW specified in the record. I have tried IF and IFS statements but these require the same type for the true/false condition to work, and the APP type used to change views is different to the URL type for hyperlinking. A workaround is to use a deep link for the VIEW, but this loads a second Appsheet instance of the app rather than simply opening the relevant view in the same app.
How do you have your data setup?
@jazzedge
[Menu View] column shall be App Type and and in your gSheet you can construct the expression like this:
For councillors:
#control=Members
In your action, construct the expression as:
IF(
ISNOTBLANK([Menu View]),LINKTOVIEW([Menu View]),
HYPERLINK([Menu Link])
)
Brilliant, thank you. That works. Much appreciated!
Youโre welcome
Hello,
I have the same problem.
In the behavior type (Do this) what I could I choose?
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |