Danny

  • Total activity 63
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 34

Activity overview

Latest activity by Danny
  • Danny created an article,

    Required Field Does Not Exist in Upload Document

    If you need a field to be required but the field doesn't exist in the document being uploaded to your importer, this hook will throw an error so the data can be entered in the Review stage.  This h...

  • Danny created an article,

    January 14th 2022

    New Chugging away at some major updates - check back next week! Fixes and Improvements Copying a template now also copies over any included Data Hooks®️ Our REST API documentation no longer incorr...

  • Danny created an article,

    January 6th 2022

    New Our team is busy preparing for big updates coming next week - mark your calendars! Fixes and Improvements Manually mapped select fields were fixed to allow matching to associated enum values W...

  • Danny created an article,

    December 23rd 2021

    Certain updates are only available in our new Portal V3 product. New Portal V3: Field matching in our Portal V3 product is now powered by a machine learning model trained on Flatfile’s knowledge of...

  • Danny created an article,

    Conditionally Deactivate Cell

    If you need to deactivate condition dependent cells based on user input, you would use this hook.  A practical use case would be if a user marks a checkbox "false," they would not be required (or a...

  • Danny created an article,

    Pad US Zip/Postal Codes w/ Zeroes

    Some United States zip codes contain leading zeroes, which can cause a problem with data integrity if those leading zeroes are omitted from your imports.  The following hook can be used to recogniz...

  • Danny created an article,

    Split Single Field Full Name Into Separate Fields

    if (row['firstName'] && !row['lastName']) { if (row['firstName'].includes(" ")) { const components = row['firstName'].split(" "); row['firstName'] = components.shift(); ...

  • Danny created an article,

    Various Methods to Conditionally Require Fields

    Version A: const info = [] if (row['GuarantorID'] && !row['GuarantorFirstName'] && !row['GuarantorFirstName']) { info.push({ message: 'must have either phone or email', field: 'phone', level: '...

  • Danny created an article,

    Convert Excel Data to JS Date

    const dfns = await import('date-fns'); const info = []; async function ExcelDateToJSDate(serial) { var utc_days = Math.floor(serial - 25569); var utc_value = utc_days * 86400; var date_info ...

  • Danny created an article,

    State Abbreviation Normalization

    const us_states = [ { name: "Alabama", code_2: "AL" }, { name: "Alaska", code_2: "AK" }, { name: "American Samoa", code_2: "AS" }, { name: "Arizona", code_2: "AZ" }, { name: "Arkansas", c...