0
Use a formula to create a new field from existing fields
So obvious I can't work it out even after I RTFM.
I have a number of fields containing info which I want to join into another new field from where I can copy and paste to an email.
I want the fields 'Appointment', 'Job', 'Time, 'Fee', 'Miles', Miles Fee', Invoice Total'
to end up in a new field which will look something like
29 Jun 23 - Some work for you
1 hour £99, 20 miles £10.00 = £109.00 + VAT
As soon as I start building a formula it goes red and three's a problem. If I try the visual formula I can't delete when it's wrong. I haven't found any helpful help. Where can I find the basic formula help, the syntax I need?
Or is formula wrong, there's another way to do this?
Thanks!
1 reply
-
text(field) + "is my new friend"
Content aside
- Status Answered
- 1 yr agoLast active
- 1Replies
- 51Views
-
2
Following