XL Field Sync Main Form

Click the Browse button to select the spreadsheet that is to be updated.

 

The key column in the spreadsheet to update that will match with a column in the spreadsheet to get values from.

 

Choose Text if column data isn't always a number.  Choose whole number if column only contains whole numbers.  Otherwise if column contains numbers and some of them have a decimal place choose Decimal.

 

Check this if you only want data to be matched if it's cased the same.

 

Click Browse and select the file you want to pull the values from to place in the spreadsheet to update.

 

The key column in the spreadsheet to get values from that matches with the selected column in the spreadsheet to update.

 

Click the cell and then the dropdown to select a column to update (in the spreadsheet to update) and the column that it gets its data from (in the spreadsheet to get values from).

 

Use the * row to add another column to update.

 

Will show the task to be performed or the task currently being performed.  You can also click down on the bottom right corner and resize the form.

 

Click to update the spreadsheet with the fields chosen in Columns to Update.