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

null
    • Davie
    • 10 mths ago
    • Reported - view

    text(field) + "is my new friend"

Content aside

  • Status Answered
  • 10 mths agoLast active
  • 1Replies
  • 49Views
  • 2 Following