Just spent 20 minutes replying to your question only to have it not post (I probably got logged off)
So here is the shorter but hopefully still helpful version.
I have a LIST "Activity Owner Geography Combined" which as you guessed it is the combination of a User Name and a Geography (Mark Manno - New York, Mark Manno - Florida, Greg Crawford - California, ...)
I have a MODULE "Activity Owner Geography Management" which has two dimensions User Name and Geography as well as three Line Items "Create?", "Already Created?", "Activity Owner Geography Text"
- "Create?" = User Populated Boolean Flag if they want that combination of User & Geography
- "Already Created?" = A Boolean Flag to indicate if the Combination of User & Georaphy already exists in the "Activity Owner Geography Combined" LIST
- "Activity Owner Geography Text" = The Text that will be Imported into the "Activity Owner Geography Combined" LIST
I have a Saved View based off of the "Activity Owner Geography Management" MODULE which is filterd on:
- "Create?" = TRUE
- and "Already Created?" = FALSE
- and ISNOTBLANK("Activity Owner Geography Text")
I have an Import Action into the "Activity Owner Geography Combined" LIST which adds the "Activity Owner Geography Text" from the "Activity Owner Geography Management" MODULE
The Action works perfectly when there are records to be added ("Create?" = TRUE and "Already Created?" = FALSE and ISNOTBLANK("Activity Owner Geography Text"))
However, when I run the Action and there are 0 records no new items are being created, I still get 1 new record and that record just so happens to the be Line Item Header of the field I am Importing from which in this case would be "Activity Owner Geography Text".
So when ever I run this process and no new combinations are being created the system will add 1 new record "Activity Owner Geography Text" w