Forums

Hi,
I am getting familiar with Joomla 2.5.1 and Chronoforms 4.0 RC3.11.
A big feature I like is the ability to load and edit records.

The tutorial document is great for getting the hang of it and to quickly load entire forms from a given table. However I want to restrict the data that is loaded in the multi-form so that it will only be a database query to identify specific users.

For example, the data in the cf_user_id should be used to restict the multi-loader so that it only loads table entries related to the current logged-in user. This would be instead of using a complete table load.

How is this achieved? I assume it is from a query that can be set somewhere that passes the cf_user_id value. just can't find it!

Thanks,

Brendan

SOLVED!
And surprisingly, by me!

In the "Multi DB Record Loader" config I added the following code in the advanced tab:

<?PHP  $user = JFactory::getUser(); ?>
cf_user_id = <?PHP  echo $user->id; ?>

First line helps declare user table values, and I matched it up with my editable table using that query.

Watch out Bob!!!

Hi Brendan,

Looks good to me, well done !!

Bob