I'll describe this the best I can.
I have managed to make a data merge in InDesign for some point of sale tickets (we currently use publisher and would love to move to the 21st century but just haven't been able to work out how, plus we are extremely limited with the layout & design we can use with publisher)
As it stands when we enter in our product description via mail marge in publisher the product description automatically adjusts to fit the qty of words in the product description weather that is 4 words or 6 or even more the text adjusts to fit the space. (same with the Sale price) As you can see with the below examples. 2 word product description 4 word product description 7 word product description 9 word/character description
The question is how do I get this automatic size adjust to work in indesign? without having to resize every product description & sale price. As you can understand doing that for 300 - 500 tickets is just not a viable use of time.
I did come across the below website but this only explains how to get a single word with varying character numbers to adjust. not multi worded https://colecandoo.com/2012/02/18/square-pegs-now-fit-into-round-holes/
Any insight into if this is even possible or pointing me in the right direction would be awesome. Or even reducing the amount of manual adjustment per ticket & without having to have multiple documents per product description size.