RickPutnam
6 years agoQrew Cadet
Best way to update several records at once
Greetings,
What might be the best way to select, say, 10 records and change a field value on all of them in one go?
Here's the scenario: I'm working on an app that manages photo image production for an online retailer. There's an inventory tracking aspect so that, for instance, a photographer knows where to find the widgets he's been requested to shoot. If he's picking up, say, 10 widgets to take into the studio for a session, he needs to update the locations of the 10 inventory items associated with the photo requests he's working on to indicate they are now in the studio. Similarly, when he's done, he returns them to the inventory rack and updates the app with their current location.
Doing the same action 10 times is fairly tedious, not to mention, error prone. How might I give my intrepid photographer an easier way to accomplish this task?
Thanks in advance.
------------------------------
Rick Putnam
------------------------------
What might be the best way to select, say, 10 records and change a field value on all of them in one go?
Here's the scenario: I'm working on an app that manages photo image production for an online retailer. There's an inventory tracking aspect so that, for instance, a photographer knows where to find the widgets he's been requested to shoot. If he's picking up, say, 10 widgets to take into the studio for a session, he needs to update the locations of the 10 inventory items associated with the photo requests he's working on to indicate they are now in the studio. Similarly, when he's done, he returns them to the inventory rack and updates the app with their current location.
Doing the same action 10 times is fairly tedious, not to mention, error prone. How might I give my intrepid photographer an easier way to accomplish this task?
Thanks in advance.
------------------------------
Rick Putnam
------------------------------