Hello! Is there a way to use the "When a form is submitted" automation trigger but send different emails based on different responses to the form? We have a single select option and we are looking to send different emails based on which option was ch...
Looking to see if we can find out the history of how many times a single select option has been chosen by any of our team members in the past. I have something set up that I started in October to help with this but wondering if there is any way to se...
That should do the trick! I was for some reason trying to do the conditional part in the trigger and not in the action. The solution was right there in front of me all along! Thanks!
Sure thing, I'm happy to help!Looks like for this second one you are looking for a nested If statement (How to Write Nested IF Statements | Airtable Support). I think you might just be able to take the formula you showed in the screenshot, remove the...
Hello! I believe you could use the following IF formula: IF({Take Rate %}, {GMV} * {Take Rate %}, {GMV} - {Achat Distribteur}) Note that for the GMV part of the above formula you will have to put the full field name, not just GMV.
