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?
@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.
@LETICIAHELENA it looks like @Yoshiro_Fujimori is helping!
@LETICIAHELENA the Formula would look something like IF [data conclusão] = null() THEN [data prevista] ELSEIF [data prevista] = null() THEN [data conclusão] ELSE null() ENDIF
@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.
@gautiergodard Do you how can I exclude 2 text email and just keep the first one?
@alexnajm Also Do you know about this question above?
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:
@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.
@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
@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.
@LETICIAHELENA yes it's possible with a multi row formula tool - however, you would need to make sure to think through the logic to fill in those values. For example, should the null value in "data prevista" be 2023-04-04 or 2023-04-05?
it' necessary be the same date just the copy of the other column, if null is in the columns data prevista than need copy from data conclusão and vice versa. How can I wrote the formula in teh tool?
