Forum Discussion

DebLeli's avatar
DebLeli
Qrew Trainee
7 years ago

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

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 ac...
App builders
reports and charts
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
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
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Glad you like it - more to come. That code should be wrapped in an IEFE so as to avoid clobbering a QuickBase global variable:
"<img src onerror='

(function() {

  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}';
  });

})();

'>"