Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
languagesql
titleMySQL
linenumberstrue
collapsetrue
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
languagetext
^([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)+$

...