Provide a fallback column option for when the selected column is blank
J
Jordan Schelew
I'm importing data from LessAccounting where they have both a Title and a Payee field. The optimal mapping is for the Title to map to the Original Name, and the Payee to map to the Payee. But there's just one tiny problem: we only use Payees when necessary to track that info, otherwise the Payee at LessAccounting is blank.
Upon import this makes the Payee field blank because it's far more prominent/important over here. I'd like to be able to say "If the data being imported as Payee is empty, fall back to using field X instead" without it forcing a total remap of that fallback field (ie: the data would be duplicated between the Original Name field and the Payee field).
There's precedence for this already anyway since when data is imported from banks, often the Original Name and Payee values are the same.
Log In