Data Search

Array's data search feature can help clear the air.

It's easy to imagine situations where you may already have information about someone interacting with your Array forms. Perhaps you're hosting a marketing event and you want to check whether or not someone is on your mailing list already — if they are, they can enter immediately, otherwise, they need to give you some basic contact information. Or maybe you want to add sales leads to your CRM, but aren't sure if they're already in the database.

Array's data search feature can help clear the air in situations like this. Not only does data search allow you to search your Array database for user information, but it can even search external applications like Google Drive, Dropbox, or Base CRM. If a match is found, Array will auto-populate the form with their information, saving time for you and your clients.

In this article, we’ll explain how to:

  • search integrations
  • search the Array database
  • search a CSV file
  • Search an external application

Before moving on, we recommend you first understand the basics of our integrations, which we explain here.

Data Search

The data search feature can be found at the bottom of the "Text Element" tab in the Form Builder Toolbox.

Immediately after adding a data search option to your form, the Search Data Link menu will appear. Here you'll see three search locations to choose from: external integrations, the Array database, or a CSV file. We'll take a closer look at the three different types of data search options below.

Searching Integrations

The first data search options refer to external databases, such as Dropbox, OneDrive or Evernote. When you open the "Integrations" tab, you'll see a list of applications that you've connected to your Array account.

If you haven't connected any apps, you can do so from the Array Market

Data search for integrations works in one of two ways:

1) For CRMs like Base or Salesforce, Array will search the entire database for a match.

2) For cloud storage services like Google Drive, Dropbox, or Evernote, Array will search within a specific spreadsheet.

Searching CRMs

When searching a CRM, you'll be given the option of updating the database's information based on the user's response. For example, if a user searches for Bob Smith and finds a match, but they change Bob's email and phone number before submitting the form, that change will be reflected in the CRM as well.

Additionally, users can also choose to attach responses to the CRM. If Bob Smith uploads a photo and Excel file to Array, those files will be stored in his page on the CRM. By clicking the PDF option, users can also have a carbon copy of the completed Array form saved to the CRM.

Searching Cloud Storage Services

When searching a cloud storage service, you'll first be asked to choose from all the spreadsheets saved on that application's database. This will be the spreadsheet Array searches within.

Next, you'll see the titles of each of the columns in the selected form. Choose which of these columns you'd like to pull into your Array form, and a new field will be created for each.

Searching Array

Alternatively, you can also search information already saved in your Array account. This process works similarly to searching an external cloud storage app.

First, you'll be asked to select the form you'd like to search from.

Next, choose the fields that you'd like to appear in your new form.

The form will now have a search field to look within your chosen form, and all results will be reflected in the fields you selected.

Searching a CSV

Array can search for data within a CSV or Excel file. Again, this is similar to how it searches a cloud storage service.

First, upload your spreadsheet to Array.

Then, as before, select any fields that you'd like to pull into your Array form. You can also select for Array to update the CSV based on new information it receives. This will only change the information in Array's copy of your CSV; it will not update the file saved locally on your computer.

Searching From an External Service

This option is more advanced and works a lot more like a Webhook. Please contact your IT administrator to learn more, or alternatively contact a member of our team today.

Use Cases

Two-way sync opens the doors for numerous use cases. For example, companies can create sign-up forms to capture sales leads at conferences and networking events, offering a two-in-one solution that can both capture new contact information as well as update existing members. Simply tie the form to your preferred CRM or email software and have contacts search for themselves. If their data appears, they can update it on the spot, and if they’re missing from the system they can sign up.

Data search also provides a great way to track attendees at public events or add subscribers to a mailing list. In the days leading up to an event, direct your audience to an online sign-up. On the day of the event, use the form to search their name as they arrive. If the search yields no results, use this as an opportunity to capture their information before they enter.

As you can see, data search and two-way sync provide a variety of ways to augment your existing workflows and boost productivity. Incorporate Data Search into your own forms, and feel free to reach out to our expert support team.