Skip to main content

Is there a toggle for case-sensitive?


1 comment

  • Tiffanie Staver
    TrackVia (Community Manager, TrackVia) commented  ·  

    To confirm here, you are correct in your findings. Import to Updates require an exact case-sensitive match to the Record ID of the record you are mapping your update to. This cannot be changed at this time, however there is a quick workaround that may be helpful in this scenario. The goal is convert your email addresses to be completely uppercase in both TrackVia and your import file to ensure that they always match. First, you would need to added a triggered or calculated text field to your table with the following formula:

    upper({Your Email Field})

    This formula will convert all of your email addresses to uppercase. You can then set this new field as your Record ID so that it is used for your import mappings.

    From here you just need to get the email addresses in your import file to be uppercase as well. I believe this can be achieved a few ways in Excel, but the quicker way I have found is to use the UPPER text function, which looks like this:

    =UPPER(your fields)

    Now that your TrackVia table and your import file both contain strictly uppercase values you should avoid any case sensitivity issues.

    I hope this is helpful. If you have any further questions regarding this solution or if we can field any further questions, please let us know.



Please sign in to leave a comment.

Powered by Zendesk