Forum Discussion

RickPutnam's avatar
RickPutnam
Qrew Cadet
6 years ago

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
------------------------------

5 Replies

  • You can use grid edit to copy & paste or on a table page you can use search & replace (you would want to make sure the report is only showing the records you want to search and replace in):




    ------------------------------
    Adam Keever
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Rick, I have a couple of other suggestions that I will post soon.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Rick, I re-read your question.
        I think we should start with the basics, like Adam suggested.  Have you ever used Grid Edit?  There are other options I can help you with if you wanted say a button to click to change the location of the record to "Studio", but it sounds like when they are put back in inventory, that there could be many different possible locations so a button solution won't work as you need to enter the location.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------