If !isBlank & IsBlank Unexpected characters...

[Mareliese]

Hello, 

I'm receiving the Unexpected characters. The formula contains 'ParenClose' where 'Comma' is expected and need assistance on how to sort the error message. 

On a Select button moving from one Edit Screen to the following Edit Screen, I have the If function to check on 2 conditions before moving to the next screen. Checking / testing one at a time works but combining the 2 is my issue where I receive the error message. 

Please assist with how do I combine the two I checks before being able to move to the next Edit Screen. Thank you. 

[timl · Accepted solution]

Hi @Mareliese 

Could you try this to see if it works? I think there might have been an extra comma.

If(
   !IsBlank(LookUp(JobCardMetering,
                 "ID_Column" = DataCardValue_JobCardNo.Text
                 )
         ) &&
   IsBlank(LookUp(JobCardMetering,
                "Employee" = DataCardValue4_Employee.Text 
                )
),
SubmitForm(EditForm1_Intro),
Notify(
"The saem Job Card has been submitted. A new Job Card no. was generated. Please check.",
NotificationType.Error
)
);
Refresh(JobCardMetering)

[eka24]

Remove the double quotes on the ID_COLUMN and Employee 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[timl]

@Mareliese 

I suspect that eka24 is correct in that you need to remove the double quotes.

If(
   !IsBlank(LookUp(JobCardMetering,
                 ID_Column = DataCardValue_JobCardNo.Text
                 )
         ) &&
   IsBlank(LookUp(JobCardMetering,
                Employee = DataCardValue4_Employee.Text 
                )
),
SubmitForm(EditForm1_Intro),
Notify(
"The saem Job Card has been submitted. A new Job Card no. was generated. Please check.",
NotificationType.Error
)
);
Refresh(JobCardMetering)

The reason I didn't mention this is because you said that Checking / testing one at a time works.

Can you confirm that's really the case? Is it actually returning the correct data with the double quotes?

[Mareliese]

Thank you timl,

Your formula is working. But I still cannot see the extra comma comparing yours to mine 😀.

But thank you. It is working 😀.  I probably need a different pair of eyes. 

Thanks

Mareliese 

[Mareliese]

Thank you eka24. 

It works without having to remove the double quotes. 

My column names is in the double quotes. 

What is the difference between double quotes and no quotes?

Please let me know. 

Thank you

Mareliese 

[Mareliese]

Correct timl, 

It was and is working with the column names in the double quotes. 

Your formula with removing comma, which I cannot see 😁, fixed the problem. 

Thanks

Mareliese 

[eka24]

Double quotes is used for Text like "abcd"

Whiles single quotes is used to wrap column names  or Table Names with spaces

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[timl]

Mareliese - glad that fixed the problem for you!

For these types of issues, I find that stepping through each line and indenting the code can often help identify where there's a missing character.

Good luck with the rest of your app!

[Mareliese]

Thank you eka24. 

I've changed the the column names to single quotes, and all is working. 

(I'm wondering why in this case it did not make a difference?!)

Thank you

Mareliese