relatedRecords special fieldname

7 posts by 4 authors in: Forums > CMS Builder
Last Post: November 9, 2017   (RSS)

By Deborah - October 13, 2017

I've just discovered the relatedRecords special fieldname and am using it with a product table set up with a category table managed via the relatedRecords field - very useful!

My questions are:

1) Are there other uses for this field inside the editor?

2) Does this field have any usage on the generated web pages?

3) Are there other special fieldnames not listed in the online documentation? I don't want to miss any opportunities.


By Dave - October 13, 2017

Hi Deborah, 

In reverse order: 

3) Are there other special fieldnames not listed in the online documentation? I don't want to miss any opportunities.

There are a few more undocumented ones, but they're mostly for internal use and may change.  (eg: the accounts "accessList" field has a special fieldtype of "accessList").  

The best way to familiarize yourself with all the options is to go through all the field types and options in the field editor.  And let us know any questions!

2) Does this field have any usage on the generated web pages?

No, it's just for seeing related records in the database from within the CMS.

1) Are there other uses for this field inside the editor?

Yes, we use it a lot any time we want to show related records, examples: 

  • Within a single section, you could show other records with the same field value.  eg: for a store record, other stores in this city
  • With related data, you can link to the parent and/or child records
  • You can set it up to add child records and return to the parent record.  eg: company record could have a list of related "employees" with an add button that prepopulated the "company num" when you click to add a new employee

It's basically just a way to get a list of records.  So anytime you want to show data from another section it can be helpful.

Let me know any other questions!

Dave Edis - Senior Developer

By Zicky - November 2, 2017

Hey Deborah & Dave,

I posted a topic that touches on Deborah's questions. Figured I share my question and a link to my topic here, since they are so closely related, and Deborah may find this idea useful.

I'm using Related Records for Notes that get assigned into a Student's record.

What I'm trying to do is auto-assigning the Student ID# (record num) of a parent record and apply to the child (related record) Notes Student ID# field when creating the related record. Any suggestions on how to achieve?

Thanks, Zicky

By Toledoh - November 2, 2017

Hi All.

Zick: There is a way to do that - something about if the related field is fieldName, then you use fieldNameNum and it automatically works... but I always get confused with that so maybe someone else can jump in :)

Deborah: I also use relatedRecords to give my admin users the ability to build out their own page structure...

I use a category section to build the page navigation, and for each page I have fields for the masthead, main content, SEO aspects etc.

I then have a relatedRecords that allows users to "Add / Edit / Delete" panels (from another table).

Each "Panel" has the ability to choose things like background colour, layout (text only, image and text or text and image, carousel, etc) and from that (using is displays the appropriate fields for that panel.  

In addition, I have pre-built modules that I add a "includes" here.  so a panel may include an Image Gallery, or News, or Blog etc.

I've also got a custom plugin that extends the related fields system a bit so I can re-order those panels within the parent record.  But it's built in with a number of of things so it's not something I can share.  I'm sure the interactivetools could offer custom development if it's something you would need.

Hope that helps.

Tim (

By Deborah - November 6, 2017

Hi, All.

Tim, I'm intrigued by your setup for allowing users to build out their own page structure. I can't get my head around what you described entirely, but will give it some thought. Thanks for your insight on this topic and if you have any examples you'd like to share, please do.

~ Deborah

By Deborah - November 9, 2017

Hi, Zicky.

Thank you for the examples and nicely detailed explanation! I have a much better understanding now of how relatedRecords can connect with section editors and can foresee many possibilities for its use.

Thanks again! ~ Deborah