Forum Discussion
- ChrisChrisQrew Assistant Captain
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.
- ChrisChrisQrew Assistant CaptainThe last term would not need the parenthesis wrapped around it.
- WadeDavis1Qrew TraineeWith or without the parentheses
"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. - ChuckGrigsbyQrew Cadetreplace date d with the name of your date field Year([date field])
- ChuckGrigsbyQrew CadetTry this.
"TORC" & Year(Date d) & "-" & ([Record ID#]+10000)- WadeDavis1Qrew TraineeAlso Received Error:
"Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. - QuickBaseCoachDQrew CaptainPlease post your formula and we will correct it.
- ChuckGrigsbyQrew CadetI feel like it should be this if its a formula text field and a date field as proper data type.
"TORC" & Right(ToText(Year([date_field])),2) & "-" & [Record ID#]+10000
- QuickBaseCoachDQrew CaptainNot tested but try this. Let me know if there are syntax errors.
Try this
"TORC"
& Right(ToText(Year([Date d])),2)
& "-"
& ToText([Record ID#]+10000) - QuickBaseCoachDQrew CaptainI see everyone responded :)
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]- WadeDavis1Qrew TraineeThis returned the error:
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) - QuickBaseCoachDQrew CaptainTORC"
& Right(ToText(Year([date d])),2)
& "-"
& ToText([Record ID#]+10000) - ChuckGrigsbyQrew CadetI wonder if he doesn't have a date field and it should be Year(Today())
- WadeDavis1Qrew TraineeFinally got it.
"TORC"
& Right(ToText(Year([Request Date])),2)
& "-"
& ToText([Record ID#]+10000)
Thank you everyone.... - KyleChase1Qrew TraineeI also (as a result of attempting to automate a manual input process) am attempting to do the same thing. However, my question is about the structure rather than the formula.
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 - QuickBaseCoachDQrew CaptainAre you viewing a saved record? That full formula will not calculate until the record is saved and a Record ID# is assigned to that record.
Also, please post your formula. - KyleChase1Qrew TraineeNo need. For some reason, the minute I read your post, I got it. Duh. It's not going to generate until save.
I'm so sorry I wasted your time, and thank you so much for your help.
-Kyle