check value in label then make perform code

[Anonymous]

I have a dropdown with onChange event happening below.

I have a label with a numeric value in it.  "lbl_Open_Chk"

if that value  =  1 in the label I do not want the code below to execute.

I need a warning stating a "task is already open"

If(dwn_ChangeStatus.Selected.Value = "Open",Set(TheVar,Now());
Reset(txt_ReOpenedDate));
If(dwn_ChangeStatus.Selected.Value = "Open",Set(varCSPSALES, "YES"));
If(dwn_ChangeStatus.Selected.Value = "Closed",Set(varCSPSALES, "YES"));
If(dwn_ChangeStatus.Selected.Value = "In Progress",Set(varCSPSALES, "NO"));

Thanks

Dave 

[UdayAdhikari]

Hi @Anonymous, I would try something like below. Add the code to OnChange event of dropdown control. First, I am checking to see if level value is "1" to display warning and in else condition adding a Switch control which is better performing as compare to multiple if statements.

If(
    lbl_Open_Chk.Text = "1",
    Set(
        varCSPSALES,
        "Task is already open"
    ),
    Switch(
        dwn_ChangeStatus.SelectedText.Value,
        "Open",
        Set(
            varCSPSALES,
            "YES"
        );
        Set(
            TheVar,
            Now()
        ),
        "Closed",
        Set(
            varCSPSALES,
            "YES"
        ),
        "In Progress",
        Set(
            varCSPSALES,
            "NO"
        )
    )
)

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks

[iAm_ManCat · Accepted solution]

Hi,

You should be able to do the following logic:

If the textbox content is equal to 1, show a notification, otherwise execute the code you had previously

This would look like:

If(
   lbl_Open_Chk.Text = "1",
   Notify("Task is already open", NotificationType.Warning),

   //Otherwise if not equal to 1 then perform existing code
   If(dwn_ChangeStatus.Selected.Value = "Open",Set(TheVar,Now());
   Reset(txt_ReOpenedDate));
   If(dwn_ChangeStatus.Selected.Value = "Open",Set(varCSPSALES, "YES"));
   If(dwn_ChangeStatus.Selected.Value = "Closed",Set(varCSPSALES, "YES"));
   If(dwn_ChangeStatus.Selected.Value = "In Progress",Set(varCSPSALES, "NO"));
)

Cheers,

Sancho

[UdayAdhikari]

@Anonymous - sorry, I miss read your notification question which @iAm_ManCat (Sancho) covered in his response. So, here is the updated code:

If(
    lbl_Open_Chk.Text = "1",
    Notify("Task is already open", NotificationType.Warning),
    //If label value is not equal to "1"
    Switch(dwn_ChangeStatus.SelectedText.Value,
        "Open",
          Set(varCSPSALES, "YES");
          Set(TheVar, Now()),
        "Closed",
          Set(varCSPSALES, "YES"),
        "In Progress",
          Set(varCSPSALES, "NO")
    )
)

[Anonymous]

@iAm_ManCat,

So when the warning is displayed...do they exit  out of the "onChange" event automatically ?

Dave

[Anonymous]

@UdayAdhikari 

@iAm_ManCat,

Sorry did not explain myself well.

I have a table(tbl_Tasks) with the values of the "Change Status" dropdown displayed.

When a person makes a choice in the dropdown, i'm doing a check to make sure 2 tasks are not open at the same time.

I have the lbl_Open_Chk display either 0 or 1

So basically what I need to make sure is , no 2 tasks open at the same time.

sorry had to black out some information with the arrows.

Thanks

Dave

[UdayAdhikari]

@Anonymous - yes, that's true! OnChange event is triggered only once per value change in the dropdown so warning is displayed and exits out of that event.

[Anonymous]

ok, one last question.

If they Select "Open" how do I automatically change the value back to:

dwn_ChangeStatus.Selected.Value = "In Progress" after the warning ?

Thanks

Dave