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