Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
I suggest that you just use the Record ID# of the Project as it's sequence number.
- ChristopherSmi17 years agoQrew Member
What if you want to concatenate additional text onto the record ID. It won't let you do that
- QuickBaseCoachD7 years agoQrew CaptainNo problem. Just make a new formula Text field to do that. The Key field will still be the [Record Id#] field, but you can use the other field wherever you like.
- BlancaAnderson6 years agoQrew Assistant CaptainWhat would this formula look like if I wanted the new record ID to be the first letter of a field plus the record ID? TIA
- QuickBaseCoachD6 years agoQrew CaptainIt would be a formula text field like
Left([Project Name],1) & ToText([Record ID#]) - BlancaAnderson6 years agoQrew Assistant CaptainThank you!