then the year. and then starting at 10000 and using the record ID#.
I'm new to "formulas and I am stumped
This is what I initially came up with but the error tells me that "There are extra characters beyond the end of the formula."
"TORC"Year(Date d)"-"([Record ID#]+10000)
This is what I would like to see:
TORC17-100001
-
160 Points
Posted 1 year ago
-
4,430 Points
Your new field would have to be a formula text field by data type.
"TORC" & Year(Date d) & "-" & ([Record ID#]+10000)
see if that cleans it up a bit.
-
1,988 Points
"TORC" & Year(Date d) & "-" & ([Record ID#]+10000)
-
160 Points
"Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets."
QuickBaseCoach App Dev./Training, Champion
-
59,250 Points
-
1,988 Points
"TORC" & Right(ToText(Year([date_field])),2) & "-" & [Record ID#]+10000
QuickBaseCoach App Dev./Training, Champion
-
60,058 Points
Try this
"TORC"
& Right(ToText(Year([Date d])),2)
& "-"
& ToText([Record ID#]+10000)
QuickBaseCoach App Dev./Training, Champion
-
60,058 Points
I think my formula has the best chance for first round syntax errors being clean.
The field for date d will need be used as [date d]
-
160 Points
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
"TORC"
& Right(ToText(Year(date d)),2)
& "-"
& ToText([Record ID#]+10000)
QuickBaseCoach App Dev./Training, Champion
-
60,058 Points
& Right(ToText(Year([date d])),2)
& "-"
& ToText([Record ID#]+10000)
-
1,988 Points
QuickBaseCoach App Dev./Training, Champion
-
60,058 Points
Maybe he wants
"TORC"
& Right(ToText(Year(ToDate([Date Created]))),2)
& "-"
& ToText([Record ID#]+10000)
-
160 Points
"TORC"
& Right(ToText(Year([Request Date])),2)
& "-"
& ToText([Record ID#]+10000)
Thank you everyone....
-
90 Points
Being new to QB, I'm having to decipher what you guys are saying about the fields.
In a new test table, I created a formula-text field and placed the above formula in it. I created a 'Request Date' field to satisfy the arguement, and it populates the 'TORC-' but not a number.
Could someone please briefly explain what else I'm missing to test this? The Noob wants to learn.
Thank you so much in advance!
-Kyle
QuickBaseCoach App Dev./Training, Champion
-
60,058 Points
Also, please post your formula.
-
90 Points
I'm so sorry I wasted your time, and thank you so much for your help.
-Kyle
This conversation is no longer open for comments or replies.
This conversation is no longer open for comments or replies.
Related Categories
-
App builders
- 842 Conversations
- 42 Followers
-
Errors
- 96 Conversations
- 4 Followers
Chris
Wade Davis
"TORC" & Year( Date d) & "-" & [Record ID#]+10000
Returned Error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
Chuck Grigsby