We create a automation rule with action send e-mail. We add a column with formula Content, but in the mail, no content displayed. In the Seatable direct was the value added, but not in the mail.
Is there a limitation, that content from formulas are not shown in the mails?
Bye Thomas
Formula columns can be added to emails. No problem.
Apart from that, I am having a hard time making sense of your description.
It was a ifs Formula: That means we must first create Lookup-Columns inside these Table for both Fields and work then with that values?
ifs({S-ArtUW}=“oS”,({Art-ID.Preis oS}{TN}),{S-ArtUW}=“oWeb”,({Art-ID.Preis oWeb}{TN}),{S-ArtUW}=“ind”,“0”)
This formula is invalid. Not sure what you want to say/demonstrate.
Let me try differently: Do not use the dot notation in the fomula (e.g. {Art-ID.Preis oS}). How? Add two link formula columns to your table and lookup the two values Art-ID.Preis oS and Art-ID.Preis oWeb. Then use the newly added link formula columns in your formula.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
