Answered

Disable Submit Button with Nested IF statement

(0) Share

Report

Posted on by Xinlin

I'm trying to disabled / edit a submit button on my form and this form has an "Instrument" dropdown field that allows users to choose A, B, C, D, E etc.

So if user chooses A, there will be few more related columns showing up for users to fill up relevant information.

I wish to disable the submit button if the relevant fields are not filled up. I tried to do it with Nested IF statement, but the button didn't disable accordingly. Wish to have someone to help me look into it because I wasn't sure which part of it went wrong.

Here's the logic I'm using:

If(
 !IsBlank(DataCardValue15.Selected.Value) && 
 !IsBlank(DataCardValue35_1) && 
 !IsBlank(DataCardValue36_1) && 
 !IsBlank(DataCardValue37_1) && 
 !IsBlank(DateValue2_1.SelectedDate),
 If(
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "A" 
 Or !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "B") && 
 !IsBlank(DataCardValue53_1) && !IsBlank(DataCardValue48_1) && 
 !IsBlank(DataCardValue49_1) && !IsBlank(DataCardValue50_1) && 
 !IsBlank(DataCardValue51_1)) 
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "C" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "D")) && 
 !IsBlank(DataCardValue52_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "E" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "F")) && 
 !IsBlank(DataCardValue55_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "G") && 
 !IsBlank(DataCardValue43_1.Selected.Value) && 
 !IsBlank(DataCardValue44_1.Selected.Value) && 
 !IsBlank(DataCardValue45_1.Selected.Value) && !IsBlank(DataCardValue46_1) && 
 !IsBlank(DataCardValue47_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "H" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "I")) && 
 !IsBlank(DataCardValue54_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "J") && 
 !IsBlank(DataCardValue39_1) && !IsBlank(DataCardValue40_1) && 
 !IsBlank(DataCardValue42_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "K") && 
 !IsBlank(DataCardValue39_1) 
 && !IsBlank(DataCardValue40_1) 
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "L") Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "M") 
 ,DisplayMode.Edit,
 DisplayMode.Disabled
))

Thank you in advance!

Categories:

General Questions

All responses (5)

Answers (2)

Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like (1)

Report
Re: Disable Submit Button with Nested IF statement

@Xinlin

If( IsBlank(DataCardValue15.Selected.Value) || IsBlank(DataCardValue35_1.Text) || IsBlank(DataCardValue36_1.Text) || IsBlank(DataCardValue37_1.Text) || IsBlank(DateValue2_1.SelectedDate) || IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)') || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["A", "B"] && ( IsBlank(DataCardValue53_1.Text) || IsBlank(DataCardValue48_1.Text) || IsBlank(DataCardValue49_1.Text) || IsBlank(DataCardValue50_1.Text) || IsBlank(DataCardValue51_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["C", "D"] && IsBlank(DataCardValue52_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["E", "F"] && IsBlank(DataCardValue55_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["G"] && ( IsBlank(DataCardValue43_1.Selected.Value) || IsBlank(DataCardValue44_1.Selected.Value) || IsBlank(DataCardValue45_1.Selected.Value) || IsBlank(DataCardValue46_1.Text) || IsBlank(DataCardValue47_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["H", "I"] && IsBlank(DataCardValue54_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["J"] && ( IsBlank(DataCardValue39_1.Text) || IsBlank(DataCardValue40_1.Text) || IsBlank(DataCardValue42_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["K"] && ( IsBlank(DataCardValue39_1.Text) || IsBlank(DataCardValue40_1.Text) ) ) || ( !(DataCardValue38_1.Selected.'Instrument (instrument)' in ["L", "M"]) ) , DisplayMode.Disabled, DisplayMode.Edit )
Xinlin 82 on at

Like (0)

Report

Re: Disable Submit Button with Nested IF statement

It came back with springy underline for the rest of the codes (sobs)
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Disable Submit Button with Nested IF statement

@Xinlin

Delete the "," between the parentheses after "fixed income"
Xinlin 82 on at

Like (0)

Report

Re: Disable Submit Button with Nested IF statement

I'm getting an unexpected warning towards the end of the code. As for L & M, I wish the button will be enabled if L or M is selected.

Thank you.
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Re: Disable Submit Button with Nested IF statement

@Xinlin

With({_cond: Or(IsBlank(DataCardValue15.Selected.Value), IsBlank(DataCardValue35_1), IsBlank(DataCardValue36_1), IsBlank(DataCardValue37_1), IsBlank(DateValue2_1.SelectedDate) ) _instr: DataCardValue38_1.Selected.'Instrument (instrument)' },_cond && Switch( _instr, "A" || "B", Or(IsBlank(DataCardValue53_1), IsBlank(DataCardValue48_1), IsBlank(DataCardValue49_1), IsBlank(DataCardValue50_1), IsBlank(DataCardValue51_1) ), "C" || "D", IsBlank(DataCardValue52_1), "E" || "F", IsBlank(DataCardValue55_1), "G", Or(IsBlank(DataCardValue43_1.Selected.Value), IsBlank(DataCardValue44_1.Selected.Value), IsBlank(DataCardValue45_1.Selected.Value), IsBlank(DataCardValue46_1), IsBlank(DataCardValue47_1) ) "H" || "I", IsBlank(DataCardValue54_1), "J", Or(IsBlank(DataCardValue39_1), IsBlank(DataCardValue40_1), IsBlank(DataCardValue42_1) ), "K", Or(IsBlank(DataCardValue39_1), IsBlank(DataCardValue40_1) ), !("L" || "M"), //I'm not sure what you want to happen if "L' or "M" is selected ),DisplayMode.Disabled, DisplayMode.Edit ) )