A quick copy and paste reference guide
Table of contents
Table of Contents
Introduction
This section aims to be a quick copy+paste reference for faster development. If you are adding content to it, please keep in mind the following:
...
Get percentage of completed questions in an Excel RFP
=COUNTA(Range)/<number_of_questions>
Get OAuth2 access token that can be used on the REST API in a dynaform via javascript
...
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
LOAD DATA LOCAL INFILE '/home/Ethan.Presberg/wpg_csvcopy.csv' INTO TABLE PMT_GMINY CHARACTER SET UTF8 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; |
Regex for not allow personal email
| Code Block | ||
|---|---|---|
| ||
^([a-zA-Z0-9_.+-])+\@(163\.com|aol\.com|bellsouth\.net|blueyonder\.co\.??|btconnect\.com|charter\.com|comcast\.net|cox\.net|earthlink\.net|email\.com|gmail\.co|gmail\.com|hotmail\.co\.??|hotmail\.com|juno\.com|mail\.com|mail\.ru|mindspring\.com|msn\.com|ntlworld\.com|orange\.fr|rogers\.com|sbcglobal\.net|shaw\.ca|sympatico\.ca|telus\.net|verizon\.net|virgin\.net|virginmedia\.com|yahoo\.ca|yahoo\.co\.??|yahoo\.com|ymail\.com|icloud\.com|me\.com|mac\.com)+$ |
...