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
This may screenshot may help understand what's going on:



In a nutshell we are using a native RichText Formula field consisting of an <img> tag without specifying an image. Since no image is specified a loading error is generated resulting in the execution the onerror handler. The formula and onerror handler is specially crafted using three different quote characters which allows us to write our JavaScript in a readable fashion by simply using backtick quotes (ie ') in the JavaScript. What could be easier?