Validation workflow and order of selection

AppSheet AppSheet Q&A
1

Hi friends,

Building an app related to training requests processing , I want to create an order of appearance of request approval in a column named “Etat Demande” so that when the request is submitted the training coordiantor will not be confused which step to choose in processing the request.

So ,I have three main users for this app:Admin ,Coordiantor and User.

The user initiates requests and the coordiantor starts to process the request following a defined order as follows:The initial value in column “Etat Demande” is :e_mail: Submitted (when the request is made).

Summary of Status Flow:

  1. :e_mail: Submitted→ Can change to :hourglass_not_done: In processor :cross_mark: Rejected
  2. :hourglass_not_done: In process→ Can change to :white_check_mark: Acceptedor :cross_mark: Rejected
  3. :white_check_mark: Accepted→ Can change to :+1: Confirmed
  4. :+1: Confirmed→ Can change to :play_button: Ongoing
  5. :play_button: Ongoing→ Can change to :bullseye: Completed
  6. :cross_mark: Rejected→ Can change to :prohibited: Cancelled
  7. :bullseye: Completed→ No further changes allowed

Note also that some other users who approve (accept or reject request) receive an embedded appview through email to choose between :white_check_mark: Acceptedor :cross_mark: Rejected (I want only these two values appear in the embedded appview).

How to make the values above appear in order to avoid any confusion?

Best regards,

2

Use validation to set the valid list of choices. something like this:

IFS(
    CONTEXT("View") = "Embedded View", {"Accepted", "Rejected"}),
    [Status] = "Submitted", {"Submitted","In Process"."Rejected"},
    [Status] = "In Process",{"In Process","Accepted"."Rejected"},
    [Status] = "Accepted",{"Accepted"."Confirmed"},
...
)

NOTE: You might also need to think about “undo” functionality. For example, if the status is Submitted and they accidently choose Rejected, it would be nice to go back to Submitted without the need to Cancel the Form View and start over. This requires also adding inthe “undo” option into the list.

I am not as familiar with embedded views…BUT I believe if you create a specialized view used in the email that you can specify the validation as indicated in the above expression.

I hope this helps!

2 Likes
3

Thank you for your interest;

I get it working using this expression:

IF(
CONTEXT(“View”)=“Stage_Detail”,
LIST(" :white_check_mark: Accepted", " :cross_mark: Rejected"),
SWITCH(
[Etat Demande],
" :e_mail: Submitted", LIST([Etat Demande], " :hourglass_not_done: In process", " :cross_mark: Rejected"),
" :hourglass_not_done: In process", LIST([Etat Demande], " :white_check_mark: Accepted", " :cross_mark: Rejected"),
" :white_check_mark: Accepted", LIST([Etat Demande], " :+1: Confirmed"),
" :+1: Confirmed", LIST([Etat Demande], " :play_button: Ongoing"),
" :play_button: Ongoing", LIST([Etat Demande], " :bullseye: Completed"),
" :cross_mark: Rejected", LIST([Etat Demande], " :prohibited: Cancelled"),
" :bullseye: Completed", LIST([Etat Demande]),
LIST([Etat Demande])
)
)

The idea of undo you referred to is nice but I have not any idea on how to implement it right now.If some one could help it would be highly appreciated.

2 Likes