Adding, Editing and Renaming Fields

The following instructions are for SPoCs. If you're not the SPoC but have needs along the lines of this post, get in touch with your SPoC and they can assist.

Default Field List

This is the list of fields that show on a page's data grid when you are viewing the All Records view on a page. The default field list is also used for many other views on a page, so just because you aren't looking at All Records doesn't mean you aren't still seeing the default field list.

Finding the Default Field List of a Page:

  1. Go to System Setup > Pages.
  2. Open the desired Page record.
  3. Click Edit to see a more readable view of the field list

There are some basic observations you can make. First, to most people, the field list is daunting just because it's not quite plain English, but not completely foreign. Don't let it scare you - it's not as complicated as it appears. Regardless, you should be able to look at the end of each line and figure out which line relates to which column on the page view.

Editing Fields

Note: This is NOT referring to editing fields in SQL Server. For that, see Custom Fields. You can always add custom fields; however, you cannot change system field names.

Now you know where your default field list is. The next question is probably "how do I add fields to that list?". The answer is probably easier than you expect!

  1. Go to the page you want to adjust and open the Advanced Search tool.
  2. Find and add the fields that are missing from your default field list.
  3. Click the SQL View tab.
  4. Before you copy the list, add a comma (,) before the very first field you have listed.
  5. Copy the field list and paste it into a separate text editor (notepad is fine).
  6. Go to System Setup > Pages and open the desired Page.
  7. Paste the field list at the bottom of the existing field list. You may need to insert a carriage return after the last field of the initial field list to make everything look good.
  8. Click Save.
  9. Go to the page in the normal menu and refresh to make sure everything functions OK.

Congrats! At this point, you should see the new fields added after the old fields. Re-ordering fields is as simple as cutting and pasting the list of fields in the setup area.

Renaming Fields (Field Aliases)

Sometimes the name of a field isn't ideal for your specific needs - perhaps it's too generic (Display_Name), or perhaps you just need to edit a field name so it can be used with the New Message Tool as a merge field. Whatever the need is, here are the instructions:

  1. Edit the Page you're looking for and find the Default Field List.
  2. Read over the field list and find the specific field you want to rename.>
  3. Add " AS [new_field_name]" after the field's existing syntax. "new_field_name" should be your new field name. Underscores are translated to spaces by MinistryPlatform.


,Form_Responses.[First_Name] AS [Web_First_Name]

Last Modified: 4/28/2020

Did this article help?
× Thank You for the Feedback