Dynamic Call Transfer

[cannix]

Hiya,

 

 

Is it posible to query a database for a telephonenumber and use that information into a call transfer.

 

We want to use one script that can dial multiple people depending on who's calling. We determine that by letting the caller enter an employee number, search a database for a corrosponding "department" number and use that information into a call transfer script.

[SupportTeam]

Yes, you just specify a 'Result Variable' in the Transfer Call module as the destination number to dial, and set the value of that 'Result Variable' beforehand in a Database Query type module or an Evaluate Expression type module etc.

 

Please read: http://www.voiceguide.com/vghelp/source/html/resultvariables.htm

 

Also see: http://www.voiceguide.com/vghelp/source/html/moddbquery.htm for information on what RVs are automatically created by a Database Query type module when the SQL query is made against a database.

 

eg:

 

If you do an SQL query like this:

SELECT TelNumber FROM Employees WHERE EmployeeId='$RV[GetEmployeeNumber]'

 

in module titled "WhichDepartment"

 

then this $RV will be created:

 

$RV[WhichDepartment_1]

 

and $RV[WhichDepartment_1] will contain the value from the TelNumber column.

 

(note that SQL query uses $RV[GetEmployeeNumber] - that would have been set in the Get number module titled "GetEmployeeNumber" in which caller enters their employee number.

 

 

 

Please let us know if you have any questions or would like more explanation.