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) |