insert row between existing rows in table

E

ebonydabster

Member
Hi Experts!!!

so i have table 5 columns 250 rows filled with data.

How to add row for example beetwen 5 and 6 rows and the other data then automatically shifts and then it will be 251 rows total

Thanks.
 
Every row has a Unique ID-number, so if you want to add a record after 5 you can do that on Excell by exporting the table to CSV and the ID numbers manually.

But if you have a database join in another table to this table that u want to change, then you should not change the ID of this table, unless you also change all your db_joins.
 
lousyfool said:
Where existing or newly added rows show depends entirely on the list's sort order you choose.
http://fabrikar.com/forums/index.php?wiki/list-edit/#data-page
http://fabrikar.com/forums/index.php?wiki/list-module/
http://fabrikar.com/forums/index.php?wiki/sorting-data/

To manually order a list per drag & drop you may want to look at the "Order list plugin":
http://fabrikar.com/forums/index.php?wiki/order-list-plugin/
Click to expand...

So i use drag and drop.

then when i update page - all that moved rows stay at that position that they were - so nothings changed. May be it need some additional setups in settings??
 
If you have an "order" element you must order your list with this element (in list settings "Data" "order by")
 
troester said:
If you have an "order" element you must order your list with this element (in list settings "Data" "order by")
Click to expand...
yes i order by order element but fabrik list do not automatically increase sorting like Excel . than i got a problem

so as i said before i have 5 colums 250 rows.

i order by order element - 1st column. and he order only my 1st column alphabetically and other columns not order within the 1st. --> than i got only mixed table without needed compliance between columns (
 
Fabrik is working with MySQL database, not Excel.
It's ordering (sorting) the complete records (not like Excel which may mix up all data)
Not sure what you have done.
You must add an extra field as order element. You can't use the primary key (ususally the id element, type=internal id) of the database table.
 
troester said:
Fabrik is working with MySQL database, not Excel.
It's ordering (sorting) the complete records (not like Excel which may mix up all data)
Not sure what you have done.
You must add an extra field as order element. You can't use the primary key (ususally the id element, type=internal id) of the database table.
Click to expand...
as i right understand i add 6th column (field) in which i sort for example

NAMe order
name1 ... 1
name2 ... 3
name3 ... 2

than if i order list by plugin by order element - than he do it automatically and sort and i will get this?

NAMe order
name1 ... 1
name3 ... 2
name2 ... 3

ok but what shall i do if other user adding rows than he would not fill that order element - because he wants only fill 5 colums without filling order element because this column must be hide
 
You must log in or register to reply here.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 95 (members: 1, guests: 94)
    Back
    Top