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?
@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 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.
+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.COMEFG@DDD.COMKLM@DDD.COMERT@DDD.COM The triple code is on column D and column name is code for example.
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.
+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.
