Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Pulling and updating data from DB

Posted on 2013-06-11
4
Medium Priority
?
436 Views
Last Modified: 2013-06-26
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
Comment
Question by:Modifier1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:oliverpolden
ID: 39238377
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
 

Author Comment

by:Modifier1000
ID: 39238513
Thank you, maybe my diagram will help better explain.
Process-of-pulling-data.png
0
 
LVL 10

Accepted Solution

by:
oliverpolden earned 2000 total points
ID: 39238785
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
 

Author Closing Comment

by:Modifier1000
ID: 39279460
Thank you!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
In this blog, I will share you some basic tips for content marketing and to rank your website on Google.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question