LINKTOFORM -> If condition in action

AppSheet AppSheet Q&A
,
1

I have an action with target LINKTOFORM(“FORM…”). But i need an IF to select FORM to go

It’s posible to create an IF (type=“active”, goto this LINKTOFORM if type=“deactive” go to LINKTOFORM(“2”… ) if type=“Finish” go to LINKTOFORM("3… ?

2

Yes. Use normal IF or IFS expressions very near to what you have written.

IF(condition A,
   LINKTOFORM("Veiw 1"...),

   IF(condition B,   ==> If not A
      LINKTOFORM("View 2"...),

      IF(condition C,  ==> if not B
         LINKTOFORM("View 3"...),

         ""   ==> If also not C then do nothing
      )
   )
)

OR, a better approach is to use the IFS() function like this:

IFS(
    condition A, LINKTOFORM("Veiw 1"...),
    condition B, LINKTOFORM("View 2"...),
    condition C, LINKTOFORM("View 3"...)
)
First condition that is TRUE will be used.  If none match, nothing happens.

Please see these articles for more details :

IF()

IFS()

LINKTOFORM()

LINKTOROW()

2 Likes
3

Works fine. Solved. Thanks