Hello Team,

Maybe I've had too much screen time today but I cannot seem to figure out how to search my data table by callers ani in the survey invite flow.  The image below is the "inbound call flow" which I use the right 10 numbers to lookup the phone number in the database table and associate the details of the caller.


However in the "survey invite" data table lookup you I don't have the call.ani ability.  How would I lookup a user that is on my "Bennys Test Table"? With call.ani or push data from inbound call flow to survey flow?
#QualityManagement

------------------------------
Benny Martinez
Packet Fusion, Inc.
------------------------------

Had extended screen time myself but when I last played around with this I used an update data item prior to this and in that one I modified the number format to how I needed it to be.  So for example one of our customers has numbers stored in their CRM in the local number format, not E164, so I have to take the subscribernumber portion of the call.ani variable and put it into a phone number type variable (named Flow.aniSubscriber in my case):

"0"+ToPhoneNumber(Call.Ani).subscriberNumber

This essentially takes the +6496496499 from the call.ani variable and returns 096496499.  However it's now stored as a phone number.

So in my data table lookup I convert that back to a string:

ToString(Flow.aniSubscriber)

I'm sure there's a way to compress all that into a single expression/syntax but it works for me.

I guess it also depends on what number format you have the ANI stored in your data table as too.  In my case the key field is stored as that 0nnnnnnnn format as that's easier for the people that update the data table to remember and how they're stored in their CRM.

https://help.mypurecloud.com/articles/about-the-phone-number-data-type/




------------------------------
Vaun McCarthy
NTT New Zealand Limited
------------------------------

Original Message:
Sent: 03-17-2021 01:16
From: Benny Martinez
Subject: Survey Data Table lookup

Hello Team,

Maybe I've had too much screen time today but I cannot seem to figure out how to search my data table by callers ani in the survey invite flow.  The image below is the "inbound call flow" which I use the right 10 numbers to lookup the phone number in the database table and associate the details of the caller.


However in the "survey invite" data table lookup you I don't have the call.ani ability.  How would I lookup a user that is on my "Bennys Test Table"? With call.ani or push data from inbound call flow to survey flow?
#QualityManagement

------------------------------
Benny Martinez
Packet Fusion, Inc.
------------------------------

Thank you for the reply Vaun.

I was able to do a few tests and got it working.
in other flows "Right(call.ani,10)" is used however in survey "right(Survey.CustomerAddress,10)" is the input.

"right(Survey.CustomerAddress,10)" which is strange since the rest of the flows use "call.ani" and the survey invite uses "survey.customeraddress" it made me think I was needing to use the external contacts as my primary source for users. Just needed a break and a fresh start.



------------------------------
Benny Martinez
Packet Fusion, Inc.
------------------------------

Original Message:
Sent: 03-17-2021 03:11
From: Vaun McCarthy
Subject: Survey Data Table lookup

Had extended screen time myself but when I last played around with this I used an update data item prior to this and in that one I modified the number format to how I needed it to be.  So for example one of our customers has numbers stored in their CRM in the local number format, not E164, so I have to take the subscribernumber portion of the call.ani variable and put it into a phone number type variable (named Flow.aniSubscriber in my case):

"0"+ToPhoneNumber(Call.Ani).subscriberNumber

This essentially takes the +6496496499 from the call.ani variable and returns 096496499.  However it's now stored as a phone number.

So in my data table lookup I convert that back to a string:

ToString(Flow.aniSubscriber)

I'm sure there's a way to compress all that into a single expression/syntax but it works for me.

I guess it also depends on what number format you have the ANI stored in your data table as too.  In my case the key field is stored as that 0nnnnnnnn format as that's easier for the people that update the data table to remember and how they're stored in their CRM.

https://help.mypurecloud.com/articles/about-the-phone-number-data-type/




------------------------------
Vaun McCarthy
NTT New Zealand Limited

Original Message:
Sent: 03-17-2021 01:16
From: Benny Martinez
Subject: Survey Data Table lookup

Hello Team,

Maybe I've had too much screen time today but I cannot seem to figure out how to search my data table by callers ani in the survey invite flow.  The image below is the "inbound call flow" which I use the right 10 numbers to lookup the phone number in the database table and associate the details of the caller.


However in the "survey invite" data table lookup you I don't have the call.ani ability.  How would I lookup a user that is on my "Bennys Test Table"? With call.ani or push data from inbound call flow to survey flow?
#QualityManagement

------------------------------
Benny Martinez
Packet Fusion, Inc.
------------------------------