View fails to reference multiple nodes in CCK "nodereference field"

Hello yched, please see the attahced view and field. Please also see the below construction process of this demonstration.

Task: Provide user an opportunity to specify the page color when add a "story". For example, "node/add/story/14" will lead to the story-adding form showing the field "page color" optioned with the colours of the page #14.

Result: Field "page color" on "node/add/story/14" only show single allowed value to choose from, while the page #14 has four different colours. That being said, the view "get_color_of_page" function well in preview.

The following is what I did:

1. Create field "field_color" in content type of page, and define multiple colours as allowed values.
2. Create view "get_color_of_page". Under default display,
   • add "Content: color" as the field
   • add "Node: nid" as the argument, set "Action to take if argument is not present" is to "Provide default argument (PHP code)", and enter code:
     return arg(3);
3. create nodereference field "field_page_color" in content type of story, set to use the view "get_color_of_page", leave the argument blank (because it will retrieve its argument from the 4th part of the url)
4. creat a page, select four colors, and the uid is 14, for example
5. go to "node/add/story/14", and you will see at the there is only one color to choose from at the "page color" field. What's more, the title of node #14 has been automatically added besides the only color value, something like: "grey - Title: Page 1"

Hello yched,

I agree with you that using views in such an application is a way unneccessarily long. The reason why I tried it is that I had no clue on how to write PHP codes to load values from other nodes. Enlighted by your previous comment,

1. I added to Story content an additional integer field "field_page_id" to store the node id that "arg(3)" retrieved from the url.
2. I set up the code for "field_page_id" :
   return array(0 => array('value' => arg(3)),);
3. I deleted the nodereference field "field_page_color", and created the new text-select field "field_page_color"

Then I need to write codes in the "Allowed values" for "field_page_color", and the code should do following things on node creation form "node/add/story/*" (the * is the nid of a "page"):

1. like you said, "grab" the value of "field_page_id" (from current page) that has been automatically filled.
2. load the node of grabbed nid
3. retrieve the values of $node->field_color

However, I tried dozens of times to do above jobs, I tried both node_load() and content_load(), but none of them worked. The key issue is I don't know how to grab the value of "field_page_id" from current page. I would further appreciate if you can kindly instruct me the complete code. Please see below one of wrong examples that I tried:

$pass_content = content_load($node->nid);
$pass_id = $pass_content->field_page_id;
$node = node_load(array('nid' => $pass_id));
$color = array();
$color = $node->field_color;
return array (0 => $color);

The result of above code is "field_page_color" has no allowed value at all.


The another question that I need your kind instruction is, in case the "field_color" on PAGE node is a nodereference field referring to multiple COLOR nodes, which means the above code will only return the nids of the Color nodes, how to transform these nids into an array of node titles (that we can return as fields' allowed values?)

I have been heading around within above issues for weeks, and I really appreciate your kind help!

Thank you very much!

Sincerely,
Michael