last updated data as default value

[hanees]

I have a form with a field. I need to load last updated data to that field as default value, each time form submitted. How to do it?

 

[troester]

What do you mean with "last updated data"?
In the field's default value (running on new records) you can include whatever you want with Eval= Yes and php code.
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks

 

[hanees]

my form got 2 fields.
1. ID
2. Name

Stored data as folows

ID Name
001 John
002 Alan
oo3 Michel

What i want is when i update a new record, the last updated data values (003 Michel) should automatically load in my form as default values in respective fields.

 

[cheesegrits]

Eval'ed default of something like ...

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('name')->from('yourtable')->order('id DESC)->setLimit('1');
$db->setQuery($query);
return $db->loadResult();

When you say "ID", is that the primary key of your list, or some other ID? If it's the PK, then you can't default it to anything, as it's only ever going to get a value automatically when the new record is saved.

-- hugh

 

[hanees]

Thanks it is working for only field. but not working for dropdown box and radio buttons. any changes in the code should be done for
those?

 

[cheesegrits]

Try loadColumn() instead of loadResult();

-- hugh

 

[hanees]

Fantastic! Its working. Thank you so much hugh...

 

[cheesegrits]

Just to explain that one ... loadResult() only loads a single field from your query (the first field of the first returned row). Which is fine for single value elements. But things like dropdowns are multiple value elements (basically any element type with the concept of 'value' and 'label' (joins, dropdowns, radios, checkbox, etc). So you need to return the array of values you want. The loadColumn() method returns an array of the first field from all returned rows.

-- hugh

 

[hanees]

Ok. Thank you so much.