Email - Spreedsheet

[LETICIAHELENA]

Hello,

I need send an email separate just by the priority, but the text that I wrote repeat beetween the sprredsheet, How Can I exclude 1 text just to keep the first email text?

[gautiergodard]

@LETICIAHELENA if i understand the issue correctly, i think you'll want to use the "group by" options in the table tool to group your line items by priority. 

something similar to the attached.

[LETICIAHELENA]

@gautiergodard Do you how can I exclude 2 text email and just keep the first one?

[LETICIAHELENA]

@alexnajm Also Do you know about this question above?

[Yoshiro_Fujimori]

@LETICIAHELENA ,

If you wan to keep only the first one, there are multiple ways depending on your conditions.

1. Sample Tool: 

2. Filter Tool:

[priority] = "high"

3. Select Record Tool:

[LETICIAHELENA]

@Yoshiro_Fujimori  I want send all the priority in the same email but the text email just appear once

as example below:

Hello dear

below is the list about priority.

firt list

second list

Third list

Today what is happening is repeating the text in the same email.

Hello dear

below is the list about priority.

firt list

Hello dear

below is the list about priority.

second list

Hello dear

below is the list about priority.

Third list

[LETICIAHELENA]

@Yoshiro_Fujimori  As the image below I have 2 priority ans the text email repeat but I just want one text with the 2 priority below

[Yoshiro_Fujimori · Accepted solution]

@LETICIAHELENA ,

I guess it is due to the configuration in Table Tool.

What is happening

You set "Group by" in the Configuration of Table Tool.

The table table is split to 3 records.

As a result, the report is split to 3 tables.

If you remove the "Group by" in Table Tool, the output would have one table:

I hope this would solve your issue.

Good luck.

[alexnajm · Accepted solution]

@LETICIAHELENA it looks like @Yoshiro_Fujimori is helping!

[LETICIAHELENA]

@alexnajm @Yoshiro_Fujimori  Guys do you know if is possible complete the "null field" looking the "data prevista" or " data Conclusão"? 

Example for the fisrt Null I want 2023-04-04 and in the second colum for the "null" copy the Data prevista date.