ABC
1
How To Set Up Your Own Mileage Calculator FormVideo Tutorial
2
3
Step 1:Make a Copy of this Spreadsheet (if you haven't made a copy yet, you will need to do so in order to make the changes necessary)
4
5
6
Step 2: Run Initial Configuration for Both formRanger and formMule (You may have to do this a couple of times to get the right menu options to show up)
7
8
9
Step 3:Assign Form Items to Columns in the formRanger Menu (set the From, To, and Purpose fields to populate from the FormRanger Fields Sheet)
10
11
12
Step 4: Set Triggers for Form Refresh in the formRanger Menu (check all boxes and save trigger settings)
13
14
15
Step 5:Define Merge Source Settings from formMule Menu (set it up for the Form Responses 1 Sheet)
16
17
18
Step 6:Click on Advanced Options in the formMule Menu and then select Copy Down Formulas on Form Submit
19
20
21
Step 7:Select Column H for the driving distance formula and then selct paste as values only.
22
23
24
Step 8:Change your Home and Office Information in the first Row of Form Responses 1 and then Go into the Mileage Template and Input your Information at the top
25
26
27
Step 9:Duplicate the Mileage Template sheet and change the month/yr you would like to make this new sheet for.
28
29
30
Step 10:Fill out your form as many times for the month you want to submit mileage for, and then print that sheet as a PDF for signature.
31
32