Insert new record at top of list

[[email protected]]

Hi,

I am adding new records to a list using a formview. I would like the new records to be inserted at the top of the list. By default, they get added to the bottom of the list.

I have tried using the method "formviewrow" and setting the row number to 0 before committing the new record to the list. Although it places the new record at the top of the list, it replaces the existing record at the top of the list, rather than pushing the existing rows down and inserting the new row.

Any ideas on how I could do this ?

cheers,
Greg

[lgrupido]

Re: Insert new record at top of list

If the list is sorted in the right order, you can just refresh or re-sort the list after adding a new record. Then it will fall wherever it sorts to. If sorted by the ID or created date/time (desc) it will be at the top.

Otherwise, if this is not an option for the list, you might send in a new feature request. Adding to the top is an available on a Grid.

[iRadiate]

Re: Insert new record at top of list

See if this helps as well .. https://forum.alphasoftware.com/show...highlight=list

[[email protected]]

Re: Insert new record at top of list

I looked at the post mentioned by 'iRadiate'. I ran into two problems:

1. The last post entered by Simone mentions problems with child lists. I also have the same problem. Once I specify to transform the 'Id' field to a number in the list properties (Fields->Transform Data Type->ToNumberSimple), the child list no longer links up to the parent list properly. I guess its due to the fact I'm using the 'Id' field as the linking field between the child and parent.
2. If I add a new record when I'm offline, an 'Id' is not assigned until I am back online and do a 'sync'. In this scenario, the new record is placed at the bottom of the list.

Greg

[[email protected]]

Re: Insert new record at top of list

Re point 1, I found a section in the List Properties called "Client-side Filter/Order, and Grouping". The"Order" property lets you setup an expression which will determine the lists order. If I enter:
Id|Number|Desc
then the list will order in descending order based on the Id field.
Regarding point 2, the only solution I can find is to set the selected row in the list to the last row using the <listObj>.setValue method. I need to use a setTimeout to specify a small delay (~150ms), which causes a slight flicker on the formview (since when I save the formview it wants to set the selected row back to 0), then when I set the selected row back to the last row, I can temporarily see the data in the form for row 0.

greg

[Davidk]

Re: Insert new record at top of list

You should post the version/build you're using.

You could do an end run around the FormView and look after updating the List yourself. I don't know what .formViewCommit() is doing specifically... but it must be running some kind of .addTableRow() against the List Control.

.addTableRow() offers the options you're looking for. What you'll need to do is set some kind of flag to indicate that you're in an "add" state... not an update.

In the FormView Save code you could do something like this...

var result = {dialog.object}.formViewValidate('{form.id}');
//only commit if there are no form validation errors
if(result){
	var vb = {dialog.object}.formViewGetViewBox('FORMVIEW_1');
	var vbData = vb.data;
	
	var listObj = {dialog.object}.getControl('list');
	var ops = {};
	ops.setFocusToTargetRow = true;
	ops.insertRow = true;
	ops.insertPosition = 0;
	listObj.addTableRow(vbData,ops);
}

Here we get the FormView ViewBox object. Then we get the data in that object... the data you just created as a new record.
Then we get the List Control object.
The options available for .addTableRow() include the position where you want the data. Set it to zero and you're at the top.

[[email protected]]

Re: Insert new record at top of list

Thanks David. Will try it and let you know.