Update field for all records in table

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

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!