Hey,
I think this can be done pretty quickly with an automation. Something like this:
Triggers when the Bank statement field is updated, then if it contains ‘deposit’ enters ‘income’ in the single select, and if it contains ‘payment’ enters ‘outcome...
Hey Sam,
Adding quotes is possible in a formula field, for your field, something like the below could be added.
IF({Short Name},"\" ","")
When adding quotes you need to add a ‘’ before so that the formula knows to treat the quote as a string.
So you...
If a maximum number of products you could link exists, you could create individual link fields, like this.
You could hide some of the fields to clean up the view. Although, if there are lots of products to link, this becomes very clunky very quickly...
Hey Melissa,
I was able to create a formula that will allow you to do this. I recreated your screenshot, see below.
Here is the formula in ‘Total’:
((IF(FIND(",",Quantity)!=0,LEFT(Quantity,(FIND(",",Quantity)-1)),Quantity)+0)*(LEFT(ARRAYJOIN({Price ...
Hey, a quick way to do this would be to create a formula field and use that formula field in your email automation.
The DATETIME_FORMAT function will let you format your date to a ‘friendlier’ version. See the example below
DATETIME_FORMAT({Date},'dd...
