Update field for all records in table

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I am needing to update a field in every row of a table with a value from another field. and there is almost 23k records that need to be updated. 


[Job Tracker Reverence Number] = FID 157 (Formula Numeric)
[JobNo] = FID 199 (Numeric)

I need [JobNo] === [Job Tracker Reference Number]

I need JobNo to be a reference field for another table, and not working if its a formula field. 
I also need it to update new records they are imported into the table. 
Photo of Apryl Stoldt

Apryl Stoldt

  • 132 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Charlie

Charlie

  • 294 Points 250 badge 2x thumb
You could use a simple table to table import for your jobs table to itself.

1) import export
2) import from table
3) pick the job table (or whatever its called)
4) pick the same table as the source table
5) map recordID->recordID + job reference number -> job number (you can leave all the other fields blank)

What the above will do will basically push the value of your formula to your numeric field for every record.

Hope that helps!

Charlie
Photo of Charlie

Charlie

  • 294 Points 250 badge 2x thumb
Forgot to mention above...on an ongoing basis you could achieve pushing the formula to the numeric field in a few ways:

1) via form rule (assuming the data entry is done directly in QB)
2) via an action or QB automation builder in the future you could kick off that table to table import on every record add
Photo of Apryl Stoldt

Apryl Stoldt

  • 132 Points 100 badge 2x thumb
The data entry is not entered directly through quick base, it is imported from another database hourly.
Photo of Charlie

Charlie

  • 294 Points 250 badge 2x thumb
So I think my first reply will still work for your initial mass migration.

For your ongoing solution; is it a QB connected table or some kind of integration?

If its a connected table you would need to schedule that table to table import or run it manually (unless connected tables data writes can fire webhooks..having trouble pulling up any documentation on that one)?

If its a more traditional integration like some hosted code or a workato/zapier recipe, a simple edit to the ETL in there would do the trick!