By DQuimper on

Hello,
I would need an input, because I have no clue as to where I should look and even what I should look for.

I would like to have multiple matrixes set up sort that the user can fill data into them. Here is exactly what I would need:

1st - The user fills in: idvalue_zc | value_zc_desc | value_zc_explicit
2nd - The user fills in: idvalue_za | value_za_desc | value_za_explicit

and, 3rd : The user has to be able to see the list of all idvalue_zc (the names of all Competency Zones) AND one idvalue_za at the time (1 business zone at the time) AND edit | valueprop | (the value proposition for each pairs :

eg. :

za1 WITH zc1 = valueprop
za1 WITH zc2 = valueprop
za1 WITH zc3 = valueprop
za2 WITH zc1 = valueprop
za2 WITH zc2 = valueprop

and so on.

Thank you in advance for any help you can provide me: i really have no clue where should I look or what I'm looking for: should I continue to play with _fields, try to develop a module,? Any suggestions would be taken. Best, Daniel.

⋅ Categories: Drupal 7.x

Comments

steeph’s picture

steeph commented

You can create a content type with a group of fields and another content type with a node reference field.

The field collection module provides this functionality in a way that is probably more suitable for a matrix-like field. There are similar modules, but all have their disadvantages. I can't recommend Field collection for nodes with many values (rows). The Multifield moduel apparently was started to create a better solution for this. But I haven't used it, yet. And then there is the Matrix field module, which I've just found.

DQuimper’s picture

DQuimper commented

Thank you so much for following-up on me that quick; I desperately needed a direction into which I could look for. I might have been better advice to look into modules and stuff more thoughtfully but I really got lost among my options. I'll get back to this post, as soon as a can try one of those directions you pointed me at - I don't think that there will be that many rows, overall. Talk to you, please accept my best regards. Daniel.

steeph’s picture

steeph commented

BTW, I'm not sure I understood how the fields/values should be displayed. You most likely want to use Views for that if you don't just want to display one node at a time.

And for editing only one or two rows, not the whole table: I don't know if any of the modules can do this. You could of course hide the fields that should not show up on the edit screen. But they could still be edited if the user knows how. With the first solution, two content types and a reference field, it would be possible with an additional module that adds/removes permissions on a per-field basis.

DQuimper’s picture

DQuimper commented

Basically, I'd like to computerized / drupalized this process:

http://www.danielquimper.com/francais/espaceclients/ressources/exercices...

Each purple bands, are steps, the first three being those discussed in my original posts. The 3rd, need to recall / shows previously entered variables - those should also be editable by the user (in step one and two). I need the system / module / sql / fields / whatever to let the use enter multiple (probably in between 3 and 20 max) as field_zc (first step, competency zones) , and then field_za (probably less numerous than zc) on the second step (business zones), and then, have a some sort of view produces where it is possible for the user to edit a field_propvalue (this is, a value proposition for each pairings, knowing that each ZA (business zone) can be paired with any ZC (competency zones). eg:

ZA1 and ZC1 | propvalue
ZA1 and ZC2 | propvalue
ZA2 and ZC1 | propvalue
ZA2 and ZC2 | propvalue, and so on.

Many thanks for your advices and quick follow-up; I should be able to run / test some of those ideas before the week-end.

DQuimper’s picture

DQuimper commented

Real serious thinking and youtube make me believe that Automatic Nodetitles Module + Token + Multiple fields is the mix I should try. Many thanks once again. Daniel.

DQuimper’s picture

DQuimper commented

Just to let know that I probably will have a minima-viable version by next Wednesday. Currently planning on using autonode, multifield and token. Have discovered ECK Entity creation kit, which is kind of fun.