Thanks for the post!
For this, I might take a look at our database trigger workflows. You can trigger a workflow to run based on something changing about a particular record. From there, if you wanted the email to only have the values changed and not send the value if it wasn’t changed, you’ll want to look at our :formatted as text operator which allows you to change what text is printed based on the answer to a boolean statement.
As an example, lets say you want the email to include email only if email was changed: In the database change workflow, you can reference both the thing before and the thing now. In your email, you might write thing before’s email doesn’t contain thing now’s email:formatted as text. Bubble will then let you write a value for if the answer is yes OR if the answer is no. If yes, you might write “Email: Thing now’s email” and if no, you simply wouldn’t enter anything.
The effect of having one of these statements for each field you MIGHT want to report on is that when the email goes out, it’ll only summarize the changed fields and will ignore any that didn’t change.
Give it a try and feel free to reach out to our team directly with any additional questions → [email protected]