Pulling and updating data from DB

Hello Drupal Experts,

How can I use data in content types from another content type and have that data updated?  I have one content type that I would enter a float ($1,000.00).

I would like for other content types to get that float value and then perform calculations within an other content type. Once saved, the ($1,000) is changed and can be used elsewhere...if needed.

Content Type: Enter Money
Float textfield: (moneyEntered=$1000)

Content Type :  Adjust Money
Float textfield:  (from moneyEntered)
Float textfield:  (moneyAdjusted=$500)

So now the moneyEntered value=$1500 and it can be used in other content types as needed.

Thank for any help.
Modifier1000Asked:
Who is Participating?
 
oliverpoldenConnect With a Mentor Commented:
That doesn't describe what you are trying to achieve. That describes a possible solution.

Why do you have separate content types for account adjustments and account balance and why do you need to update different nodes?

Have you come across the views module? It's very versatile and allows you view and manipulate multiple nodes in different ways:
https://drupal.org/project/views

If however that is what you really need to do then you will probably need to create your own module to act on nodes when they are saved and updated.

Here's some info about how to react to node actions:
https://api.drupal.org/api/drupal/modules!node!node.api.php/function/hook_node_presave/7
https://api.drupal.org/api/drupal/modules!node!node.api.php/function/hook_node_submit/7
https://api.drupal.org/api/drupal/modules!node!node.api.php/function/hook_node_update/7

Oliver
0
 
oliverpoldenCommented:
Hmmm, strange stuff you're doing there.

I don't think I can solve that for you but the computed field module may be of use:
https://drupal.org/project/computed_field

Also, I'm not sure of your end goal but maybe a more real time calculation would be a better idea, i.e. take the same fields from each node and do a calculation on them using the views calc module:
https://drupal.org/project/views_calc

Perhaps a single node for all this and the field_permissions module?
https://drupal.org/project/field_permissions

If you let me know your higher level goal, maybe I can suggest a better approach.

Oliver
0
 
Modifier1000Author Commented:
Thank you, maybe my diagram will help better explain.
Process-of-pulling-data.png
0
 
Modifier1000Author Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.