ArshadKhwajaQrew Commander8 years agoFinding Next Sequence number in a fieldWe are using a alpha numeric field in a table similar to : T1-001. How could I ensure that for a new record created, next available sequence number is available to a user in this 'required' field. I...Show More
QuickBaseCoachDQrew Captain8 years agoThe easiest way is to make a formula which uses the Record ID# For example "T1-" & Right("000" & ToText([Record ID#]),3)
Related ContentFind and Replace Field ValuesAutomatic Sequence Number FieldRoundup whole numberCalculating number of days between two date fieldsAdding number of Business Days to Date