how to change multiple rows in a table at the same time.

ironDanironDan Member Posts: 148
edited July 2012 in Working with GS (Mac)
I have a TABLE with 96 ROWS and I need to change the value of an Integer COLUMN in ALL 96 ROWS at the same time when called upon. I have tried using the TableRowCount(table) in the expression editor in the ChangeTableValues but It's not changing anything. Im not sure if thats the right way and Im missing something or Im just way off or its not possible??

Also, any help guiding me in the right direction about preforming search loops in tables would be the cherry on top ;)

Thanks in advance
Dan

Best Answers

  • MotherHooseMotherHoose Posts: 2,456
    Accepted Answer
    @ironDan
    difficult not knowing when… why… and what the changes in the columnValues should be

    here is one how-to:

    demo: http://www.mediafire.com/?etddodrodd19y49

    this might work for you … updates the values of 96 columns as fast as I could get it to go
    just added 10 to the values
    … you could add/subtract/multiply/divide by another attribute

    image MH
  • MotherHooseMotherHoose Posts: 2,456
    Accepted Answer
    @ironDan … glad that worked!

    in general remember: you are smarter than a computer
    though a computer will compute numbers/respond to changes faster than you
    a computer does nothing till the OS or you tell it to do something

    tell it when to do it … set-up the attributes as conditions to trigger
    then tell it what to do!

    image MH

Answers

  • MarkOnTheIronMarkOnTheIron Member Posts: 1,447
    If you simply want to quickly delete everything in a table create an identical table to that one but leave all the cells blank. Then use the "Copy Table" behavior to copy the blank table to the written table and you're good to go.

  • ironDanironDan Member Posts: 148
    Thanks for the quick reply @MarkOnTheIron but Im looking to only update the value of column #6 in ALL 96 ROWs at the same time.
  • tenrdrmertenrdrmer Member, Sous Chef, Senior Sous-Chef Posts: 9,934
    Unfortunatly there is not way to update cells like that. I just did a deal where it ran a change value fr every cell I needed changed. Though MarkonTheIrons suggestion would have beed great since I was just setting everything that had been saved back to 0
  • MarkOnTheIronMarkOnTheIron Member Posts: 1,447
    edited July 2012
    Yeah if you want to reset the value of only one column you will have to use 96(!) Change Table Value behaviors.

    I hope GS will add the ability to change more rows at once to that behavior like it works for columns.

  • ironDanironDan Member Posts: 148
    @MotherHoose that was a very clever idea to solve my issue!

    Dan
Sign In or Register to comment.

© Vanilla Keystone Theme 2026