Very Basic If Statement not working.

(0) Share

Report

Posted on by ShondaT

228

Can anyone give me an idea why this is rendering an error:

If(NCAForm_1.Mode = FormMode.New, User().Email, Parent.Default)

The other issue I'm having is that my gallery will not filter on the user which is part of the solution the above code is in.

I've set the variable onStart as required, but when I add the filter function to the gallery it returns no records. When I hover over the variable the message provided is "We didn't find any data."

Categories:

General Questions

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Very Basic If Statement not working.

@ShondaT

Coalesce() reads its elements from left to right until it finds a non blank one) in new forms Parent.Default is blank but otherwise it will have a value.
NZ0090 317 on at

Like (0)

Report

Re: Very Basic If Statement not working.

@ShondaT Can you share what the error message is? Click on the x > Get help for this error
ShondaT 228 on at

Like (0)

Report

Re: Very Basic If Statement not working.

@Drrickryp I'm so very sorry but I am not following what you're saying very well. This code appeared to work in one of Shane Young's videos. So I'm still at a complete loss. If you could explain further I'd really appreciate it.
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Very Basic If Statement not working.

@ShondaT

Coalesce(Parent.Default, User().Email)

In New forms, Parent.Default is blank.

Activate Named Formulas in the settings and in App.Formulas

useremail = User().Email;

You can then filter your gallery with useremail.