Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

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.
0
Modifier1000
Asked:
Modifier1000
  • 2
  • 2
1 Solution
 
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
 
oliverpoldenCommented:
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
 
Modifier1000Author Commented:
Thank you!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now