Skip to main content
Question

Create a case-sensitive field for Salesforce data import

  • January 29, 2018
  • 0 replies
  • 89 views
I'm pulling in data from Salesforce that I may need to update or link back to the Salesforce record later, and it turns out the unique identifier in SF is a case-sensitive string. Any way we can create a unique field in Quick Base that is also case sensitive? Anyone figured out a work around option? Thanks!
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • January 29, 2018
    Hi Leanne,

    There is a formula function that will take a text string or text field and return all the characters in it in upper case. It is Upper([field name]). So it would be possible to create a text field marked as Unique and then a formula field which converts any text into that field into all Upper case. That way you will have a field which matches your case sensitive needs. Alternatively Lower is the formula function if you want to return the text string is all lower case. I hope this is helpfu. 
    Terms & ConditionsAccessibility statement