Expressions within confirmation message

[Chris_Jeal]

Hi,

I think that it would be great if we could include [column] value(s) within an action’s confirmation message.

For example:

If an action is changing/adding the value of a cell then perhaps the message could ask whether or not the value is correct or not before confirming.

““Set new location to”, [New_Location_Ref]?”

Best,
Chris

[Marc_Dillon]

Just tried to do this, was very surprised that it is not possible.

[Jon_S]

A massive +1 on this.

Surprised this hasn’t been implemented after a few years of bouncing around the idea. I remember someone from the Appsheet Team mentioning that it’s a fairly complicated thing to actually achieve.

We can limit / control every little thing about an ‘action’ … but not this

[hcquadros]

I miss it specially on “send e-mail” actions. On the confirmation message I can describe the rule I set (i.e. “this will notify everybody in the your own department” or “the e-mail will be sent to the person who added this row”), but I cannot put a clear confirmation message like “This action will notify person A and B. Do you confirm?”.

The quality department in my company is really bugging about notifications sent to the wrong people…

[hcquadros]

Any news on this? That would be really useful.

[Erwan]

Any news on this? That would be really useful.

[Oliver]

Agree this would be a great feature too!

[Steve]

You can actually use an expression in an action’s confirmation message, even though the app editor doesn’t indicate it and Expression Assistant isn’t provided. Try it!

[Fabian_Weller]

Yes you can do something like:

CONCATENATE(TODAY()," Hello World")

But you can’t include columns!
This will give an Error “Unable to find column ‘Customer’”

CONCATENATE(TODAY()," Hello ",[Customer])

[Mike_T]

Here is a challenge for you…if I want to change the Heading text of “Confirm” in the confirmation text box based on whether the user swipes left or right in a deck view, is this possible?

I’m trying to apply two actions to the Deck View row. Swipe left and you “CANCEL” Action. Swipe right and you “CONFIRM” action. You can see the obvious miscommunication here if someone saw “Confirm” on the confirmation message when they were trying to cancel.

How do I customize the confirmation message based on the action taken? by the way, I wouldn’t be using the swipe actions if action buttons were available in Deck View.

[Marc_Dillon]

You’re talking about this, correct?

You can change that text in UX->Localize.

There is no expression that’ll determine the context of which Action is being run.

You could combine your actions with some data change action, into a Grouped Action, and have the expression in Localize output a different text based on this data being changed. Kind of a lot of work for such a small thing, and I’m not 100% it will work.

Mike_T:

by the way, I wouldn’t be using the swipe actions if action buttons were available in Deck View.

Action button are available in Deck view.

[Mike_T]

Thank you! I found the Localized field and changed the Confirm header. This will work for now and agree that it’s not worth developing a complicated work around.

I wasn’t able to add my Actions using the settings you shared here. Maybe I have another setting flipped somewhere? I am able to add the Email action when an email address is present in the row. But none of the others show up.

I’m ok for now using the swipe left/swipe right functionality but if the client doesn’t like it, I’ll need to revisit.

Thanks again!

[Fabian_Weller]

Hi @Mike_T under UX > Localize you can put this expression for “Confirm”:

SWITCH(CONTEXT(View) ,
  Your_Deck_View_Name , " " ,
  Confirm
)

So when you’re in the Deck view, the word “Confirm” will not appear

When you are in another View, the word “Confirm” will appear.

Instead of double quotes you can put Emojis like

---

You said you cannot add the Actions in your deck view.
Please check the Prominence under Behavior > Actions.

[Fabian_Weller]

Fabian:

Yes you can do something like:

CONCATENATE(TODAY()," Hello World")

But you can’t include columns!
This will give an Error “Unable to find column ‘Customer’”

CONCATENATE(TODAY()," Hello ",[Customer])

Hi @praveen As mentioned above, you can not include columns. But that would be very helpful.

[pravse]

For now, the topics discussed here seem mostly addressed.

*) We need to make it more obvious that an action confirmation message can take an expression
*) I agree that it would be nice for not just the confirmation message but the rest of the dialog box to be customizable per action (the header, the Ok and the Cancel button). However, we’re balancing this off versus how many different customization expressions to carry around in the app definition.

So for now, my judgment is that we can leave this mostly as is and most of you will be happy. Please do correct me if I’m wrong though.

[pravse · Accepted solution]

Done.

As of today, action confirmation messages show an expression editor option, and the expression can use column values (except for the couple of actions like Add and Export To Csv that have “table-scope” rather than “row-scope”)

[Koichi_Tsuji]

Awesome!!!

[Chris_Jeal]

Using it already!

Good stuff!

[APiCC_Conor]

Very cool!

[Fabian_Weller]

Hi @pravse This is not working when you use "Execute an action on a set of rows".

The confirmation message in the set of rows will not show column values and will pop up only once.

Please see my test app:

https://www.appsheet.com/Template/AppDef?appName=Action-549987

In the GIF you see that I have one action "Directly" that counts up. The confirmation message is working fine.

I have another action "All rows" that executes the "Directly" action on all rows.

The Action is working, but the confirmation message not.

I also sent it to https://www.appsheet.com/Support/Contact

[HighLiuk]

Same problem here.
I'd like to show a simple message like "Are you sure you want to delete <x> records?" but that seems impossible.
Also, seems it is impossible to have "Are you sure you want to delete <A.name> and <B.name>?" if you select A and B

[Fabian_Weller]

Hi @HighLiuk I was in contact with AppSheet Support. This was the last response on Thu, Sep 1, 2022:

For "Directly" action, the Counter is able to fetch the current value of a particular row and shows the expected confirmation message.

For "All Rows" action the confirmation message is not showing the exact count, because this action is a reference action of "Directly". Which is trying to determine the Counter value from all the rows which is not possible.

It is better to have a separate action for "All Rows" with a common confirmation message which will be applicable for all rows.