additional fields for checkbox list
2 posts by 2 authors in: Forums > CMS Builder
Last Post: April 9, 2015 (RSS)
By Carbon - April 9, 2015
Hi All,
I want to add additional text fields to checkbox list that is linked to another table.
I have various property listing so I create a multi listing for properties;
I have various tenants but I have the same tenants in multiple properties;
So what I am trying to do is when I create a new property, I linked the tenants tables as a checkbox list, but I need to add two unique field notes "floor area" and "percent" to each checkbox.
Ultimately I when i view each property, I want to see all the tenants, and their unique "floor area" and "percent" occupied for that property.
By gkornbluth - April 9, 2015 - edited: April 9, 2015
Hi Carbon,
One approach that may work, assuming there’s only one tenant per property (I haven't tried to set this for multiple tenants but it should be relatively easy), is to create a new multi-record section editor, called, “Tenants”, with at least one text field for the tenant’s name called “Name”.
Then in your properties section, create 2 new standard, pull down, single value list fields, called “Floor Area” and “Percent Occupied”, in which the list values are a list of floor areas (500, 1000, 1500, 2000, 2000, etc.) and percentages (10, 15, 20, 25, 30, etc.)
Then create a 3rd (single value, mult-value?) pull down list field in your “Properties” section called “Tenants” and set the list options to “get options from database (advanced)”, and choose the“Tenants” section as the table name , set the option values as the ‘num’ field and the option labels as the ‘name’ field.
Create a record for each tenant in the "Tenants" section.
Choose the appropriate value for the fields in each" Properties" record.
Then in your viewer, those fields will display the chosen values for each property record displayed.
Hope that's enough to get you started.
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php