Hi,

I have a form which is submitted by admins concerning current joomla users.

There is a dropdown which is a lookup from the _users table in joomla which returns the user's name and ID.

On the form submit, i want the submission to be as if the user has submitted it themselves, so that in the front-end, the user can use the directory view to see their "own" submission.

I tried using the mapping function on form options, but this just creates another submission in the table rather than using the existing one.

Any suggestions?

Thanks,

Hello,

You can find an example on this topic here. More precisely the "Database mappings" section explaining how such a mapping would be configured (in your case, replace the {student:value} placeholder with the exact placeholder of your dropdown that returns the user's ID).

Great, thank you for that!

The only issue with the user lookup is that now on the directory listing view, the data is showing the user ID rather than the student's name, any tips on how to change this? I know you can change the layout of the details form easily, but can't see a way to edit the directory.

Hello,

Only the value is normally shown for your field, in this case the ID, and not the label. For the label itself, the name, you can try adding an extra field in your form like a hidden field and pass the dropdown label selection within your hidden field value (you can use JavaScript for this).

Edit your dropdown > Attributes > Additional Attributes area > add:Replace myHiddenFieldName with the exact name you've given to your hidden field (case sensitive). Eventually in your Manage Directory configuration, exclude the dropdown from showing and include the hidden field instead.