Moving to Caspio from Quickbase and I am trying to write a formula that would use my record id which i have a s an auto number field and would like to add the 3 letters SPA in front of it
"SPA"+[@field:record_id] - this says its in valid ans I would also need 0000 zeros so the first number would be SPA00001
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Donnie
Hi,
Moving to Caspio from Quickbase and I am trying to write a formula that would use my record id which i have a s an auto number field and would like to add the 3 letters SPA in front of it
"SPA"+[@field:record_id] - this says its in valid ans I would also need 0000 zeros so the first number would be SPA00001
This is the formula I used in quickbase:
If([Record ID#]>=10000,"SPA" & ToText([Record ID#]),"SPA" & Right("0000" & ToText([Record ID#]),5))
Any help would be appreciated
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.