Related Records Field type
2 posts by 2 authors in: Forums > CMS Builder
Last Post: May 18, 2011 (RSS)
By rentittoday - May 18, 2011
Hello!
We currently use the "related records" field type in CMS to display a users listings right in their their user account section, which is great!
We use this coding in the MySql where clause
However, we have 46 different tables that this info is being pulled from which means we have 46 different fields. And usually a user only has listings in 1 or 2 of the tables, with the rest being blank. Is there a way to only display the related records field if there is information in it?
Say we have 26 related records fields, pulling information from tables named a, b, c, .....z.
User Joe has listings in tables a and b. But in his account all 26 fields show up, but only fields a and b have listings in there, leaving 24 empty fields that take up space.
Can we just display the fields that Joe has listings in, in this example, a and b.
Thank you for your help!
We currently use the "related records" field type in CMS to display a users listings right in their their user account section, which is great!
We use this coding in the MySql where clause
createdByUserNum='<?php echo mysql_escape(@$_REQUEST['num']) ?>'
However, we have 46 different tables that this info is being pulled from which means we have 46 different fields. And usually a user only has listings in 1 or 2 of the tables, with the rest being blank. Is there a way to only display the related records field if there is information in it?
Say we have 26 related records fields, pulling information from tables named a, b, c, .....z.
User Joe has listings in tables a and b. But in his account all 26 fields show up, but only fields a and b have listings in there, leaving 24 empty fields that take up space.
Can we just display the fields that Joe has listings in, in this example, a and b.
Thank you for your help!
Jason Glass
Re: [rentittoday] Related Records Field type
By Jason - May 18, 2011
Hi,
Currently, there isn't a way to hide empty related Records fields, however, we could accomplish this with a custom plugin. If you're interested in this, please email consulting@interactivetools.com and we can go over some options.
Hope this helps
Currently, there isn't a way to hide empty related Records fields, however, we could accomplish this with a custom plugin. If you're interested in this, please email consulting@interactivetools.com and we can go over some options.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/