question

CptJera avatar image
0 Votes"
CptJera asked JadeLiang-MSFT commented

Need to know what binary fields are available for Outlook Contacts

We have a CRM database that we export contact information and import into Outlook. Two fields imported are binary. 1 or 0. These 'checkmark' fields need equivalent searchable and sortable Outlook fields that I can include on customized Contact General info pages as well as in the Contacts folder(s) columnar views. Which fields are available within Outlook for this purpose? Thanks! Jera Anderson

office-outlook-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JadeLiang-MSFT avatar image
0 Votes"
JadeLiang-MSFT answered JadeLiang-MSFT commented

Hi @CptJera,

Welcome to our forum.

I understand you would like to find a field that support binary data in your Outlook contact page, is it right?

If so, have you tried to create a custom contact form? According to my research and test, I haven't found a dedicated binary field in field chooser of a contact form, and we may just could add the int field or yes/no field in the form, if that's your case, as a workaround, we could try to switch your data type and add the yes/no field to help you search and sort by this value.
80513-snipaste-2021-03-23-13-45-18.jpg


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The problem I find with this method is a custom field is not available during the import data process.

0 Votes 0 ·

Thanks for your update, I'm still researching for your issue. Due to here we mainly focus on general issue on Outlook desktop client, I haven't had a CRM database and just tried to import contacts from an .csv file for testing. Based on my tests, we could map the filed mannually when we import the file like below, though there seems to be no dedicated binary field there, we still could map other filed(such as other Fax or others), which could also support the value of "Yes\No", so that we could filter our contact via this field.
81513-snipaste-2021-03-25-18-12-50.jpg

if that's invalid for you, considering your issue may be more related to CRM, it's suggested to post your issue in dedicated CRM forum, so that there may be more related experts who could give you more targeted suggestions.

0 Votes 0 ·

Just checking if you are still researching for this issue, if it has any update, please feel free to post back.

0 Votes 0 ·