Table collects data

[albertotactik]

Good morning
How could you get that in the "tabla riesgos"
It will store the data in the "ficha proceso" table
And it will also store the data from the "weakness" table and the "threat" table
thank you
I attach an image ...

 

[albertotactik]

Good morning
How could you get that in the "tabla riesgos"
It will store the data in the "ficha proceso" table
And it will also store the data from the "weakness" table and the "threat" table
thank you
I attach an image ...

I see that with a databasejoin… I can choose value from the procesos table…
But I would like it to automatically add some values from the process table to the riesgos table
thank you

 

[tghounsell]

Configuring the list to have the right database joins should create a single table that presents values from your various tables and stores them in the correct tables. I don't think you have any need to duplicate the values of one table into another table.

 

[albertotactik]

Configuring the list to have the right database joins should create a single table that presents values from your various tables and stores them in the correct tables. I don't think you have any need to duplicate the values of one table into another table.

ok ...
I will try to find join information
thank you very much

 

[tghounsell]

There is a database join element, but what you are looking for is the join options inside the list configuration. After clicking a list name, click data on the left-side menu then joins from the tabs that appear.

 

[albertotactik]

There is a database join element, but what you are looking for is the join options inside the list configuration. After clicking a list name, click data on the left-side menu then joins from the tabs that appear.

Good morning
I decided to do it by "join" but I just did not see results. (it's my first time)
I've tried many ways… and I can't succeed.
Attached screenshot… to see if you can detect the possible error.
Summary
There is a "PROCESO" table in which there is a value called "ficha_proceso___riesgos”
to be shown in table “RIESGOS”
I've tried countless combinations… and nothing.
It is clear that I have my limitations at the moment.
Thank you for your attention

 

[troester]

Looking at your table definitions in your first screenshot:
If you are using Fabrik standards and want to have list joins working correctly the "id" element/database table column in Fabrik must be a primary key, integer, autoincrement.
So ids like D01, R01 etc won't do.

If you have set up correct primary keys - e.g. 'Id Riesgo' in 'Tabla Riesgos' as Fabrik internalid element
and correct foreign keys - e.g. 'Id Riesgo' in Fiecha proceso' as Fabrik field element, type integer or Fabrik databasejoin element (joining to 'Tabla Riesgos' with Value = id[recommended]
you can add a list join

 

[albertotactik]

I will attach an image of a simple example of the 3 tables
and list join screen
to make it clearer ... I imagine that little by little I will understand.
Thanks for your patience

in table A introduces the value "chemical" in the element "risks"
in table B enter the value "decomposition" in the element "threat"
Table C will show (automatically) separately the data "risks" + "threat"
in table C there will be an element "gravity" this value can be entered manually
in table C there will be a "risk level" element to which a value of 1 to 10 can be entered manually

I understand that there must be 2 database joins that point to tables A and B ... is that so ??
it is necessary to do apart from the 2 databasejoin add a foreign key (I use NAVICAT program) for database visualization…

if there is any information you need ... let me know.
even if it costs me because of my limitations ... I want to understand it and get it
so far and thanks

 

[albertotactik]

Am I on the right track ??

 

[troester]

It's not clear to me what you want to achieve at all.

As I said:

• a database table used in Fabrik must have a primary key column, integer, autoincrement (if the table was created via Fabrik this is the "id" element, Fabrik element type = "internalid")
• in a list join in Fabrik one "leg" must be a primary key. So the join must go from table1.id to table2.some-foreign-key or it must go from table1.some-foreign-key to table2.id
  • So no, you can't join from risks to threads, your join "screenshot" is impossible, in list riesgos you can only join from riesgos
    
  • In your list riesgos you can e.g. add two joins: from riesgos.risks to procesos.id and from riesgos.threat to amenaza.id

You can add two databasejoin elements to your riesgos list, one pointing to procesos with Value=id[recommended], Label = risks (or some Concat label),
one pointing to amenaza with Value=id[recommended], Label = thread (or some Concat label)
The databasejoins are foreign keys.

But these are only "technical" advises, it depends totally on what you want.

Maybe have a look at
https://fabrikar.com/forums/index.php?wiki/design-strategy/
https://fabrikar.com/forums/index.php?wiki/joining-list-and-form-data/
https://fabrikar.com/forums/index.php?wiki/list-joins/
https://fabrikar.com/forums/index.php?wiki/autofill-form-plugin/

 

[albertotactik]

It's not clear to me what you want to achieve at all.

As I said:

• a database table used in Fabrik must have a primary key column, integer, autoincrement (if the table was created via Fabrik this is the "id" element, Fabrik element type = "internalid")
• in a list join in Fabrik one "leg" must be a primary key. So the join must go from table1.id to table2.some-foreign-key or it must go from table1.some-foreign-key to table2.id
  • So no, you can't join from risks to threads, your join "screenshot" is impossible, in list riesgos you can only join from riesgos
    
  • In your list riesgos you can e.g. add two joins: from riesgos.risks to procesos.id and from riesgos.threat to amenaza.id

You can add two databasejoin elements to your riesgos list, one pointing to procesos with Value=id[recommended], Label = risks (or some Concat label),
one pointing to amenaza with Value=id[recommended], Label = thread (or some Concat label)
The databasejoins are foreign keys.

But these are only "technical" advises, it depends totally on what you want.

Maybe have a look at
https://fabrikar.com/forums/index.php?wiki/design-strategy/
https://fabrikar.com/forums/index.php?wiki/joining-list-and-form-data/
https://fabrikar.com/forums/index.php?wiki/list-joins/
https://fabrikar.com/forums/index.php?wiki/autofill-form-plugin/

Good again
I'll go step by step ... see if I can do it
A question
Primary key = foreign key?
but it's the same ... how do I create a foreign key from fabrik?
In the 3 tables there is a numeric factory ID (primary key) attached to the image.

the foreign key must be in table C (risk and theart elements) orange in image. I understand that it doesn't have to be a databasejoin ...?
Thank you for your understanding and patience.

 

[troester]

Primary key = foreign key?

NO!!

 

[albertotactik]

NO!!

Ok primary key is not foreign key (intuition)
So I understand that with a databasejoin plugin (it would already create foreign key)?
Is that so?
Thank you and sorry for my thick mind.

 

[albertotactik]

very good.
I will try to read and learn about the links you sent me.
I will also look to see if I see a simple example on the forum or wiki ...

I think I need to clarify ...

thank you very much for everything ...
and as soon as I clarify ... I try to resume the subject.