I made a BreezingForms form and I have a select list to pull a users from the Joomla database. Instead of using the actual name, I want to use the ID so I can use it further in another SQL call. Can an SQL be used in the item wrap field to change the id to name?
You can try to use the following code in order to get user name equal to the value of that field. Put the code in Item wrap code of your view:
<?php $db = JFactory::getDBO(); $sql = "SELECT name FROM #__users WHERE id =" . $db->quote($value); $db->setQuery($sql); $value = $db->loadResult(); ?>