If you use the ability to send Referrals via SMS (Text message) on your Call Report Forms, we have an exciting new capability to share with you. You can now customize the template used when sending these referrals via SMS message.
There is a default SMS Referral Template which sends information via text message in the following formats:
Agency Name; Agency Phone Number (first found custom-phone or all named phones); Loc: Agency Address Line 1, Agency Address Line 2, Agency Town/District, Agency City, Agency State/Province, Agency Zip/Postal Code
E.g. Elmdale Food Bank; 805-333-3333; Loc: 225 Simi Village Drive, Unit 2, Simi Valley, CA, 93065
Program Name; (first found custom-phone or all named phones); Loc: Program Address Line 1, Program Address Line 2, Program Town/District, Program City, Program State/Province, Program Zip/Postal Code
E.g. Food Hamper; 805-333-3333; Loc: 225 Simi Village Drive, Unit 2, Simi Valley, CA, 93065
There are two ways that phone numbers will be added to your default SMS Template:
- If Custom-named phones fields have been used on the Agency or Program record the first Phone Number found will be included in the SMS Referral, all other custom-named phones or named phone numbers will be omitted. (e.g. If you use the 3rd and 4th phone number fields, only the 3rd phone number will be included in the SMS Referral.)
- If you use the Agency Phone Numbers (named phone numbers) all of these numbers will be included in the SMS Referral in the order Fax Number, Toll Free, TTY, After Hours, Business Line, Hotline, Out of Area. (e.g. 403-215-5454 403-5487-2485 800-5428, etc.)
This is how such referrals by SMS may look as you prepare your report form. Note that the default SMS Referral template does not include labels or descriptions for included phone numbers.
So, how do you go about customizing the appearance of these SMS messages?
Creating a Customized SMS Referral Template
To modify your custom SMS Referral Template, contact iCarol Support by submitting a case through your Help menu. In your request include the following:
- The name of the Call Report(s) you would like the custom SMS Referral Template to be used for
- The Resource record fields you would like to include in your template for Agency and Program referrals.
- Any labels for those fields (or groups of fields, such as “address:” or “Loc:”).
- Provide separate details for what you would like SMS referrals to look like for Agency and Program records, iCarol Support will then work to incorporate all of your requests into one Template.
Here is an example of what SMS Referral Template could look like, at this time we are only able to include fields located on Agency or Program records, any values located on your ProgramAtSite or Sites won’t be available for your template.
AgencyName; Short Description; Hotline: Hotline, TollFree: Tollfree, Main: BusinessLine; Loc: Address Line 1, Address Line 2, City, County, Zip Code
ProgramName offered by AgencyName; Short Description; Hotline: Hotline, TollFree: Tollfree, Main: BusinessLine; Loc: Address Line 1, Address Line 2, City, County, Zip Code
(Note in the Starter Template Examples, labels will be italicized to help identify them – these labels will not appear in your SMS Referral Template if values do not exist in the field. e.g. Only a handful of your Program records have Toll Free Numbers, but when the toll free number exists it’s important that it is sent to the caller.)
If your organization wishes to use this feature, or if you have any additional questions on how to use it, please send a request via the Online Case Submission Tool, found in your Help menu, for support. Not sending out referrals by SMS message? Contact our team today to get started.
Beginning in 2011, when the Unites States Senate first recognized Information and Referral Services Day, November 16th was designated to raise public awareness and recognize the critical importance of the I&R field.
Every day thousands of people find the help they need quickly, conveniently and free of charge because of Information and Referral (I&R) services. I&R services come in all shapes and sizes, from crisis lines that provide their local community with a core set of human service referrals, to larger scale 2-1-1 centers providing comprehensive Information and Referral services to entire states or provinces covering many different topics and types of services.
Information and Referral is the art, science and practice of bringing people and services together and is an integral component of the health and human services sector. People in search of critical services such as shelter, financial assistance, food, jobs, or mental health support often do not know where to begin to get help, or they get overwhelmed trying to find what they need. I&R services recognize that when people in need are more easily connected to the services that will help them, thanks to knowledgeable I&R professionals, it reduces frustration and ensures that people reach the proper services quickly and efficiently.
The people who work these lines are consummate professionals who are often times like living, breathing encyclopedias; providing answers to questions ranging from, “Where can I get a free meal for my family” to “There’s a horse running loose in my neighborhood, who do I call?” We at iCarol are really honored to have so many Information and Referral services all across the world use our software to help provide these services to people who reach them via phone, chat, or text.
If you’d like to learn more about what iCarol does to support efficient referral management, check out this page of our website that goes over some of those features. You’re also welcome to join one of our regular webinars that focuses solely on our Information and Referral tools. We hope you’ll join us sometime to learn more.
Happy I & R Day, everyone, and kudos on the awesome work you do connecting people with the services they need!
One of the major challenges that the Information and Referral industry is facing, is finding a way to reliably share currently isolated databases with partners in real-time. Often times in the same metropolitan area, you will have numerous human services agencies managing their own listing of community service providers to whom they may refer their clients for specialized services.
Just assembling such a database initially is a rather large undertaking, no matter how many such service providers you might be trying to track. But then keeping those records accurate and up-to-date is an ongoing, labor intensive endeavor.
Now imagine that effort being duplicated by 5, 10 or even 50 agencies, each of whom has an internal need to have such a referral database. The amount of time and resources that are being duplicated is significant.
So the I&R industry is responding with two different initiatives, both of which aim to make it easier for agencies to share their referral databases with each other, electronically and in real-time, without the need for everyone to be running the same software platform. In each case, the vision is that the agency modifies the software they are running to manage their referral database (which of course iCarol does quite well) to accommodate the developing standards. Once done, the software should be able to both make its own referral database available to partners and third parties, as well as receive such information from those entities.
From then on, an agency could reduce or eliminate the need for themselves to curate a referral database and instead could rely solely on their partners to provide such data. This gets even more interesting when you contemplate incorporating specialized referral databases by entities that target specific populations, like cancer patients, suicide prevention and so on. One could assemble, through these electronic partnerships, a network of very rich referral databases all curated by subject matter experts.
Both initiatives are at about the same early stage in their development, where needs are being collected and the specifications are in draft form. Code For America is sponsoring the Open Referral initiative, and the Alliance of Information and Referral Systems (AIRS) is sponsoring what they are initially calling “Linked Data”. It is still unclear exactly how they will be different, but based on the stated goals of each project, a good guess is that Open Referral will be targeting a lightweight, easy to understand and use specification that can be quickly adopted by software developers. The AIRS “Linked Data” project, on the other hand, will likely be a more complex and powerful specification that would meet the needs of their membership organizations, that follow a highly evolved and detailed set of standards.
Indeed, the prospect for the industry is thrilling, and iCarol is at the forefront of these efforts. We have senior representatives actively engaged in conferences, discussions and specification development. We’ll continue updating you on these efforts here on this blog, stay tuned for what promises to be an exciting ride.
In iCarol, we offer a resource structure, or hierarchy, called Agency, Program, Site. If you’d like to learn more about this structure, you can download our guide about this information. The Agency – Program – Site hierarchy in iCarol follows the structure recommended by the Alliance of Information and Referral Systems (AIRS) and is most often used by those agencies using the AIRS taxonomy. Using this structure, at the 3rd or 4th level, (the 4th level being programatsite), has an effect on which information is displayed when viewing agency and program records within iCarol.
An agency is a legally recognized organization that delivers services. (edit screen identified by a grey ribbon)
The agency is the main location of the resource where the administrative functions occur, where the organization’s director is generally housed and where it is licensed for business. An agency may or may not deliver direct services from this location.
Sites are the physical locations (eg. branches) from which clients access services provided by an agency. (edit screen identified by blue ribbon)
If only one locations exists, all information may be stored in the agency record. If multiple sites exist, then ALL information recommended for Site must be stored there, since those fields will be displayed instead of the agency version.
The display hierarchy is: Program-at-Site (if using) Site / Program (if using)/ Agency (if a piece of information exists at all three levels, Site info will display
A service/program record describes the types of assistance/service an agency delivers to its clients. (edit screen identified by green ribbon)
If only one program exists for an agency, all information may be stored in the agency record for that resource.
Program-at-Site contains specific details about a program that are available at a site. (edit screen identified by beige ribbon)
It is helpful to understand what information from which type of record (agency, program, site or programatsite) will display so you can made educated decisions on what information to place in each record so that referrals given to your callers as an accurate as possible.
Our Support Team can provide you with an Excel document that shows what information will be displayed when viewing agency and program records. There are two tabs in the Excel document, one for those using the three level hierarchy (agency, program, site), and one for those using the 4 level hierarchy (agency, program, site, programatsite). If you’d like us to send you this document, please open a Case with support using the Case Management tool found in the Help section of your iCarol system.
We mentioned recently that at this year’s AIRS conference a workshop called Resource Database Assembly: The Next Generation provided some inspiration in making a measurement available within iCarol that calculates the complexity of your resource database. We have now added this tool to iCarol.
Resource Complexity is a concept first suggested by several AIRS luminaries. By using approximations, it is used to calculate how complex your resource database is and how many hours per year it would take to manage them using the AIRS standards. For each Agency record, it gets 1 point for every Site record and 2 points for every Program record belonging to it. The Agencies are then grouped by their point score into the following categories:
Simple: 0-10 points
Moderate: 11-20 points
Difficult: 21-40 points
Complex: 41 points and higher
Once grouped and counted, you then assume an average number of hours per year for a trained worker to manage those resources, as follows:
Simple: 1-5 hours (average of 2.5 hours)
Moderate: 5-10 hours (average of 7.5 hours)
Difficult: 10-20 hours (average of 15 hours)
Complex: 20-40 hours (average of 30 hours)
With the total number of hours calculated to manage your entire database, you can then estimate how many Full Time Equivalent employees you may need to manage your database. There are 2,080 hours in a standard work year (40 hours per week for 52 weeks) but the hours available to an employee are usually less than that to account for vacation, sick days, training, meetings and other administrative work that will reduce their hours available to do resource database management.
To use this tool, simply navigate to Statistics and click on the Resources tab. The values for the assumptions of Resource Database Complexity described earlier obviously greatly affect the calculations. They have been in use by a major US 211 center since 2009, who claim they very accurately predict workload. Your own results may vary. If you would like this tool to allow you to modify these assumptions, you can contact our Support team using the Case Management tool found in the Help section of your iCarol system.
A large chunk of time spent managing records according to AIRS standards involves keeping those resources up-to-date. When records are regularly checked for accuracy and updated, you know your clients are receiving helpful, good information. This reduces the frustration and feelings of being overwhelmed experienced by those who may already be in crisis or an otherwise difficult situation. Even a database full of records rated as “simple” will take thousands of work hours to manage.
If you check your database’s complexity and feel overwhelmed at the number of hours it may take to keep your database in check, then it’s time to consider iCarol’s Automated Verification tool. With this upgrade you can seek out the resource records that need to be verified using the same search tools as you would to give referrals, with the additional tool of date parameters showing when the records were last verified. Next, automatically send an authorized worker of that agency or program an email asking them to review the information you have on file and make suggestions or updates. They’ll be given a peek at the information as it exists in your live database so they can make those suggestions. Finally, your Resource Manager can review this information and choose to accept what’s been submitted or make some of their own tweaks first, and then apply the update to the resource record. What might have taken weeks of phone tag to accomplish has been squashed down to a fraction of the time. To find out more about Automated Verification and how it can assist you with keeping your resources updated, sign in to your iCarol system and check out the video.
We hope you enjoy this new ability to view the complexity of the resources in your iCarol database and that it helps you analyze your staffing needs pertaining to keeping your Resource Database accurate and up-to-date.
Recently Vinh and I attended the Alliance of Information and Referral Systems annual conference in Atlanta, GA. As always it was a great crowd and we had fun seeing so many friendly faces, catching up with our friends, clients, and colleagues, and hearing about what everyone’s been up to. Here we are at our booth, waiting to tell everyone in the exhibitor’s hall all about iCarol Helpline Software.
A true highlight was the reception on Monday night, held at the Georgia Aquarium, an amazing and beautiful place. If you visit the Atlanta area it’s a great attraction to check out.
On Tuesday night we had a great time with some folks at the Atlanta Braves game, though unfortunately the home team lost against the Mariners 5-7.
And of course, there were lots of great presentations and exhibits to check out at the conference. We enjoyed 211 Ontario’s presentation on Service Delivery from the Community up. With 7 call centers, 36 data providers, and 500,000 calls per year, it’s quite an impressive group that we’re proud to be associated with.
There’s a lot of discussion about “Open Data” with various initiatives underway, and iCarol is involved in all the discussions and brainstorming on that topic. We’ll have more to share about this topic and our involvement in the coming weeks.
California 211 presented information on the Kinship Navigator project which utilizes the iCarol API. In short, people search the Kinship Navigator system on the iFoster server, which is totally separate from and unrelated to iCarol. When a user searches the iFoster server on that website, it realizes there’s information in the participating iCarol systems that may fit that person’s search, and so with the details and nuances existing via the iCarol API, iFoster servers reach out via iCarol API to the four different participating iCarol systems and collects appropriate and authorized resources, then sends them back to the iFoster system for the person searching that website. This all happens seamlessly and in a matter of seconds. To hear a little more about this you can check out our recent webinar on iCarol’s Resource Tools (skip to the 36:10 minute mark if you want to hear specifically about this project). The technical ins and outs of understanding how an API works can be daunting, and so there were lots of questions. One audience member posed the analogy, “So is an API sort of like when a cashier at the front desk hollers back to the store room to bring them a can of beans, and the stock boy brings it to the cashier who then sells it to the customer?” And yes, that’s a great analogy!
The Orange County 211 presentation on their public website revisions was fantastic. With just a few small tweaks in how they use iCarol’s Public Resource Directory, including the addition of Folksonomy, they increased their website traffic by 108% in two months, with no changes in their marketing at all.
And finally a workshop on Resource Database Assembly: The Next Generation, presented a very interesting notion on Resource Complexity. It was so inspiring that it’s going to result in a new feature to iCarol, more details on that soon!
AIRS put on a really great conference this year, and in case you’re interested they’re making a collection of photos from the conference publicly available here. Thanks to everyone who stopped by our booth to say hi, and of course to the new friends we made if you want to learn more about iCarol we’d love to hear from you. Give us a call,
or join an upcoming webinar to learn more about us and our features.
Often times our clients who do Information & Referral (I&R) need to export some or all of their resource or referral database to share with a third party. And while all Admins have access to the Data Export tool that gives them an Excel-readable export of all records and all fields, a more refined approach is needed for specific requests. For example, you might need to create a nicely formatted Microsoft Word document of just the Child Day Care providers in a particular city and just with a handful of informational fields. Or you might need to create an Excel listing of Food Pantries that serve Veterans in a three-county area. As well, you need to produce both of these files once per month and distribute them to your partners.
You can imagine that laboriously exporting all of your resource data and then laboriously removing fields and rows, then formatting it just the way you want to, could be very time consuming – especially if you have to do it on an ongoing basis.
That’s where iCarol’s Specialized Export to Word and Excel comes to the rescue. With it, you can create an unlimited number of “templates” with a targeted set of conditions and formatting to export just the resource data you want to Word or Excel, and have it formatted in the font type and size of your choice.
You start by naming a new template, choosing either Word or Excel, and indicating what record types (Agency, Program, Site) you want to be included.
Next you specify which standard and custom fields you want included.
Then you add any filters you would like to limit the exported records. Geographic filters indicate that records physically located within, or that are designated to serve, one or more areas are the records to be included. These areas can be as small as single postal codes, towns, cities, counties, regions, states/provinces or entire countries. You can even mix and match a number of different types of geographic areas.
Depending on what sort of categorization scheme you use – the AIRS Taxonomy or your own custom categorization – you can also add filters to include only those resources that area assigned to one or more of those categories.
In addition to the many standard fields available for resources in iCarol, many of our clients add their own custom fields. For any that are either drop-down lists or check-boxes, they too can be added as filters to confine the resources included in the export down to just those assigned to one or more of these custom fields.
After you’ve saved one of these templates, at any time you can tell iCarol to perform an export based on its definition and within a few minutes you’ll have the file ready for your download, use and distribution. As well, we’ve structured the Word documents to make it easy for you to add your own title pages, tables of content, indexes, headers, footers and more. That makes it easy to include the content in a larger document and brand it with your agency’s identifying information.
If you’d like to add Specialized Exports to your iCarol system and provide your community with targeted resource directories, contact our for more information.
iCarol has many tools to use when searching for resources. Using these tools, call takers can fine tune their searches in order to find the most appropriate resources for your clients. Please read on to learn about these tools and how to use them.
There are three search types in iCarol – Taxonomy, Resources and Keywords.
Taxonomy refers to the AIRS Taxonomy, used by 211 agencies in Canada and the United States. This is a 7 level categorization hierarchy that is used to categorize human service agencies into over 9,000 categories.
Resources is used to search your resource database for the name of the agency or program.
Keywords refer to a categorization system that you can set up yourself. Placing your resources into categories can help your call takers narrow their searches quickly to find, for example, Domestic Violence resources or Individual Counseling resources.
There are several filters you can apply to your searches on top of the search type.
Names should be used when you want to search by the name of the agency or program. Please note that searching Resources actually searches three different text fields in your resource records – Name, Alternate Name and Search hints. In this way, you can search for the Salvation Army by its official name, Salvation Army, its alternate name, Sally Ann, or a term that is placed in the search hints, perhaps the name of the building the agency is housed in, the Hope Center.
All fields can be used to search other text fields in the resource record besides Name, Alternate Name and Search hints, such as the Description field. This can be helpful if you are searching for a term that is not likely to be found in a name. For example, perhaps the client needs help obtaining diapers. It is very unlikely that there is a resource name in your database with the word diapers, but that word may appear in a Description field where the services the agency or program offers are outlined.
Specific field, with the associated drop-down menu, can be used to conduct a search in a very specific text field, such as address or eligibility.
Agencies, Programs, Sites or ProgramAtSite will appear for those using the three or four level resource hierarchy available in iCarol. In this way, the call taker can limit their searches to just certain record types. Best practices indicate that the majority of searches should be conducted at the program level.
Include Inactive and Include Active but do not refer refers to the status of the resource records. These filters can be used to search records of all statuses, not just the active resources.
These filters can be used to narrow searches by their proximity to the client or the coverage area the resource serves.
All resources means that no geographic filters will be applied to the search and all resources that meet the other filters indicated will be displayed
Resources within means that iCarol will search for resources that are physically located within the geographic area indicated by the country, state/province, county, city and postal/zip code filters entered. iCarol bases this search on the physical address entered into the resource record.
Resources serving means that iCarol will search the coverage area of each resource and return those that meet the geographic area indicated by the country, state/province, county, city and postal/zip code filters entered. iCarol bases this search on the coverage area field in the resource record.
Combining the filters above when conducting resource searches can result in a smaller, targeted list of results that is much more manageable for the call taker to look through. This saves time and increases the likelihood that the client receives the most appropriate resources to meet their needs.
If you’re attending the annual conference for the Alliance of Information and Referral Systems (AIRS) this year, you can catch us participating in a few different presentations. First, join us for a 90-minute presentation on the future of I&R with iCarol. We’ll be covering exciting new topics such as 2-way texting, live chat, using Folksonomy, interacting with partners via an API, and much more. We’ll be presenting this on Sunday, June 1st at 2pm.
2-1-1 California will also be presenting on their project to create a public website focused on caregivers of children. They made heavy use of the iCarol API to allow the website to present information from the live resource databases of several counties. This session is scheduled for Monday, June 2nd at 3:00pm.
In addition, 2-1-1 Orange County will be presenting a session called “Folksonomy NOW: The wait for a user-friendly database search is over!” detailing their exciting results using an iCarol-powered “Folksonomy” to radically improve the search experience of public users by connecting common search words and phrases with multiple taxonomy terms. This session is scheduled for Wednesday, June 4th at 10:45am.
Please confirm in the conference program for time and location details of all sessions as they are subject to change. We look forward to seeing you in Atlanta!
Kids Help Phone has a 25 year legacy of providing phone and online emotional support for Canadian children and teens. An authority on a variety of topics, their professional helpline counsellors are available 24/7/365 to talk to kids about any issue. They are a nonjudgmental source of trustworthy information on mental health, bullying, sexual health, peer and family issues, addictions, and more. Tens of thousands of kids reach out to their services each week via phone, online chat, and written correspondence on the Kids Help Phone website. They play a large role in the continuum of mental health care for Canadian youth.
Kids Help Phone recently launched the “Always There” app and “Resources Around Me” public database. “Always There” was developed with the help of kids submitting their input and voting on features. It allows kids to keep a private log of their feelings and experiences. App users can contribute to stress buster activities that offer helpful tips, inspirational quotes, and jokes.
“Resources Around Me” provides Canadian youth with greater access than ever to the resources available in their communities. By simply starting with their location and then the types of resources needed, teens can easily find what they’re looking for and then connect directly with those resources.
The iCarol team is proud to have been a part of this project through our support of the resource database and the API. How can your organization make use of these same tools? How about adding on the Public Resource Directory to your iCarol system so you can share resources with the public via a resource search on your own website? iCarol’s API gives your software developers the data they need to work on a variety of new and exciting projects. If you’re interested in pursuing a project like this, send an email to