254 shaares
6 results
tagged
stack
Q: How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
A: The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. Let me break it down for you. :)
**** Good example
A: The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. Let me break it down for you. :)
**** Good example
Formula for format 999-999-9999:
=AND(
LEN([num])=12,
IF(ISERROR(FIND("-", [num],4)),
FALSE,
(FIND("-", [num], 4) = 4)
),
IF(ISERROR(FIND("-", [num],8)),
FALSE,
(FIND("-", [num], 8) = 8)
),
IF(ISERROR(1*CONCATENATE(MID([num], 1, 3), MID([num], 5, 3), MID([num], 9, 4))),
FALSE,
AND(
1*CONCATENATE(MID([num], 1, 3), MID([num], 5, 3), MID([num], 9, 4)) > 1000000000,
1*MID([num], 1, 3) <> 911,
1*MID([num], 5, 3) <> 911
)
)
)
=AND(
LEN([num])=12,
IF(ISERROR(FIND("-", [num],4)),
FALSE,
(FIND("-", [num], 4) = 4)
),
IF(ISERROR(FIND("-", [num],8)),
FALSE,
(FIND("-", [num], 8) = 8)
),
IF(ISERROR(1*CONCATENATE(MID([num], 1, 3), MID([num], 5, 3), MID([num], 9, 4))),
FALSE,
AND(
1*CONCATENATE(MID([num], 1, 3), MID([num], 5, 3), MID([num], 9, 4)) > 1000000000,
1*MID([num], 1, 3) <> 911,
1*MID([num], 5, 3) <> 911
)
)
)
How to add a user and assign to a role in DNN
Adding a default blank option for a SQL populated dropdown list.