254 shaares
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
)
)
)
Formula for field named [Mobile]:
=AND(IF(ISERROR(FIND("(", [Mobile],1)), FALSE, (FIND("(", [Mobile]) = 1)), IF(ISERROR(FIND(")", [Mobile],5)), FALSE, (FIND(")", [Mobile], 5) = 5)), IF(ISERROR(FIND(" ", [Mobile],6)), FALSE, (FIND(" ", [Mobile], 6) = 6)), IF(ISERROR(FIND("-", [Mobile],10)), FALSE, (FIND("-", [Mobile], 10) = 10)),IF(ISERROR(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4))), FALSE, AND(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4)) > 1000000000, 1*MID([Mobile], 2, 3) <> 911, 1*MID([Mobile], 7, 3) <> 911)))
Also see, https://thechriskent.com/2012/08/15/validate-phone-number-columns-in-sharepoint/
=AND(IF(ISERROR(FIND("(", [Mobile],1)), FALSE, (FIND("(", [Mobile]) = 1)), IF(ISERROR(FIND(")", [Mobile],5)), FALSE, (FIND(")", [Mobile], 5) = 5)), IF(ISERROR(FIND(" ", [Mobile],6)), FALSE, (FIND(" ", [Mobile], 6) = 6)), IF(ISERROR(FIND("-", [Mobile],10)), FALSE, (FIND("-", [Mobile], 10) = 10)),IF(ISERROR(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4))), FALSE, AND(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4)) > 1000000000, 1*MID([Mobile], 2, 3) <> 911, 1*MID([Mobile], 7, 3) <> 911)))
Also see, https://thechriskent.com/2012/08/15/validate-phone-number-columns-in-sharepoint/
Formula for field named [Mobile]:
=AND(IF(ISERROR(FIND("(", [Mobile],1)), FALSE, (FIND("(", [Mobile]) = 1)), IF(ISERROR(FIND(")", [Mobile],5)), FALSE, (FIND(")", [Mobile], 5) = 5)), IF(ISERROR(FIND(" ", [Mobile],6)), FALSE, (FIND(" ", [Mobile], 6) = 6)), IF(ISERROR(FIND("-", [Mobile],10)), FALSE, (FIND("-", [Mobile], 10) = 10)),IF(ISERROR(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4))), FALSE, AND(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4)) > 1000000000, 1*MID([Mobile], 2, 3) <> 911, 1*MID([Mobile], 7, 3) <> 911)))
Also see, https://thechriskent.com/2012/08/15/validate-phone-number-columns-in-sharepoint/
=AND(IF(ISERROR(FIND("(", [Mobile],1)), FALSE, (FIND("(", [Mobile]) = 1)), IF(ISERROR(FIND(")", [Mobile],5)), FALSE, (FIND(")", [Mobile], 5) = 5)), IF(ISERROR(FIND(" ", [Mobile],6)), FALSE, (FIND(" ", [Mobile], 6) = 6)), IF(ISERROR(FIND("-", [Mobile],10)), FALSE, (FIND("-", [Mobile], 10) = 10)),IF(ISERROR(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4))), FALSE, AND(1*CONCATENATE(MID([Mobile], 2, 3), MID([Mobile], 7, 3), MID([Mobile], 11, 4)) > 1000000000, 1*MID([Mobile], 2, 3) <> 911, 1*MID([Mobile], 7, 3) <> 911)))
Also see, https://thechriskent.com/2012/08/15/validate-phone-number-columns-in-sharepoint/
Mouse Jiggler is a very simple piece of software whose sole function is to "fake" mouse input to Windows, and jiggle the mouse pointer back and forth to stop the machine from going to sleep during presentations.
In this example mail merge is being used to format a merge field in red if the value is greater than 20, and if not; format the merge field in black.
Connect to SharePoint list
Screen scraping tutorial using NightmareJS
