IDWedge Pro: How to create formulas

How to Create a Formula in IDWedgePro

Follow these steps to create a simple address formula to fill in and address in an Excel spreadsheet.

Launch the formula page from IDWedgePro by clicking on Settings->Formula.

Create an Excel spreadsheet with the first row that establishes the Address fields filled in; in this case, we saved a spreadsheet called SimpleAddress.xlsx.

This will be the test target for the Form Filling feature.

Step1: Using the pulldown box on the formula page called Title bar list running on this PC, select the spreadsheet,

(press refresh if you can’t find it) and create a name for your formula,

In this example, we will call it Mailer. Click on the Add Formula button:

Step2: In the box labeled Driver License Fields, select the field called First, and check off a field processing box (we will use Upper Case), then click the Add button associated with the two upper boxes:

You can see that the first formula entry of F UC is added to the formula box on the right-hand side of the screen.

Step 3: in the lower Keyboard keys box, select Tab for the Keyboard keys, then click the Lower Add button; this will insert a TAB into the formula:

Repeat steps 2 and 3, but use the Last, Address, City, State, and Zip fields, all with tabs in between, to create a formula, and then click on the Save Changes button at the top of the screen:

Step 4: to test your formula, close the Formula page and Run the Simulator: Settings->Simulator

Click Simulate, and you will have about 10 seconds to bring the SimpleAddress.xlsx to the front of the screen and place the cursor on the first cell of the row to be filled:

Step 5: Verify results

You will only see fake information from the simulator, with the first name of TOKEN last name of WORKER, as the simulator uses dummy info.

You have just created your first formula.