David
a couple of points on this one, firstly have you tried using a notepad file to run with your triggers, I used to use excel all the time and had a lot of issues and also limitations on the fact that you could only add three columns (if memory serves) for your own parameters. If you use a notepad you can have many. I use 15 columns at present.
I use excel to build the file and then just paste it into notepad, and import that for my selections.
If you use excel, I know you had to look at how it imported the data into the sheet then specify the columns past that so that the data you want is not overwritten by the data MF is storing itself.
I paste below an example sheet to show how I present the data in excel, I then just paste the rows into notepad and import that, but I have left them in so you can see how to define and call the various values I need.
I use an x so that the software knows there is nothing in that column but can still find data in imp_15 etc, then in the trigger I just reference if imp_x and whatever conditions you apply to that.
Hope this helps
Recent Posts