Hello @jamesgough,
Happy to hear that you have found a solution that gives you a starting point. In case, you would like to get data (including from connected columns) right into your invoice or quotes, you can check out the Paysaro app which allows you to do just that.
If you have any question, you can reach out at support@kolaai.com