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:Add
Carlos says
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.