Skip to main content
Question

Update field for all records in table

  • April 5, 2018
  • 0 replies
  • 36 views
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. 
    This topic has been closed for replies.

    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
    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
    • AprylStoldt
    • Author
    • Quickbase Alumni
    • April 5, 2018
    The data entry is not entered directly through quick base, it is imported from another database hourly.
    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!
    Terms & ConditionsAccessibility statement