Advise on how to syntax to display calc data in a dropdown menu for selection

[molcomp]

Hi,

My data from calc field are currently display in a text list

$rows = $myDb->loadObjectList();
$list = array();
foreach ($rows as $row)

{
$list[] = "<li>" . $row->subactivity_name . "</li>";
}


I need to list the data in a dropdown so I can select an option. I tried some php coding but obviously I am missing some syntax in terms of fabrik or joomla for the calc field.

Any advise or direction in resolving it is much appreciated.

Thanks
Alex

 

[troester]

Instead of a calc use a dropdown element with "Eval populate"

Dropdown element

Settings Sub Elements Add - Press this to add in a new drop down option Value - The value that is stored in the database if the drop down option is selected Label - The label that appears next to the drop down option. Equally this label is shown in the table view rather than the recorded...

fabrikar.com

 

[molcomp]

I figured it our with the dropdown syntax but I will try your suggestion as well.

Thank you troester
Alex

 

[molcomp]

Hello @troester

I did manage to the above with the calc field but I am having some issues with it CSS so I thought trying your suggetion with the dropdown. However I am having some syntax error with the data-where sql clause. Can you please tell me what's wrong with the following syntax in data-where clause under dropdown menu. As far as I could understand from wiki and forum question this should be it but its not since I get an error.

WHERE {thistable}.`subactivity_name`
IN
(
select array('subactivity.subactivity_name') from 'subactivity'
join 'INNER', 'intemgroup1 ON intemgroup1.subactivity_name=subactivity.id'
join 'INNER', 'projects ON projects.id=intemgroup1.project_name'
join 'INNER', 'activities ON activities.id=intemgroup1.activity_name'
where 'projects.project_name = ' . $myDb->quote('{overlapping___project_1}')
where 'activities.activity_name = ' . $myDb->quote('{overlapping___activity_1}')
)

Following is my query in the calc field that works.
$myQuery
->select(array('subactivity.subactivity_name'))
->from('subactivity')
->join('INNER', 'intemgroup1 ON intemgroup1.subactivity_name=subactivity.id')
->join('INNER', 'projects ON projects.id=intemgroup1.project_name')
->join('INNER', 'activities ON activities.id=intemgroup1.activity_name')
->where('projects.project_name = ' . $myDb->quote('{overlapping___project_1}') )
->where('activities.activity_name = ' . $myDb->quote('{overlapping___activity_1}'));

Thank you very much @troester if you can help or point to direction how to resolve it.

Alex