Solved

html javascript change value of cell based on contents of another cell

Posted on 2013-12-13
6
265 Views
Last Modified: 2013-12-13
Hi,

I have an html table which is populated with data from a source that we can't edit.  So, any changes we make need to be when the page loads using javascript.

Let's say I have a table which contains the following rows

<table id=animals>
 <tr>
  <td class=td1 id=status>Available</td>
  <td class=td1 id=sub>Horse</td>
 </tr>
 <tr>
  <td class=td1 id=status>Available</td>
  <td class=td1 id=sub>Donkey</td>
 </tr>
</table>

 Where the content of the table cell with id=sub is "Donkey", I want the status field to say "unavailable" instead of "available".  If the content of the field is anything other than "Donkey" the status field should remain unchanged.
 
 How can this be achieved with javascript given that it has to work on a row by row basis?
 
 TIA
0
Comment
Question by:yelbow
[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
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:dimmergeek
ID: 39717814
First of all, you cannot have two objects on the same page with the same id.
Secondly, how are you populating your data table?  What data source are you reading from? Why not just set the correct value when you populate the table?
0
 

Author Comment

by:yelbow
ID: 39717825
It comes from a 3rd party app, the only part of it which we can edit is the resulting html.  So, we inherit it like this and can only amend the data at that point.
0
 
LVL 7

Expert Comment

by:dimmergeek
ID: 39717831
Does the third party app create the table for you including the duplicate id?  If so, I would go back to them and let them know they have a basic HTML issue.  With that data structure, how will you tell one id=sub from another to make the change?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 82

Accepted Solution

by:
leakim971 earned 500 total points
ID: 39717838
Test page : http://jsfiddle.net/PAN56/

function changeStatusFor(content_to_search, newStatus) {
    var animals_table = document.getElementById("animals");
    var cells = animals_table.getElementsByTagName("td");
    var number_of_cells = cells.length;
    for(var i=0;i<number_of_cells;i++) {
        var cell = cells[i];
        var cell_content = cell.innerHTML;
        if(cell_content == content_to_search) {
            var row = cell.parentNode;
            var cell_status = row.getElementsByTagName("td")[0];
            cell_status.innerHTML = newStatus; 
        }
    }
}

window.onload = function() {
    changeStatusFor("Donkey","unavailable");
    changeStatusFor("Horse","unbelievailable");
}

Open in new window

0
 

Author Comment

by:yelbow
ID: 39717839
They do, but we can amend that too (though I will mention it to them).

If they had unique IDs would it be possible?

What if the fields had no ID at all?
0
 

Author Closing Comment

by:yelbow
ID: 39717867
Thanks!
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Having worked on larger scale sites, we found out that you are bound to look at more scalable solutions to integrating widgets, code snippets or complete applications and mesh them into functional sites, in any given composition. To share some of…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

717 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