• Home
  • Systems
  • Networking
  • WordPress
  • Web
  • Geekery

Analysis and Review

Sample iMacros Script to Fill Drop Down List

November 30, 2015 by Kurt Turner

Here’s a sample iMacros script to fill a drop down list from an external source such as csv or excel. As you can see the website we’re form filling used wordpress PODS.

VERSION BUILD=8300326 RECORDER=FX
TAB T=1
SET !DATASOURCE ORGANZTN.csv
SET !LOOP 2
'Increase the current position in the file with each loop
SET !DATASOURCE_LINE {{!LOOP}}
SET !ERRORIGNORE YES
URL GOTO=http://10.247.89.152/foxy/wp-admin/admin.php?page=pods-manage-organization&action=add
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-organization-name CONTENT={{!COL6}}
TAG POS=1 TYPE=TEXTAREA FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-organization-id CONTENT={{!COL3}}
TAG POS=1 TYPE=SELECT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-type CONTENT=$*{{!COL9}}*
TAG POS=1 TYPE=SELECT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-county CONTENT=$*{{!COL5}}*
TAG POS=1 TYPE=SELECT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-status CONTENT=$*{{!COL10}}*
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-fire-department-phone CONTENT={{!COL14}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-1-name CONTENT={{!COL12}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-1-work-phone CONTENT={{!COL13}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-1-home-phone CONTENT={{!COL15}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-1-cell CONTENT={{!COL16}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-1-email CONTENT={{!COL17}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-2-name CONTENT={{!COL18}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-2-work-phone CONTENT=
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-2-home-phone CONTENT={{!COL19}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-2-cell CONTENT=
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-2-email CONTENT={{!COL20}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-3-name CONTENT={{!COL23}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-3-work-phone CONTENT=
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-3-home-phone CONTENT={{!COL22}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-3-cell CONTENT=
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-contact-3-email CONTENT={{!COL23}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-mailing-address-1 CONTENT={{!COL25}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-mailing-address-2 CONTENT={{!COL26}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-mailing-address-city CONTENT={{!COL27}}
TAG POS=1 TYPE=SELECT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-mailing-address-state CONTENT=$*{{!COL28}}*
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-mailing-zip CONTENT={{!COL29}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-billing-address-1 CONTENT={{!COL30}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-billing-address-2 CONTENT={{!COL31}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-billing-address-city CONTENT={{!COL32}}
TAG POS=1 TYPE=SELECT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-billing-address-state CONTENT=$*{{!COL33}}*
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-billing-zip CONTENT={{!COL34}}
TAG POS=1 TYPE=INPUT:CHECKBOX FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-private CONTENT=$*{{!COL38}}*
TAG POS=1 TYPE=INPUT:CHECKBOX FORM=NAME:NoFormName ATTR=ID:pods-form-ui-pods-field-po-required CONTENT=$*{{!COL39}}*
TAG POS=1 TYPE=INPUT:SUBMIT FORM=NAME:NoFormName ATTR=ID:publish
TAG POS=15 TYPE=A ATTR=TXT:AddNew

Filed Under: Web

Comments

  1. Carlos says

    December 19, 2015 at 5:24 pm

    Some features I’m lnokiog at out of the door:1. Another face for publicForm in which you create your Gravity Form and point it at a Pod, choose which fields go where, and when people fill out the form it will save data to a specific Pod via the PodAPI.2. Add drop-downs, radios, and checkboxes to your Gravity Form based on Pod data, keeping things dynamically populated and up-to-date with your Pod items as opposed to having to update a static list of items all the time. Think of how Pods lets you add Relationship fields, except in GF and pointed only at Pods.

Latest and Greatest

Apache vs Nginx for WordPress

Certbot Lets Encrypt And WordPress MU Multi-Site

How To Find and Replace Multiple File in MS Word

How To Get Stretch Res on Windows 10 AMD Radeon For Game Play

This is the ASUS Chromebox we've been running for 2 years as our "brain" for our home grown digital display kiosk.

DIY Digital Signage Bulletin Board or Kiosk

© Copyright Analysis And Review · All Rights Reserved ·