Automatically pull a second field to show in Related Records table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 5, 2018   (RSS)

By daniel - December 5, 2018

Hi Jerry,

Just to clarify: You have a title field in both 'accounts' and 'practice_locations', and a related records field in 'accounts' that lists records from 'practice_locations'. You would like the title field in 'practice_locations' to dynamically update to contain the same value as the title field in theĀ  'accounts' record it's related to?

If that is the case, I don't think there's a simple way of achieving this, however, you generally shouldn't need to. The strength of related records fields is that they create a link between two records, such that if you have data from one, you should always be able to get data from the other. The way to do this will depend a bit on the implementation, however; perhaps if you tell me some more specifics about how you are trying to use the title field I can help point you towards a solution.

Thanks,

Daniel
Technical Lead
interactivetools.com

By gkornbluth - December 5, 2018 - edited: December 5, 2018

Hi Daniel,

Just this morning I found an interesting plugin that Dave helped me to create a while back that automatically populates real fields in a target field from the createdBy data in the Accounts table. (sometimes I even remember to look through the recipes in my own CMSB Cookbook.)

http://www.thecmsbcookbook.com

The Cookbook the recipe is called:

AUTOMATICALLY POPULATING FIELDS IN A TARGET TABLE USING THE CREATEDBY FUNCTIONALITY IN CMSB

It seems to answer the question I had. Sorry I didn't remember to update this thread.

Appreciate you're looking at this though.

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php