0

I am trying to make my arrow button have the following logic, If Status = Submitted, do not go into the edit screen.

I pretty much want to lock the record if Status is submitted.

I tried the below and it doesn't work.

enter image description here

Any help would be appreciated.

4
  • Are you getting any error? What is the data type of "Status" column, choice or single line of text? Is your "edit screen" & BrowseScreen1 same? Mar 3, 2022 at 17:03
  • No error, Status in ms list is actually a "single line of text" . Edit screen and Browse screen are 2 separate screens.
    – Jonnyboi
    Mar 3, 2022 at 17:06
  • In your formula, you are not redirecting user to edit screen when status is submitted instead you are redirecting to browse screen. Then what is the problem with your formula here? Mar 3, 2022 at 17:08
  • the formula is directing to edit screen, it should be staying on the same screen if Status=Submitted
    – Jonnyboi
    Mar 3, 2022 at 17:10

1 Answer 1

1

If Status column is of type "Single line of text", try using formula like:

If(ThisItem.Status = "Submitted", Navigate(BrowseScreen1, None), Navigate(EditScreen1, None))

This formula will redirect user to BrowseScreen1 when Status="Submitted" else it will redirect user to EditScreen1.


If you want user to stay on same screen when Status="Submitted", use this:

If(ThisItem.Status = "Submitted", false, Navigate(EditScreen1, None))
3
  • why do you use <> over = , it doesn't seem to work with either.
    – Jonnyboi
    Mar 3, 2022 at 17:09
  • <> is for "Not equal to" operations. you can use either one based on your conditions. Mar 3, 2022 at 17:13
  • 1
    ah okay got it, I think my "Select(Parent)" was throwing off the functionality. Your formula works!
    – Jonnyboi
    Mar 3, 2022 at 17:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.