IF Formula Help
Hello, I'm super new to quickbase and it's array of functions and commands and I'm getting a lot of info from here and the tech support! So, I'm trying to make an auto generating Job Number based o...
Forum Discussion
Can you live with the number not starting at 001 each year? That will be a whole lot simpler if you can accept that.
If you can live with that, then the formula will be
(not tested, so please post back if there are any syntax errors)
var text Dept = Case([Department ID],
"Construction", "10",
"Fabrication", "20", "error");
var text YY = Right(ToText(Year([Quote - Date of Bid])),2);
var text Number = Right("00" & ToText([Record ID#]),3);
$YY & $Number & "-" & $Dept
The formula above uses formula variables to break up the syntax into smaller bite size units.
If you can live with that, then the formula will be
(not tested, so please post back if there are any syntax errors)
var text Dept = Case([Department ID],
"Construction", "10",
"Fabrication", "20", "error");
var text YY = Right(ToText(Year([Quote - Date of Bid])),2);
var text Number = Right("00" & ToText([Record ID#]),3);
$YY & $Number & "-" & $Dept
The formula above uses formula variables to break up the syntax into smaller bite size units.
Returned this:
An identifier cannot be the same as a type name.
var text Dept = Case([Department ID],
"Construction", "10",
"Fabrication", "20", "error");
var text YY = Right(ToText(Year([Quote - Date of Bid])),2);
var text Number = Right("00" & ToText([Record ID#]),3);
$YY & $Number & "-" & $Dept
__Also when I pasted the formula into the box, it highlights "Number" and says "An Identifier must follow the type in a variable declaration."
An identifier cannot be the same as a type name.
var text Dept = Case([Department ID],
"Construction", "10",
"Fabrication", "20", "error");
var text YY = Right(ToText(Year([Quote - Date of Bid])),2);
var text Number = Right("00" & ToText([Record ID#]),3);
$YY & $Number & "-" & $Dept
__Also when I pasted the formula into the box, it highlights "Number" and says "An Identifier must follow the type in a variable declaration."