Is it possible to select all records in a view and run a script or action that updates all the records in bulk?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
The goal is to bulk select a list of companies and run a script that will create snapshot records of each company. I want to be able to then create a report based on the snapshot records. We will run this script at the end of each month. 
Photo of John

John

  • 122 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Yes it is possible - here are two approaches:

What is the "Clear the Swamp" Technique?
https://quickbase-community.intuit.com/questions/1465790-what-is-the-clear-the-swamp-technique

How To Process Selected Records?
https://quickbase-community.intuit.com/questions/1280505-how-to-process-selected-records

If you need assistance implementing this solution fee free to contact me using the information in my profile:

https://quickbase-community.intuit.com/users/513/
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb
Can you tell me more about how these records would be "selected".  There may be a simple native solution too especially if the records are not manually selected but rather meet some criteria.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Yes you might be able to user native Search and Replace if the nature of the update is to change a field from one constant value to another constant value in all records of the report.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb
I was actually thinking of a saved table to table copy to some archive table.  Running API_RunImport&ID=10, for example.
Photo of John

John

  • 122 Points 100 badge 2x thumb
Yes, there would be certain criteria based on status (active, inactive, etc.) and a drop down field with "Account Level" options (1,2,3,4, etc). So, yes, we could have a table of the records that fit the criteria. and the purpose is to build a snapshot or archive of some of the fields at that point in time.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb
John,

You can use a saved table to table copy to do your archiving.  Go to import expert and there will be an option to copy form another table.  Build your criteria and mapping of he fields and save the settings.  The first one that you do will be number 10.



Then you can run this by making a URL formula button.

The formula would be 

URLRoot() & "db/" & [_DBID_of the target table] & "?act=API_RunImport&ID=10"