Hi, what do you need to script for this problem?
I think you should have a look at this
I think if you layout your InDesign file correctly it shouldn't be too difficult to do the merge. I am assuming from the lower graphic in your post that that is the layout you want to employ.
I recommend you view the video in the link above and see how "easy" it is to do, even the placing of your map graphic can be done through your spreadsheet once you have a link for the image.
When you ask the same question in two different forums, it's a bit weird.
This started out at How to build conditional text from a data merge.
I thought you got a lot of useful advice there and were well on the way to a solution -- what went wrong? What's the problem?
Thanks for your reply.
I think you may be misunderstanding my query.
I have already laid out the template and yes that image is what my layout is based on.
My problem is not how do I layout a template in Indesign and how do I merge the data, its more like "how do I clarify the data in the spreadsheet column to separate them into using conditions in Indesign". That's the best I can describe my problem.
I explained my conundrum in my first message in this thread.
Thanks for the link. I'll check it out.
Yes, thank you for pointing that out to me. I know where I started this question.
I actually don't find it weird placing my question in another forum. The reason I did this is because I found that perhaps my query is more relevant to the "scripting" forum since that is what I think my problem may be.
Yes, I did get a lot of very useful advice in the other thread and have retained that, however, as I mentioned to Peter in the other thread, I needed to get my logic right and a clearer picture of what I think I am trying to do. I need to explore all avenues, and I have been down that line and I am still exploring and trying to find an answer. Is that OK?