Another Custom Auto-Generated Number Request
Hello, really liking this platform a lot and we're currently stuck between this an Zoho One, on Zoho it's extremely easy to accomplish what I'm trying to accomplish, but on here it's a bit more extens...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendBelow is an example formula you can use for the Quotes. For the Jobs, what is the Department ID-estimator? Is this a static number/text or is it based on the person who did the estimate? Also, is there a reason for the three digit format? Is it possible to have more than 999 quotes for a single department?
Quotes (Formula text field)
var text ThreeDigit = Case(Length(ToText([Record ID#])),1,"00",2,"0");
var text Department = Case([Department],"Fabrication","F","Construction","B","-");
$Department & Right(ToText(Year(ToDate([Date Created]))),2) & $ThreeDigit & ToText([Record ID#])
Quotes (Formula text field)
var text ThreeDigit = Case(Length(ToText([Record ID#])),1,"00",2,"0");
var text Department = Case([Department],"Fabrication","F","Construction","B","-");
$Department & Right(ToText(Year(ToDate([Date Created]))),2) & $ThreeDigit & ToText([Record ID#])
Thank you for the help! I did receive this back when I clicked save: Formula error -- Bad or missing arguments in function call
The types of the arguments or the number of arguments supplied do not meet the requirements of the function Case.
The function is defined to be Case ( x, val1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
For Jobs, Department ID is 20 for fab and 10 for construction. Estimator would be based off of who is selected from a drop-down or something along those lines. The three digit format is fine, because we honestly don't bid that many projects. Our projects alone take weeks and or months, so our work is chosen somewhat carefully.
I do greatly appreciate your help though! :)
The types of the arguments or the number of arguments supplied do not meet the requirements of the function Case.
The function is defined to be Case ( x, val1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
- Choose the right number and type of arguments.
- Use a type conversion function to convert the arguments you are using to the correct type.
- Choose a different function."
For Jobs, Department ID is 20 for fab and 10 for construction. Estimator would be based off of who is selected from a drop-down or something along those lines. The three digit format is fine, because we honestly don't bid that many projects. Our projects alone take weeks and or months, so our work is chosen somewhat carefully.
I do greatly appreciate your help though! :)