Data configurations in your Vome database

What are data configurations in my database?

Data configurations are two settings that decide how your database behaves before you have asked it for anything: how much of it loads when you open the page, and how profile names read in the grid. They exist because a database with thousands of profiles should not make you wait for all of them just to look one person up.

Info
These are your settings, not your organization's. Data configurations apply to your admin account only, and they follow you across every view in the database, including your saved custom views. Changing them does not affect what anybody else sees.

1. Where do I find them?

Go to Database, open the actions menu at the top of the table, and choose Data configurations. The popup holds two sections, Name display and Profile loading. Make your choices and click Save.

2. What does Profile loading do?

It decides how much of your database arrives when you open the page. There are three options.

  • Start with my saved view. The default. Your database opens on the first batch of results for whichever view you normally use, and more load as you need them.
  • Start empty, search first. The page opens instantly with no rows and the search box waiting. Nothing is fetched until you search or add a filter.
  • Load everything. Every profile is fetched up front. Slower to open, and the only option that keeps every single filter working across your whole database without loading more.

3. Which option should I choose?

It depends on what you come to the database to do.

  • A few hundred profiles, and you like scrolling the list: Load everything is fine and nothing changes for you.
  • A few thousand profiles, and you browse as often as you search: Start with my saved view.
  • Tens of thousands of profiles, and you almost always arrive looking for one person: Start empty, search first.
Idea
If your database feels slow to open, try Start empty first. It is the biggest single improvement available to a large organization, and it costs you nothing: your searches, filters and saved views all work exactly as they did, you simply say what you want before the rows arrive rather than after.

4. What are Results per load and Open sorted by?

Two smaller dials that sit under Profile loading. They apply to the first two options and are hidden when you choose Load everything, which has nothing to page through.

  • Results per load is how many profiles arrive at a time: 50, 100, 250 or 500. A smaller number opens faster, a larger number means fewer clicks on Load more.
  • Open sorted by is the order your database opens in. Choose No sorting, Last name, First name, Most recently added, Next shift or Last volunteered. You can still click any column header afterwards to sort differently.

5. Why does my database say "Showing 100 of 871"?

Because 871 profiles match what you asked for and 100 of them are currently on screen. The count next to Results is always the full number of matches, so you can trust it even when fewer rows are loaded. Click Load more next to it, or at the bottom of the table, to bring in the next batch.

Caution
Selecting rows only covers what is loaded. If you tick the header checkbox while 100 of 871 are on screen, you have selected 100 people, and any bulk action or export will act on those 100. Vome tells you when this happens and offers a Select all matching button that loads the rest first. Use it before a bulk action rather than after.

6. Why is there a Run button on my search and filters?

So that your results do not change under you while you are still deciding what to ask for. Typing a search or building a filter stages the change, a bar appears telling you there is something to apply, and the database updates when you click Run. Pressing Enter in the search box does the same thing.

Switching views and clicking a column header to sort are single, finished actions, so those apply straight away without asking.

7. What does Name display do?

It sets how profile names read in the grid. There are three options.

  • Combined Name Column. One column reading First name Last name. The default.
  • Last name, First name. One column, surname first. Keeps your grid narrow and lets a single Name column read and sort by last name, which is what most people want when they are scanning an alphabetical list.
  • Separate Name Columns. First name and last name in two columns, so you can sort, filter and export them independently.

8. Do my searches and filters still cover the whole database?

Yes. Searching and filtering happen across every profile you have permission to see, not only the ones on screen, which is why the Results count can jump to a number larger than the rows in front of you.

A small number of filters still need the full list in memory to work, including Activity status, Years of service, Languages, Skills and the advanced filters. If you apply one of those, Vome loads your whole database for that view and tells you which filter asked for it. Everything keeps working, it just takes longer that once.

9. Does this change anything for my users?

No. Data configurations only affect your own admin view of the database. Users see nothing different, no data is changed, and you can switch between the options as often as you like.

Summary

  • Database, actions menu, Data configurations.
  • Profile loading decides how much arrives when you open the page: your saved view, nothing until you search, or everything.
  • Results per load and Open sorted by set the batch size and the opening order.
  • The Results count is always the full number of matches. "Showing 100 of 871" means 100 are loaded.
  • Selections and exports cover loaded rows, so use Select all matching before a bulk action.
  • Name display offers First name Last name, Last name First name, or two separate columns.
  • Everything here applies to your admin account only.

If your database still feels slow after changing these settings, submit a ticket or email us at support@vomevolunteer.zohodesk.com.