This content has been marked as final. Show 4 replies
The best way to figure this out is to export a CSV of a few leads from your lead database, and then use this as a model for the data value of these fields.
Thanks Murtza, I was thinking about that but the export functionality does not allow selective export, and the database has about 45k or records, couple that with more than 100 fields, I can imagine that it will take a long time.
Will give it a try .. Thanks!
Based on the exported data, it looks like:
1) "1" should be for true, empty for false
2) Date should be something like "2014-08-04 04:25:03"
3) Still not sure about this. "NULL" or "null" or empty field value?
NULL works to empty fields. Just try it on a string field (text box). I do it all the time for my multiple city field for roadshows, I need to clear that field each year as we might not run the roadshow in the same cities following year.