Help with expression for starting view

Lucinda_Mason · 04-07-2020 12:24 PM

When opening my app I want to do the following:

If the user has a record in my USER table - by matching useremail() with USER.USERS_EMAIL
THEN open the form named LAUNCHER
OTHERWISE open the form named “ADD NEW USER”

Could someone help me with the expression?

I have some other steps to do when opening Launcher based on a specific value from the USER table but I can’t work on that until I get this expression working.

Thanks in advance.

Let me know if you need more info on what I’m trying to do.

Lucinda

Steve

Try:

IF(
  IN(
    USEREMAIL(),
    USERS[USERS_EMAIL]
  ),
  "LAUNCHER",
  "ADD NEW USER"
)

Lucinda_Mason

Perfect Steve. Thanks so much!

Lucinda_Mason

Steve, I created an action to open the Launcher form and set it on the Add New User - Form Saved event. I get the first error when clicking Save. If I say OK, I get the second error. The second error is probably due to the app being re-synced and loaded again.

How can I run an action on the form saved event and make sure the data is saved before it runs? I think that is the issue.

Thanks again.

Lucinda_Mason

More info. I turned Off the Delayed Sync option. That actually forced a sync, showing me the sync screen, then ended up with the same error messages as before. The only difference being that the new user record was saved before the first message appeared. But the action still couldn’t run.

Steve

These references to “app” suggest your action is targeting another app rather than a form within this app:

What is the Target expression of your action?

Lucinda_Mason

I’m simply telling it to open my Launcher form. See photo.

Steve

That’s not actually how that works. You’ll need to use an expression that uses a LINKTO…() function, such as:

Lucinda_Mason

Thanks. I used LINKTOVIEW(Launcher) and it worked.

Is there any reason to choose LINKTOVIEW versus LINKTOFORM in my case?

Steve

LINKTOFORM() will create a new row in the table. LINKTOROW() will visit an existing row. LINKTOVIEW() will go to a view that isn’t row-based (e.g., deck, gallery, or table), or that infers the row.

Lucinda_Mason

Great. That explains it clearly. Appreciate it.