By Ryan Aunur Rassyid
Simply create RESTful API with Google Script and store it to Google SpreadSheet like a Pro.
function MXLookup(domain) { | |
try { | |
var url = "https://dns.google.com/resolve?name=%FQDN%&type=MX".replace("%FQDN%",domain); | |
//var url = "https://dns.google.com/resolve?name=e-mercy.com&type=MX"; // USED FOR TESTING ONLY | |
Utilities.sleep(100); | |
var result = UrlFetchApp.fetch(url,{muteHttpExceptions:true}); | |
var rc = result.getResponseCode(); |
import React, { Component } from 'react' | |
import { Redirect } from 'react-router' | |
export default class ContactForm extends Component { | |
constructor () { | |
super(); | |
this.state = { | |
fireRedirect: false | |
} | |
} |
<?php | |
/** | |
* Gravity Wiz // Gravity Forms // Rename Uploaded Files | |
* | |
* Rename uploaded files for Gravity Forms. You can create a static naming template or using merge tags to base names on user input. | |
* | |
* Features: | |
* + supports single and multi-file upload fields | |
* + flexible naming template with support for static and dynamic values via GF merge tags | |
* |
<?php /** @noinspection SpellCheckingInspection */ | |
/** | |
* This file contains the WordPress code for rendering a Google Reviews badge. | |
* | |
* Usage: | |
* | |
* 1. Create a Google API Console account if you have not already done so. | |
* 2. Register for the Google Places API. | |
* 3. Create an API key. | |
* 4. Ensure that the API key can be used from wherever this script will execute |
class Email_Scraper { | |
constructor(log = false, names = true, scriptURL = '', spreadsheetURL = '') { | |
this.currIndex = 0; | |
this.log = log; | |
this.names = names; | |
this.pendingRecursive = 1; | |
this.scriptURL = scriptURL; | |
this.spreadsheetURL = spreadsheetURL; | |
this.sourceIndex = 0; | |
this.sources = {}; |
const fs = require('fs') | |
const csv = require('csv'); | |
fs.createReadStream('data.csv') | |
.pipe(csv.parse({columns: true})) | |
.pipe(csv.transform((input) => { | |
return Object.assign({}, input, { | |
foo: input['foo'].toUpperCase() | |
}); | |
})) |
<?php | |
/** | |
* | |
* Function that will automatically remove ACF field groups via JSON file update | |
* | |
*/ | |
function acf_auto_suppr($json_dirs) { | |
$groups = acf_get_field_groups(); | |
if (empty($groups)) { |
name: Custom Function SUM() | |
description: Implement the SUM() function in JavaScript. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
/** | |
* The sum of all of the numbers. | |
* @customfunction | |
* @param number1 A number (such as 1 or 3.1415), a cell address (such as A1 or $E$11), or a range of cell addresses (such as B3:F12). |
/** | |
* Steps to use: | |
* 1. Create CF Worker, copy and paste this in | |
* 2. (Optional) Update configuration defaults | |
* - If you want to manage in code, do so below under "Static Configuration" | |
* - If you want dynamic custom config: Create CFW KV namespace, link them, and add reference below | |
* | |
* - You can overwrite default path prefix for loading analytics.js (<yourdomain>/ajs) | |
* (corresponding KV entry: `script_path_prefix`) | |
* - You can overwrite default path prefix for handling first-party data collection (<yourdomain>/data) |