Registering New and Existing Students for new program terms

Hi Meg!

At the last organization that I was at, we had a similar issue. We had applications coming in for a summer camp that we host, and we had the same problem, where the native intake forms only allow new Tier 1 records to be created. To combat this issue, we actually had to use three third-party applications:

• JotForm - This is a tool that allows you to make forms. It’s like Microsoft Forms or Google Forms, but in my opinion, it is the best web-based form builder. 
• Zapier - This is an automation tool that allows you to connect applications that don’t normally talk to each other. In this case, we used it to transfer the answers that were input into our Camp Application on JotForm directly into Apricot. 
• Sidekick Solutions - In order to use Zapier with Apricot, we had to pay an annual fee to license their “Connector” application because Zapier doesn’t actually interface directly with Apricot. Basically, we had to pay them to give us a tool that allowed Zapier and Apricot to talk to each other.

Using Zapier with Apricot allowed me to set it up so that incoming applications actually checked for pre-existing records in our system, based on duplicate check fields. I think I set the duplicate check fields to name and email address for the adult records, and name and birthday for children’s records. This made it so that whenever an application came in, Zapier would automatically check our database to see if the record already existed, and then if it did exist, I set it to update the existing record, and if it didn’t exist, I set it to create a new record. 

I don’t know if I am allowed to link to other websites on here, but if you Google the following, the first result should be an FAQ page about all of this on Sidekick Solutions’ website:

Zapier FAQs for Bonterra Case Management (Apricot) Automations

I will say, it was a pretty complicated project, and unless you are pretty tech savvy, I would suggest either working with a consultant on this or finding another way to deal with it. 

Let me know if you have any questions!

Best,

Hollie

Thanks so much Hollie. It’s a shame it’s so complicated and requires additional platforms for it to work smoothly. But this does confirm that there really is not a great work around for this directly in Apricot! Thanks for sharing. I wonder if other folks have other similar work arounds?