linked colums

[ebonydabster]

Hi experts.

So i have list 1 with data around 7 colums and 950 rows

now, i have another list 3 colums and 100 rows.

i want to add new column. In this column i want that data will be add automatically from list 1.

i mean for example, how to link data between two tables. What i want to get:

list 1 (database) columns:

Country City Short Name of institute full name of institute

Armenia Yerevan YSU YSU | Yerevan State University |http://www.ysu.am/

Azerbaijan Baku IP ANAS IP ANAS | Institute of Physics of the Azerbaijan National Academy of Sciences | http://www.physics.gov.az/

Australia Sydney Univ. Univ. | University of Sydney | http://sydney.edu.au/

Great Britain Darhem Univ. Univ. | Durham University | http://www.dur.ac.uk/
....
950

list 2

Country City Institute or laboratory (new column - Full name)
Armenia Yerevan YSU YSU | Yerevan State University |http://www.ysu.am/

Azerbaijan Baku IP ANAS IP ANAS | Institute of Physics of the Azerbaijan
Australia Sydney Univ. Univ. | University of Sydney | http://sydney.edu.au/
Great Britain Darhem Univ. ???

..... ..... ......


How to do that to automatically fill new column, how can fabrik find values and insert this values from right data value. (because the short name of institute is not unique, and program must search in what city and country this institute is located and then add right full name)

I know how to do it in Microsoft Excel - but wants on site.

And when i add a new row in list2

Belarus Minsk BSU ???

Program must automatically fill column 4 with data from list 1.


So the question is how to link values between lists

Now i have 84 differerent lists like list 2 with 150 rows avarage. All of this lists takes data from database (list 1)
Thanks.

 

[troester]

Not sure what you are trying to do.
Excel is not a database.

With Fabrik/MySQL your records have/need an additional id (primary key) column (integer, autoincrement).
With this id you have a unique identifier.

If you have one "big" list (1)(database table containing all the data) you don't need additional tables with copied data if you want to show only some of the columns or records.
You can define
which elements/columns to show e.g. via different menu items or element access levels
which records to show via prefilters (per menu item, per access level)

You can define multiple Fabrik lists pointing to the same underlying database table
etc.

If you need to reference data from list1 in other lists (using different database tables) you can use databasejoin element.

If you really need to copy data between different tables you can use autofill form plugin, upsert form plugin or a php form plugin with your own code.