///// Email notification via Workflow ///// ...

(Etwo Cargo) #1

///// Email notification via Workflow /////

Table has name column, surname column, triple code of user and email address column. Filling the all column (excluding email) There is formula in email column as

=IF([triple code]<>0;[triple code]&“triple code@mail.COM”;"") System is getting triple code from related column and writing the mail address as adc@email.com in the email column. There is also a formula inside of workflow rule (rule is send the mail to address which is inside of the related section. Means abc@email.com) as send the mail the user (to abc@email.com) after press the save button. But system is sending the mail to all users which mails are in mentioned column added before. Is it a way to learn where i am doing wrong set up?

(Dinh Nguyen Nguyen) #2

@Etwo_Cargo Hi, I’m afraid I don’t fully understand the problem or how your workflow rule is set up based on your description. Could you give me the names of the relevant app, table, and workflow so that I can take a look?

(Etwo Cargo) #3

@Harry

Dear Dinh App: TGDShipmentstatus-51719-775960 Table is : Delivered.

(Etwo Cargo) #4

+Steve Coile +Steve Coile Sorry for that but what was your suggestion?

(Steven Coile) #5

Did you get a solution?

(Etwo Cargo) #6

Not yet :wink:

(Steven Coile) #7

What is “triple code”?

(Dinh Nguyen Nguyen) #8

@Etwo_Cargo I’m afraid that I still cannot understand the problem. The only workflow in the app that uses data from table “Delivered” is"DLV". However, I could not find any expression in this workflow that resembled the expressions that you provided. Also, I was unable to find any column named “triple code” in the table.

Could you double-check the name of the app? Also, if the solution that you have in mind is fairly complicated and requires significant customization, I suggest that you contact one of our solution partners, who will be able to spend more time to work out a solution that would best meet your needs.

(Etwo Cargo) #9

+Steve Coile Dear Steve, Let say triple code is ABC. And it is adding by user manually. The email address which i want to send is standard like ABC@DDD.COM EFG@DDD.COM KLM@DDD.COM ERT@DDD.COM The triple code is on column D and column name is code for example.

So i tried to use the formula like;

=[code]&"@DDD.COM"

The target was to have mail address automatically

for each row as

ABC@DDD.COM EFG@DDD.COM . . .

(Steven Coile) #10

@Etwo_Cargo Thank you for clarification about “triple code”.

I have a concern about the formula you referenced:

IF([triple code]<>0;[triple code]&“triple code@mail.COM”;"")

Specifically, [triple code]<>0. From your explanation, triple code is a textual value, not a numeric value, but your expression compares [triple code] to 0, a numeric value. I would guess your intent is to check whether [triple code] has a value. If so, try using ISNOTBLANK([triple code]) instead of [triple code]<>0.

(Etwo Cargo) #11

+Steve Coile Dear Steve, I got an error after use ISNOTBLANK([code];[code]&“code@email.COM”;"")

Function ‘ISNOTBLANK’ should have exactly two parameters, a table name and a filter condition

Actually the was;

I have created workflow to notify some once via mail (via workflow) but after we create an email via that formula in column name mail system is sending details of records to all addresses which are in email column.

means. row

code

name

surname

email 1

ABC

Mick

Lal

abc@email.com 2

DEF

Tom

Red

def@email.com 3

KLM

Hans

Blue

klm@email.com 4

GHJ

Tom

White

ert@email.com

So, when i create Tom White on 4.row system is sending email to all addresses. to ABC, DEF and KLM.

But mail must be sent to ert@email.com only.

Formula in the workflow is SELECT(sheet name[email],TRUE) The formula in workflow is wrong maybe. What could be my wrong?

(Steven Coile) #12

ISNOTBLANK([code];[code]&“code@email.COM”;"") is not what I suggested.