Automatically convert What3Words addresses into standard geographic data including country codes, nearest places, and latitude/longitude coordinates using the official What3Words API.
convertWhat3words
function, which accepts a configuration object with the following parameters:
what3wordsField
configuration.sheetSlug
option:
W3W_API_KEY
secret is correctly set in your Flatfile SpacesheetSlug
and all field keys (what3wordsField
, countryField
, etc.) in your configuration exactly match the schema of your sheetwhat3wordsField
contains valid, correctly formatted What3Words addresseswhat3wordsField
with the message “Invalid What3Words address”. This error will be visible to the user in the Flatfile UI.
W3W_API_KEY
in your Flatfile Space before using this plugin.
sheetSlug
is not provided, the plugin applies to all sheets in the workbook that contain a field matching the what3wordsField
configurationbulkRecordHook
, which runs when the user clicks “Continue” or “Submit” on a sheet (during the commit:created
event)