Table field: New records at beginning not at the end

[Anonymous]

Hi Brendan,

I created a form for receipt administration. I am using a table to put in the ingredients. So far so good, but when I entering new records to the table they will be put always on the first line (as 1st record), not at the end like it is in databases always the case. Sorting is not an option as the recipes are having a fixed ingredients order.

Example recipes (entered in original order)
10ml milk
20g cheese
5 eggs

In tabforms it would be in table showed in this order:
5 eggs
20g cheese
10ml milk

Are you able to fix that, so that new table records are showed always at the end of table. I do see the same issue when I creating selection lists; the values are put in the opposite order (1st becomes last, last becomes first).

What I do see as well is that even if I have 2 columns I always getting a 3rd empty column in the list which I am not able to delete. Is this a bug?

My whish for your todo list: manual ordering (via drag&drop) of table lines.

If you need pictures/video, let me know.

Thanks in advance for you help on this,
Tim

[Gartenzwerg]

I had the same problem.
The solution is verry simple.
Add a date created field and sort it in descending or ascending order.
The field self must not be visible in your form. Its only to sort for it.

[Anonymous]

Hi Gartenzwerg,
thank you for confirming the issue. I reported it to be a bug which needs fixing. I have has the same workaround solution. Only thing I am struggling with is how to hide this field.

Tim

[Brendan]

Hi Tim,

On the multi-column list view, click on the X button in the corner and click on the checkmark field to hide it. It won’t hide from the record details view, but you could just drag it to the very bottom of your form so you don’t really have to see it.

But if you’re sorting your records by Ingredient and you have that set to descending order, then yes, the new records will appear at the top until the form is resorted. If you sort them ascending order, then new records will be put at the bottom. You can resort them by clicking on the refresh button at the bottom of the records list view. Or by visiting another form and then clicking back on that form.

Thanks,

Brendan

[Anonymous]

Hi Brendan,

I added a video to show you the issue with the table field and the records in it. Initially I removed any standard sortimg for the table fields in front off as I don‘t want to have my records sort. I just want to have them added always at the end of the table.

During my test it seems the records where put randomly to any position with no sense.

Please have a look into this issue.

Thanks
Tim

[Brendan]

Without any sorting on the records, there’s no guarantee what order they will be returned by the database. It could be random.

So you’ll need to add the Date Created field and sort by that if you want to get a predictable sort ordering.

[Anonymous]

Okay, does not make sense for me, why this is putting randomly in as in normal SQL databases the records are standardly added as last entry. Maybe you can add this standard behaviour for your table field.

Nevertheless I already used this date created time field as workaround.

Thank you so far for your assistance on this issue :-)

Tim

[Author]

Posts