Import from Excel problem
I have a log that I import from Excel daily and recently I decided to add a check box in FM "Updated", that I check after I have logged my changes etc. My problem occurs when I import the next days log. my script is set to update update existing records, Add remaining, and don't import First field. What happens is my check boxes all move up by the number of new records added and I have played with all the settings doesn't seem to make a difference? Not sure why this would be happening do I need to script something in? The excel document of course does not have a check box field.
Thanks for your guidance.