Date and Text Label Result not working! Please help

[lolla70]

Hi 

I really need your help, I gave up😥

The Next Check-In stopped working when the result is "Work from home". When I logged out and log in to the APP I should see the Result Message and the Date till next day, however it is showing to start from beginning. How I fix this issue?

The Next Check-In OnText Code

With({_email: User().Email},

"Next Check-In Date " &

If(lblResult_1.Text = "Work from Home",
DateAdd(Today(), 1, Days),
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Check in Required",
With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
Text(
With({_utc: First(_records).'Next Check-In Date'},
DateAdd(_utc, TimeZoneOffset(_utc), Minutes)
),
ShortDate
)
)
)
)
)

The Work from Home OnText Code 

If(
IsBlank(ListBox3_1.Selected.Value),
"Well-check Status Required",
If(
ListBox3_1.Selected.Value = "Home",
"Work from Home",
ListBox4_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "No",
"Clear for Office/Field work"
)
)

[RandyHayes]

@lolla70 

According to the formula, if your Label shows "Work from Home", then you should be seeing Today's date plus on day.  Is that the part that you are stating is not working?

[lolla70]

Yes that is correct. I can see it but when I logged out from the APP and open again, the "Work from Home Message" and Check-in turn like new record and I want the message and the date to be seen and still there till Next check-in date

[RandyHayes]

@lolla70 

It seems like this would hinge on the ListBox3_1 as that is what causes your Label to display "Work from Home".  After that, the formula on the Next Check In is all based on that label.  What is that listbox about and how is it set up?

[lolla70]

For the ListBox there is 3 choices, based on the choice it will go to the next question till the confirmation, EXCEPT the "Home" selection. 

OnSelect Code

If("Home" in ListBox3_1.Selected.Value, Navigate(scrMain, ScreenTransition.Fade), lblResult_1);

the Confirmation Button OnSlecet Code

With({_user: User()},

Patch(
'Back to Work Eligibility',
Defaults('Back to Work Eligibility'),
{
Title: "Status from " & _user.FullName & " on " & Text(Today(), ShortDate),
'Check-In Date': Today(),
'Eligibility Status': EmployeeEmail_1,
Result: lblResult_1.Text,
'Working Location': lblWorkingFrom_2.Text,
'Office Location': ThisItem.Title,
'Next Check-In Date': DateAdd(Today(), 1, Days),
Employee: {
Claims: "i:0#.f|membership|" & Lower(_user.Email),
Department: "",
DisplayName: _user.Email,
Email: _user.Email,
JobTitle: "",
Picture: ""
}
}
)
);
Navigate(scrMain, ScreenTransition.Fade);

[RandyHayes]

@lolla70 

Yes, but what I am saying is that your original Formula for what is displayed in the button text is based on lblResult_1.Text which according to the formula on that control is based on the ListBox3_1.Selected value.  

So, before more confusion....is the Label "Work from Home" correct in your picture?

If it is, then your Formula for that check in text button says that it should show Today's date plus 1 day.

Is that incorrect, and in what way?  

[lolla70]

Yes that is correct, It is based on the lblResult_1 OnText Code

If(
IsBlank(ListBox3_1.Selected.Value),
"Well-check Status Required",
If(
ListBox3_1.Selected.Value = "Home",
"Work from Home",
ListBox4_1.Selected.Value = "Yes",
"Work from Home, HR",
ListBox5_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "No",
"Clear for Office/Field work"
)
)

[RandyHayes]

@lolla70 

So, based on everything you are saying:

- lblResult_1.Text is based on ListBox3_1.Selected (still don't know what that is) and it is Displaying "Work from Home"

- Your formula on the CheckIn button text is based on lblResult_1.Text, and if it is Work from Home, then it will display Today's date plus 1

So...what is the issue?

[lolla70]

ListBox3_1

onItem 

["Office", "Field", "Home"] 
OnSelect

If("Home" in ListBox3_1.Selected.Value, Navigate(scrMain, ScreenTransition.Fade), lblResult_1);

My issue is 

1) the Next Check-In Date when the Home got selected "Work from Home, it just show one time and it didn't stay till next day ie. select Home and I got the Work from home message the next day shows as Next Check-In 2/26/2021 when I close the App and sign in the date is no longer there. I need to keep seeing the date till 2/26/2021. Also I need to keep showing the lbl message till next day

2) If for example I get "Contact HR" or "Clear to Work" message, the next day keep showing till next day because we are patching it. However the Message don't stay till next day. 

So I need to FIX 2 the text message to stay till next day even if exit the APP, so if sign in back the same day I want to see it.

As well I need to see the Next sign in Date till next day especially for the Work from Home cause the other are working cause we are patching it.

[RandyHayes]

@lolla70 

1) the Next Check-In Date when the Home got selected "Work from Home, it just show one time and it didn't stay till next day ie. select Home and I got the Work from home message the next day shows as Next Check-In 2/26/2021 when I close the App and sign in the date is no longer there. I need to keep seeing the date till 2/26/2021. Also I need to keep showing the lbl message till next day
Yes, so again, there is nothing in your formula chain (button to label to listbox) that would do anything except what you are seeing.  I see no place that you would be setting things back to how they were when the app closes.  Ideally, it sounds like what you really need to do is have your listbox show the last value selected (which you can't do with a listbox) and, somewhere along the line, record that the person actually selected something so that when your app starts again, it will know that something was already selected for the day.

2) If for example I get "Contact HR" or "Clear to Work" message, the next day keep showing till next day because we are patching it. However the Message don't stay till next day. 

So I need to FIX 2 the text message to stay till next day even if exit the APP, so if sign in back the same day I want to see it.

As well I need to see the Next sign in Date till next day especially for the Work from Home cause the other are working cause we are patching it.

This is not how your formula is currently written.  The message is based on your Listbox selection (which again, you cannot set) and the label is based on what is in that listbox, and the check in button text is then based on that label.  So, it's not possible to achieve what you want with that logic.  It will need to be adjusted based on what you are trying to accomplish.  You will need to lookup the stored values you have set in your list and then make determinations based on that stored value.