This is what my test dictionary looks like.
A is the test where I enter data
B is the test where I enter nothing (just hit Test)
Posted By Erin Nelson on 24 Oct 2014 10:18 AM
Thank you! I think I figured it out. The DATE field also needs to be populated. I think I actually figured out how to fix that. The only problem is that after my experimentation, when I run an import, now the duplicate search is compressing the name columns and even though I expand them on a record, when I move to the next record, the columns are narrow again, making the names unreadable. Bizarre. If you have a simple solution to that, I'm all ears:-)
Thanks so much for the help! It's great to have fixed the Bio issue!
Erin, I was wondering if you could share how you fixed the DATE Field. I'm trying to do the same thing and I haven't been able to figure out how to get the date to populate when I have a note to add but not populate when there isn't anything to add.
Thanks for your help,
Matt
Matt, have you tried to add a virtual field for the date and a RegEx for not blank to convert to a date? That's what I would do.
Posted By Teddi Taylor on 10 Dec 2014 10:22 AM
Matt, have you tried to add a virtual field for the date and a RegEx for not blank to convert to a date? That's what I would do.
Erin Nelson
I have a file with Column X that sometimes will be populated with data that I want to put into a Note on an individual record.
The note requires a note type.
I would like the import to automatically populate that note type with "Bio" and then add the note with the data in Column X.
What I have is:
a dictionary matching on ^.+$ to add "Bio" and a virtual field using Column X as a seed and applying the dictionary
It's not working.
I am utterly new to this, so any help would be much appreciated!