I am using the inventory sample app and setting up a workflow email with an excel attachment, so every time a new entry or multiple entries are made in Sales, then synced, I get an email with a list of just the newly written Sales rows in a sheet. Currently, the workflow just emails a list of everything in the Sales table.
The way to differentiate between entries can be the column “Description”, where the multiple item sales will have the same Description and get recorded accordingly.
I am not sure but I think setting up a condition on the workflow can help with that, but I need some help with writing the condition. Here’s what I had in my mind:
If description = “VALUE”, list out all the Sales data with the description "VALUE ". But the description VALUE is always changing and not definite, I can maybe sort by timestamp instead. Not too sure.
Please advise, all guidance is truly appreciated.