Can I create a button that will update a field of every record in a report?

  • 0
  • 2
  • Question
  • Updated 5 months ago
  • Answered
I want a button at the top of a report so I can flip the status of items within the report to "Complete." Status is a multiple choice text field in this situation. Is this possible? 
Photo of Adam

Adam

  • 730 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
Can I assume that you have tried Grid Edit and its not good enough for your needs?  Are you aware that you can edit the first cell and then highlight the whole column header and then right click to fill down.

Are you also aware of "search and replace" in the more .. menu.

I just want to get the easy solutions out of the way before we get into more complicated suggestions.
Photo of Adam

Adam

  • 730 Points 500 badge 2x thumb
I am aware of these but I'm hoping to set this up for less technical users. Everyone loves a button. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
OK, so there are ways to mass update a set of records with a button, but there needs to be a way to identify the "set".  Simply being on a random report with a bunch of simple or perhaps very complex filters is not enough to be able to call an API to do a mass update.  But if there are a a limited number of standard filters for the report there are some approaches, but there is nothing simple.
Photo of Adam

Adam

  • 730 Points 500 badge 2x thumb
I usually arrive at this set of records via a batch search, as set up here: 

https://community.quickbase.com/quickbase/topics/search-bar-increase-character-limit-past-250

Would this be enough to work with natively? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
Yes! It would.
Photo of Risp

Risp

  • 166 Points 100 badge 2x thumb
I did not follow, could you break this down to a list of steps that one would need to do to accomplish this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
You will need to go through that thread and follow the steps and ask specific questions, or else contact me via my website QuickBaseCoach.com for one on one assistance