A place to ask questions, connect with others, and stay in the know
Hello everyone. We are not very familiar with Data Tables, and I have looked at the resource center and other community posts (which have helped greatly with one of our other data table area code lookup flows), but can't seem to figure out what I need to do for the zip code. Also if someone could help me figure out how to set the flow to not need a DTMF to then go to a task.Data Table: We have all zip codes in the key column and the corresponding queue name in our Market Queue column (second column). For example, in the excel file: A2 is 73301 and B2 is AUS OP1 Call CenterWhat we want: When customer call comes in, they input their zip code, the flow looks up the zip code in the data table and (on success) then transfers the call to the correct market queueCurrent build:
Hi Melissa,I think we are missing a step somewhere on our side, do we need to link/tell the variable what to do somewhere? We did a data update to take the input from string to integer and it seems to recognize the zip as integers now, but we don't know how to get the flow to recall/bring back the queue name from the table.So the Task.Austin was just what we named the variable when trying to get the call to get to the Austin queue while testing. We now renamed to Task.QueueResultWe also had a Data Table Lookup in the Failure section as we want the flow to look up the ANI area code and transfer to main market queue if customer does not input anything for zip/inputs an invalid zip. We haven't started building that side, so just a placeholder to remind us to set the failure up after success is working (we removed for now to keep clean).Thank you for the link to the starting task article. We have updated that section.
Below is a snap of the build we have now. I am not sure if we are starting to overcomplicate so we are taking a break and look forward to your reply! Thank you!
Ah okay. That makes sense!
@Anton Vroon and @Melissa Bailey you are both amazing! I appreciate all of your help.
I did what Anton suggested and was still having the same results and it dawned on me that the zip code I was using to test (one I pulled from google rather than my own data table) might not be in the table. Total brain dead moment for that one.
Anyway, we are up and running! Connected to the correct queue! Thank you both again!
Every year, Genesys® orchestrates more than 70 billion remarkable customer experiences for organizations in more than 100 countries. Through the power of our cloud, digital and AI technologies, organizations can realize Experience as a Service℠, our vision for empathetic customer experiences at scale. With Genesys, organizations have the power to deliver proactive, predictive, and hyper personalized experiences to deepen their customer connection across every marketing, sales, and service moment on any channel, while also improving employee productivity and engagement. By transforming back-office technology to a modern revenue velocity engine Genesys enables true intimacy at scale to foster customer trust and loyalty.