Action > Behavior > Condition > for confirmation Pop up

AppSheet AppSheet Q&A
1

Hi All,

I am trying to show the confirmation Pop up in the Behavior > Action > Behavior Section.

Current screenshot : Its good!! i am getting the popup with the message.

3X_7_1_71fef28e14c64c4a0d4d4867170f9203947d5158.jpeg
3X_7_1_71fef28e14c64c4a0d4d4867170f9203947d5158.jpeg940Ă—320 31 KB

But i need a formula to show this pop up only if user dont have any data in that View ( i have Multiple views )

Guide me Please. Thanks

1 Like
2

AUXWORK:

if user dont have any data in that View

Are you using a slice for this “view”?

2 Likes
3

Yes June,

i am using slice view

4

You can use an expression in Only if this condition is true property

1 Like
5

Levent Could you help me with the expression…

6

@AUXWORK
I have no idea how you slice or filter your data as per user, but something like this might help. Please edit the expression as necessary and as it fits to your schema:

AND(
    CONTEXT("View") = "Your_View_Name_Here",
    COUNT(SELECT(TableName[Key], USEREMAIL() = [Email])) > 0
)
2 Likes
7

@AUXWORK

3X_a_7_a79947399fe2e5ab13bc1165e604f7006dc9187d.png
3X_a_7_a79947399fe2e5ab13bc1165e604f7006dc9187d.png1195Ă—123 34.2 KB

The word Datum is the singular form but instead of pluralizing the word as Datums, it’s pluralized as Data, thus Datas is grammatically incorrect. Same applies to the word Criteria: Criterion (sl) / Criteria (pl). Just a sweet reminder…

2 Likes
8

Yup thanks… that just a Dummy Content…

Levent…
you are almost close, CONTEXT and SELECT expression is good… but i am not sure about the COUNT included in this expression…

My be i am not saying it properly… check if this image helps.

3X_3_4_349a35a142ddbda2a9edca153596d43eeb74a35a.jpeg
3X_3_4_349a35a142ddbda2a9edca153596d43eeb74a35a.jpeg1085Ă—547 69.6 KB

9

@AUXWORK
You don’t have the chance to suppress the confirmation message as per conditional rule unfortunately. The most suitable approach will be having 2 identical actions: one with a confirmation message taking the user to another view to enter data, and one without a confitmation message taking the user to selected view. I presume your main table is a Gallery View, am I right? So you need to set a proper expression for the Gallery View’s row selected property.

Assuming that you can create the COUNT() expression easily for the Related Data part (as I have no any information about your tables, references, table schema etc.), your expression might be like this:

IF(
    COUNT(SELECT(......)) > 0,
    LINKTOFILTEREDVIEW("View2", {Your_Filter_Condition_Here}), //This action is wo/Confirmation Msg
    LINKTOFORM("Form_UX_Name_To_Which_User_Is_Expected_To_Record_Data","KeyColumnName",UNIQUEDID()) //This action is w/Confirmation Msg
)

Hope it helps now.

3 Likes