I am looking to use a text file to generate a list on the start of a layout. I had a search on the forums but couldn't find anything. I am currently using a list object and manually adding all the lines. The text files are just lists like:
"One Two Three Four"
I can have the text file in any format but as above is the easiest to take it from the excel data. The lists will be around 20-30 eventually and the thinking is to make it easily changeable.
Thanks for the links and tips. Managed to get it all working great. I didn't realise until the example that you can use Newline which was handy as my lists are exported from excel!
My next challenge is updating the total price. It takes a quantity and multiplies by a rate. Trouble is I am using the condition if Rate / Quantity boxes are changed to trigger the total text update. It seems it works 90% of the time but sometimes it lags and doesn't update. Inserting a wait 0.1s at the top before calculating seems to make it reliable but ideally I do not want this =(