Forum Discussion

PeterGrant's avatar
PeterGrant
Qrew Member
3 years ago

Setting fields to be case sensitive

I'm trying to set a key on a table based on a Salesforce data that I'm syncing. However Salesforce, whilst having a unique key for the data is case sensitive, whereas QB isn't

Example - I'm importing the following rows of data from Salesforce, which is all unique (case sensitive).
AABB
AABb
AAbb
AaBB

...however if I try and set these rows in QB it says there is duplicate data is QB isn't case sensitive.

Question - is there a way to force Quickbase to see a field as case sensitive so that I can set this field as the primary key?

------------------------------
Peter Grant
------------------------------
No RepliesBe the first to reply