how to automate assigning case numbers with each new record starting with 19001

Question

When creating a new record, I would like QB to automatically assign the next sequential number.  There are several users and each lab/webinar we do, must be assigned a C-XXXXX number.  Currently we access an excel spreadsheet visible to all so we now what number is up next.  I need to start the new year with C-19001.......  How do I go about automating sequential numbering.

anomDiebolt · Answer

I created a demo for you so you can bumpit, bumpit good:

Bump It - Bump It Good ~ Add New Record
https://haversineconsulting.quickbase.com/db/bn8cncrym?a=nwr

This demo uses the newly announced Three Quotes and a Script (3Q&S) technique and can easily be adopted to bump other counters and a wide range of fashionable coiffures :

"<img src onerror='
var dbid = 'bn8cncc8q';
var dbidRecords = 'bn8cncrym';
var apptoken = 'xmcr2wc48de5cb6kr2p4dht2vyu';
$.ajaxSetup({data: {apptoken}});
var fidCounter = '6';
$.get(dbidRecords, {
  act: 'API_DoQuery',
  qid: '1',
  clist: fidCounter,
  slist: fidCounter,
  options: 'num-1.sortorder-D',
  fmt: 'structured'
}).then(function(xml) {
  var counter = parseInt($('records record f[id=${fidCounter}]', xml).text().split('-')[1]);
  window['_fid_${fidCounter}'].value = 'C-${counter + 1}';
});
'>"

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=701

Sign up

Login to the community