Prepopulate a form

[schacke]

How do I prepopulate a form with selected elements values from the latest post from a user? The copy plugin won't do because I only need a part of the information. It's for a mecical diary.

I have searched the forums without luck. Maybe You can point me in the right direction?

 

[troester]

A new form?
You can use element's "Default". Set to eval and fetch what you need from the database.

If you have a lot of elements to prepopulate it may be easier to use a form php plugin, On=new, Process = onLoad
Select whatever
$formModel->data['table___element']=...;

Or maybe the autofill form plugin (but I don't know if it's possible to get the "latest" record).

 

[schacke]

Thanks! I'm using the autofill to get data from the joined table.

'Default' seems to be the right solution for my question. I've boiled it down to only one element now. But how to I get the information from the latest post from the current user using the 'default'?

 

[troester]

Depends on your setup, how do you determine "last post"?
Assuming you have an element userid and date_time you can

SELECT element FROM your-table WHERE userid = {$my->id} order by date_time desc limit 1

See
http://fabrikar.com/forums/index.php?wiki/common-php-tasks/#select
for the "Joomla" syntax.

 

[schacke]

Pheeew. Managed on the syntax Thanks for pointing me the right way!