Forum Discussion

QuickBase9's avatar
QuickBase9
Qrew Cadet
8 years ago

Create a case-sensitive field for Salesforce data import

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 creat...
Data import and export
Tables and fields
EvanMartinez's avatar
EvanMartinez
Moderator
8 years ago
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. 
QuickBase9's avatar
QuickBase9
Qrew Cadet
8 years ago
Hi Mark,
The length of the string stays the same at 15 but the use of letters, caps, numbers is unpredictable. The alteration always occurs in the last five characters, but that is the only consistency.