PeterGrant
3 years agoQrew Member
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
------------------------------
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
------------------------------